csvbase is a simple website for sharing table data. Join the discord.
With CSVBase, you authenticate using by putting your username and API key straight in the url (known as "HTTP "basic" auth").
Here's an example:
https://<some_user>:<some_api_key>@csvbase.com/zsvbcncv/Test
Basic auth is widely supported and is usually accepted anywhere that accepts urls.
However, zsvbcncv/Test is public so auth is needed only for writes.
CSVBase APIs use content negotiation to decide what formats are in use. This means it consults HTTP headers to decide what format to send back in response to a request.
It important that you set the Content-Type
and Accept
headers to be the mimetype you want:
typically that is application/json
for both. If you fail to
include these headers in your requests, the API will still work but
CSVBase will pick a sensible default: CSV for tables, JSON for rows.
You can bypass content negotiation for read-only requests by appending a
file extension to the url, eg .json
. Here's an example
of that (same resource as above):
https://<some_user>:<some_api_key>@csvbase.com/zsvbcncv/Test.json
This is useful when dealing with software where you aren't able to set headers.
There are three kinds of thing in csvbase:
While there's no API for users so far, there is for tables and rows.
This table looks like this in JSON:
{ "name": "Test", "is_public": true, "caption": "", "licence": null, "created": "2025-02-22T17:19:02.813029+00:00", "last_changed": "2025-02-22T17:19:02.756682+00:00", "columns": [ { "name": "csvbase_row_id", "type": "integer" }, { "name": "team_home", "type": "string" }, { "name": "team_away", "type": "string" }, { "name": "rest_days_home", "type": "float" }, { "name": "rest_days_away", "type": "float" }, { "name": "travel_dist_home", "type": "float" }, { "name": "travel_dist_away", "type": "float" }, { "name": "score_difference_target", "type": "float" }, { "name": "team_minutes_home_team", "type": "float" }, { "name": "F_tech_home_team", "type": "float" }, { "name": "FGM_3_home_team", "type": "float" }, { "name": "BLK_home_team", "type": "float" }, { "name": "OREB_home_team", "type": "float" }, { "name": "FTA_home_team", "type": "float" }, { "name": "DREB_home_team", "type": "float" }, { "name": "AST_home_team", "type": "float" }, { "name": "FTM_home_team", "type": "float" }, { "name": "FGM_2_home_team", "type": "float" }, { "name": "FGA_3_home_team", "type": "float" }, { "name": "team_score_home_team", "type": "float" }, { "name": "TOV_home_team", "type": "float" }, { "name": "TOV_team_home_team", "type": "float" }, { "name": "F_personal_home_team", "type": "float" }, { "name": "STL_home_team", "type": "float" }, { "name": "attendance_home_team", "type": "float" }, { "name": "tz_dif_H_E_home_team", "type": "float" }, { "name": "opponent_team_score_home_team", "type": "float" }, { "name": "largest_lead_home_team", "type": "float" }, { "name": "FGA_2_home_team", "type": "float" }, { "name": "OT_length_min_tot_home_team", "type": "float" }, { "name": "rest_days_home_team", "type": "float" }, { "name": "possession_home_team", "type": "float" }, { "name": "prev_game_dist_home_team", "type": "float" }, { "name": "winning_percentage_home_team", "type": "float" }, { "name": "travel_dist_home_team", "type": "float" }, { "name": "points_scored_per_game_home_team", "type": "float" }, { "name": "pace_home_team", "type": "float" }, { "name": "opp_ediff_home_team", "type": "float" }, { "name": "points_allowed_per_game_home_team", "type": "float" }, { "name": "gff_home_team", "type": "float" }, { "name": "game_eff_diff_home_team", "type": "float" }, { "name": "games_home_team", "type": "float" }, { "name": "total_points_home_team", "type": "float" }, { "name": "off_reb_pct_home_team", "type": "float" }, { "name": "def_reb_pct_home_team", "type": "float" }, { "name": "ft_rate_home_team", "type": "float" }, { "name": "play_percent_home_team", "type": "float" }, { "name": "total_points_allowed_home_team", "type": "float" }, { "name": "sum_possessions_home_team", "type": "float" }, { "name": "avg_possessions_home_team", "type": "float" }, { "name": "average_pace_home_team", "type": "float" }, { "name": "avg_game_eff_diff_home_team", "type": "float" }, { "name": "cons_home_team", "type": "float" }, { "name": "avg_gff_home_team", "type": "float" }, { "name": "average_points_differential_home_team", "type": "float" }, { "name": "oeff_home_team", "type": "float" }, { "name": "notD1_incomplete_home", "type": "float" }, { "name": "deff_home_team", "type": "float" }, { "name": "ediff_home_team", "type": "float" }, { "name": "tff_home_team", "type": "float" }, { "name": "ewin_home_team", "type": "float" }, { "name": "pwin_home_team", "type": "float" }, { "name": "oediff_home_team", "type": "float" }, { "name": "winning_percentage_away_team", "type": "float" }, { "name": "points_scored_per_game_away_team", "type": "float" }, { "name": "points_allowed_per_game_away_team", "type": "float" }, { "name": "games_away_team", "type": "float" }, { "name": "total_points_away_team", "type": "float" }, { "name": "total_points_allowed_away_team", "type": "float" }, { "name": "sum_possessions_away_team", "type": "float" }, { "name": "avg_possessions_away_team", "type": "float" }, { "name": "average_pace_away_team", "type": "float" }, { "name": "avg_game_eff_diff_away_team", "type": "float" }, { "name": "cons_away_team", "type": "float" }, { "name": "avg_gff_away_team", "type": "float" }, { "name": "average_points_differential_away_team", "type": "float" }, { "name": "notD1_incomplete_away", "type": "float" }, { "name": "team_minutes_away_team", "type": "float" }, { "name": "pace_away_team", "type": "float" }, { "name": "game_eff_diff_away_team", "type": "float" }, { "name": "gff_away_team", "type": "float" }, { "name": "oeff_away_team", "type": "float" }, { "name": "opp_ediff_away_team", "type": "float" }, { "name": "off_reb_pct_away_team", "type": "float" }, { "name": "def_reb_pct_away_team", "type": "float" }, { "name": "ft_rate_away_team", "type": "float" }, { "name": "play_percent_away_team", "type": "float" }, { "name": "F_personal_away_team", "type": "float" }, { "name": "team_score_away_team", "type": "float" }, { "name": "rest_days_away_team", "type": "float" }, { "name": "attendance_away_team", "type": "float" }, { "name": "tz_dif_H_E_away_team", "type": "float" }, { "name": "prev_game_dist_away_team", "type": "float" }, { "name": "travel_dist_away_team", "type": "float" }, { "name": "possession_away_team", "type": "float" }, { "name": "opponent_team_score_away_team", "type": "float" }, { "name": "largest_lead_away_team", "type": "float" }, { "name": "BLK_away_team", "type": "float" }, { "name": "STL_away_team", "type": "float" }, { "name": "TOV_away_team", "type": "float" }, { "name": "TOV_team_away_team", "type": "float" }, { "name": "DREB_away_team", "type": "float" }, { "name": "FGA_2_away_team", "type": "float" }, { "name": "FGM_2_away_team", "type": "float" }, { "name": "FGA_3_away_team", "type": "float" }, { "name": "FGM_3_away_team", "type": "float" }, { "name": "FTA_away_team", "type": "float" }, { "name": "FTM_away_team", "type": "float" }, { "name": "AST_away_team", "type": "float" }, { "name": "OREB_away_team", "type": "float" }, { "name": "F_tech_away_team", "type": "float" }, { "name": "OT_length_min_tot_away_team", "type": "float" }, { "name": "deff_away_team", "type": "float" }, { "name": "ediff_away_team", "type": "float" }, { "name": "tff_away_team", "type": "float" }, { "name": "ewin_away_team", "type": "float" }, { "name": "pwin_away_team", "type": "float" }, { "name": "oediff_away_team", "type": "float" } ], "approx_size": 10, "page": { "rows": [ { "row": { "team_home": "rhode_island_rams", "team_away": "north_carolina_tar_heels", "rest_days_home": 6.0, "rest_days_away": 1.0, "travel_dist_home": 0.0, "travel_dist_away": 770.0, "score_difference_target": 0.0, "team_minutes_home_team": 240.0, "F_tech_home_team": 0.107142857142857, "FGM_3_home_team": 5.10714285714285, "BLK_home_team": 3.03571428571428, "OREB_home_team": 11.75, "FTA_home_team": 14.6428571428571, "DREB_home_team": 27.5357142857142, "AST_home_team": 13.8571428571428, "FTM_home_team": 9.82142857142857, "FGM_2_home_team": 19.3214285714285, "FGA_3_home_team": 15.0357142857142, "team_score_home_team": 63.7857142857142, "TOV_home_team": 14.3571428571428, "TOV_team_home_team": 0.785714285714285, "F_personal_home_team": 12.5, "STL_home_team": 7.85714285714285, "attendance_home_team": 1084.37037037037, "tz_dif_H_E_home_team": 0.0, "opponent_team_score_home_team": 52.4642857142857, "largest_lead_home_team": 18.1785714285714, "FGA_2_home_team": 41.4642857142857, "OT_length_min_tot_home_team": 0.0, "rest_days_home_team": 4.25925925925925, "possession_home_team": 64.9641154315191, "prev_game_dist_home_team": 382.703703703703, "winning_percentage_home_team": 0.785714285714286, "travel_dist_home_team": 454.538461538461, "points_scored_per_game_home_team": 63.7857142857143, "pace_home_team": 64.9641154315191, "opp_ediff_home_team": 1.08903417662952, "points_allowed_per_game_home_team": 52.4642857142857, "gff_home_team": -0.0339499122775174, "game_eff_diff_home_team": 16.210029487144, "games_home_team": 28.0, "total_points_home_team": 1786.0, "off_reb_pct_home_team": 0.354530530295122, "def_reb_pct_home_team": 0.752504172501668, "ft_rate_home_team": 0.264296646981574, "play_percent_home_team": 0.403667114846906, "total_points_allowed_home_team": 1469.0, "sum_possessions_home_team": 1818.99523208253, "avg_possessions_home_team": 64.9641154315191, "average_pace_home_team": 64.9641154315191, "avg_game_eff_diff_home_team": 16.210029487144, "cons_home_team": 25.5992152583661, "avg_gff_home_team": -0.0339499122775174, "average_points_differential_home_team": 11.3214285714285, "oeff_home_team": 98.1860737455171, "notD1_incomplete_home": 0.0, "deff_home_team": 80.7588702867663, "ediff_home_team": 17.4272034587507, "tff_home_team": -0.0339499122775174, "ewin_home_team": 0.739555411615853, "pwin_home_team": 0.872778745644599, "oediff_home_team": 1.08903417662952, "winning_percentage_away_team": 0.777777777777778, "points_scored_per_game_away_team": 74.2962962962963, "points_allowed_per_game_away_team": 55.8518518518519, "games_away_team": 27.0, "total_points_away_team": 2006.0, "total_points_allowed_away_team": 1508.0, "sum_possessions_away_team": 1961.59128401616, "avg_possessions_away_team": 72.6515290376357, "average_pace_away_team": 72.3916777293043, "avg_game_eff_diff_away_team": 24.766471125696, "cons_away_team": 31.3839730901777, "avg_gff_away_team": -0.0061441784753306, "average_points_differential_away_team": 18.4444444444444, "notD1_incomplete_away": 0.0, "team_minutes_away_team": 240.925925925925, "pace_away_team": 72.3916777293043, "game_eff_diff_away_team": 24.766471125696, "gff_away_team": -0.00614417847533067, "oeff_away_team": 102.26391279089, "opp_ediff_away_team": 4.5553930433333, "off_reb_pct_away_team": 0.34159056907685, "def_reb_pct_away_team": 0.723682241665781, "ft_rate_away_team": 0.275133353571784, "play_percent_away_team": 0.388721329318759, "F_personal_away_team": 15.8888888888888, "team_score_away_team": 74.2962962962962, "rest_days_away_team": 4.42307692307692, "attendance_away_team": 2598.57692307692, "tz_dif_H_E_away_team": 0.0, "prev_game_dist_away_team": 487.538461538461, "travel_dist_away_team": 604.333333333333, "possession_away_team": 72.6515290376357, "opponent_team_score_away_team": 55.8518518518518, "largest_lead_away_team": 26.8148148148148, "BLK_away_team": 3.92592592592592, "STL_away_team": 9.81481481481481, "TOV_away_team": 13.7777777777777, "TOV_team_away_team": 0.444444444444444, "DREB_away_team": 28.7407407407407, "FGA_2_away_team": 47.3703703703703, "FGM_2_away_team": 21.2962962962962, "FGA_3_away_team": 18.8518518518518, "FGM_3_away_team": 5.96296296296296, "FTA_away_team": 19.5185185185185, "FTM_away_team": 13.8148148148148, "AST_away_team": 14.1481481481481, "OREB_away_team": 14.8148148148148, "F_tech_away_team": 0.148148148148148, "OT_length_min_tot_away_team": 0.185185185185185, "deff_away_team": 76.8763611608488, "ediff_away_team": 25.3875516300416, "tff_away_team": -0.0061441784753306, "ewin_away_team": 0.792126899936418, "pwin_away_team": 1.10731707317073, "oediff_away_team": 4.5553930433333 }, "row_id": 1, "url": "https://csvbase.com/zsvbcncv/Test/rows/1" } ], "previous_page_url": null, "next_page_url": "https://csvbase.com/zsvbcncv/Test?op=gt&n=1" } }
Note that there is the top-level metadata, plus a "page" of rows. Tables
are often (usually) too big to be put into a single JSON object so they
are "paginated". To follow the table, page by page, you can use
the next_page_url
and previous_page_url
dictionary keys. They will be null
if you've reached
the end or are at the beginning, respectively.
GET
from https://csvbase.com/zsvbcncv/Test
You'll need to follow the next_page_url
urls (described
above) to get to the end of the table.
Rows from zsvbcncv/Test look like this in JSON:
{ "row": { "team_home": "rhode_island_rams", "team_away": "north_carolina_tar_heels", "rest_days_home": 6.0, "rest_days_away": 1.0, "travel_dist_home": 0.0, "travel_dist_away": 770.0, "score_difference_target": 0.0, "team_minutes_home_team": 240.0, "F_tech_home_team": 0.107142857142857, "FGM_3_home_team": 5.10714285714285, "BLK_home_team": 3.03571428571428, "OREB_home_team": 11.75, "FTA_home_team": 14.6428571428571, "DREB_home_team": 27.5357142857142, "AST_home_team": 13.8571428571428, "FTM_home_team": 9.82142857142857, "FGM_2_home_team": 19.3214285714285, "FGA_3_home_team": 15.0357142857142, "team_score_home_team": 63.7857142857142, "TOV_home_team": 14.3571428571428, "TOV_team_home_team": 0.785714285714285, "F_personal_home_team": 12.5, "STL_home_team": 7.85714285714285, "attendance_home_team": 1084.37037037037, "tz_dif_H_E_home_team": 0.0, "opponent_team_score_home_team": 52.4642857142857, "largest_lead_home_team": 18.1785714285714, "FGA_2_home_team": 41.4642857142857, "OT_length_min_tot_home_team": 0.0, "rest_days_home_team": 4.25925925925925, "possession_home_team": 64.9641154315191, "prev_game_dist_home_team": 382.703703703703, "winning_percentage_home_team": 0.785714285714286, "travel_dist_home_team": 454.538461538461, "points_scored_per_game_home_team": 63.7857142857143, "pace_home_team": 64.9641154315191, "opp_ediff_home_team": 1.08903417662952, "points_allowed_per_game_home_team": 52.4642857142857, "gff_home_team": -0.0339499122775174, "game_eff_diff_home_team": 16.210029487144, "games_home_team": 28.0, "total_points_home_team": 1786.0, "off_reb_pct_home_team": 0.354530530295122, "def_reb_pct_home_team": 0.752504172501668, "ft_rate_home_team": 0.264296646981574, "play_percent_home_team": 0.403667114846906, "total_points_allowed_home_team": 1469.0, "sum_possessions_home_team": 1818.99523208253, "avg_possessions_home_team": 64.9641154315191, "average_pace_home_team": 64.9641154315191, "avg_game_eff_diff_home_team": 16.210029487144, "cons_home_team": 25.5992152583661, "avg_gff_home_team": -0.0339499122775174, "average_points_differential_home_team": 11.3214285714285, "oeff_home_team": 98.1860737455171, "notD1_incomplete_home": 0.0, "deff_home_team": 80.7588702867663, "ediff_home_team": 17.4272034587507, "tff_home_team": -0.0339499122775174, "ewin_home_team": 0.739555411615853, "pwin_home_team": 0.872778745644599, "oediff_home_team": 1.08903417662952, "winning_percentage_away_team": 0.777777777777778, "points_scored_per_game_away_team": 74.2962962962963, "points_allowed_per_game_away_team": 55.8518518518519, "games_away_team": 27.0, "total_points_away_team": 2006.0, "total_points_allowed_away_team": 1508.0, "sum_possessions_away_team": 1961.59128401616, "avg_possessions_away_team": 72.6515290376357, "average_pace_away_team": 72.3916777293043, "avg_game_eff_diff_away_team": 24.766471125696, "cons_away_team": 31.3839730901777, "avg_gff_away_team": -0.0061441784753306, "average_points_differential_away_team": 18.4444444444444, "notD1_incomplete_away": 0.0, "team_minutes_away_team": 240.925925925925, "pace_away_team": 72.3916777293043, "game_eff_diff_away_team": 24.766471125696, "gff_away_team": -0.00614417847533067, "oeff_away_team": 102.26391279089, "opp_ediff_away_team": 4.5553930433333, "off_reb_pct_away_team": 0.34159056907685, "def_reb_pct_away_team": 0.723682241665781, "ft_rate_away_team": 0.275133353571784, "play_percent_away_team": 0.388721329318759, "F_personal_away_team": 15.8888888888888, "team_score_away_team": 74.2962962962962, "rest_days_away_team": 4.42307692307692, "attendance_away_team": 2598.57692307692, "tz_dif_H_E_away_team": 0.0, "prev_game_dist_away_team": 487.538461538461, "travel_dist_away_team": 604.333333333333, "possession_away_team": 72.6515290376357, "opponent_team_score_away_team": 55.8518518518518, "largest_lead_away_team": 26.8148148148148, "BLK_away_team": 3.92592592592592, "STL_away_team": 9.81481481481481, "TOV_away_team": 13.7777777777777, "TOV_team_away_team": 0.444444444444444, "DREB_away_team": 28.7407407407407, "FGA_2_away_team": 47.3703703703703, "FGM_2_away_team": 21.2962962962962, "FGA_3_away_team": 18.8518518518518, "FGM_3_away_team": 5.96296296296296, "FTA_away_team": 19.5185185185185, "FTM_away_team": 13.8148148148148, "AST_away_team": 14.1481481481481, "OREB_away_team": 14.8148148148148, "F_tech_away_team": 0.148148148148148, "OT_length_min_tot_away_team": 0.185185185185185, "deff_away_team": 76.8763611608488, "ediff_away_team": 25.3875516300416, "tff_away_team": -0.0061441784753306, "ewin_away_team": 0.792126899936418, "pwin_away_team": 1.10731707317073, "oediff_away_team": 4.5553930433333 }, "row_id": 1, "url": "https://csvbase.com/zsvbcncv/Test/rows/1" }
POST
to https://<some_user>:<some_api_key>@csvbase.com/zsvbcncv/Test/rows/
{ "row": { "team_home": "rhode_island_rams", "team_away": "north_carolina_tar_heels", "rest_days_home": 6.0, "rest_days_away": 1.0, "travel_dist_home": 0.0, "travel_dist_away": 770.0, "score_difference_target": 0.0, "team_minutes_home_team": 240.0, "F_tech_home_team": 0.107142857142857, "FGM_3_home_team": 5.10714285714285, "BLK_home_team": 3.03571428571428, "OREB_home_team": 11.75, "FTA_home_team": 14.6428571428571, "DREB_home_team": 27.5357142857142, "AST_home_team": 13.8571428571428, "FTM_home_team": 9.82142857142857, "FGM_2_home_team": 19.3214285714285, "FGA_3_home_team": 15.0357142857142, "team_score_home_team": 63.7857142857142, "TOV_home_team": 14.3571428571428, "TOV_team_home_team": 0.785714285714285, "F_personal_home_team": 12.5, "STL_home_team": 7.85714285714285, "attendance_home_team": 1084.37037037037, "tz_dif_H_E_home_team": 0.0, "opponent_team_score_home_team": 52.4642857142857, "largest_lead_home_team": 18.1785714285714, "FGA_2_home_team": 41.4642857142857, "OT_length_min_tot_home_team": 0.0, "rest_days_home_team": 4.25925925925925, "possession_home_team": 64.9641154315191, "prev_game_dist_home_team": 382.703703703703, "winning_percentage_home_team": 0.785714285714286, "travel_dist_home_team": 454.538461538461, "points_scored_per_game_home_team": 63.7857142857143, "pace_home_team": 64.9641154315191, "opp_ediff_home_team": 1.08903417662952, "points_allowed_per_game_home_team": 52.4642857142857, "gff_home_team": -0.0339499122775174, "game_eff_diff_home_team": 16.210029487144, "games_home_team": 28.0, "total_points_home_team": 1786.0, "off_reb_pct_home_team": 0.354530530295122, "def_reb_pct_home_team": 0.752504172501668, "ft_rate_home_team": 0.264296646981574, "play_percent_home_team": 0.403667114846906, "total_points_allowed_home_team": 1469.0, "sum_possessions_home_team": 1818.99523208253, "avg_possessions_home_team": 64.9641154315191, "average_pace_home_team": 64.9641154315191, "avg_game_eff_diff_home_team": 16.210029487144, "cons_home_team": 25.5992152583661, "avg_gff_home_team": -0.0339499122775174, "average_points_differential_home_team": 11.3214285714285, "oeff_home_team": 98.1860737455171, "notD1_incomplete_home": 0.0, "deff_home_team": 80.7588702867663, "ediff_home_team": 17.4272034587507, "tff_home_team": -0.0339499122775174, "ewin_home_team": 0.739555411615853, "pwin_home_team": 0.872778745644599, "oediff_home_team": 1.08903417662952, "winning_percentage_away_team": 0.777777777777778, "points_scored_per_game_away_team": 74.2962962962963, "points_allowed_per_game_away_team": 55.8518518518519, "games_away_team": 27.0, "total_points_away_team": 2006.0, "total_points_allowed_away_team": 1508.0, "sum_possessions_away_team": 1961.59128401616, "avg_possessions_away_team": 72.6515290376357, "average_pace_away_team": 72.3916777293043, "avg_game_eff_diff_away_team": 24.766471125696, "cons_away_team": 31.3839730901777, "avg_gff_away_team": -0.0061441784753306, "average_points_differential_away_team": 18.4444444444444, "notD1_incomplete_away": 0.0, "team_minutes_away_team": 240.925925925925, "pace_away_team": 72.3916777293043, "game_eff_diff_away_team": 24.766471125696, "gff_away_team": -0.00614417847533067, "oeff_away_team": 102.26391279089, "opp_ediff_away_team": 4.5553930433333, "off_reb_pct_away_team": 0.34159056907685, "def_reb_pct_away_team": 0.723682241665781, "ft_rate_away_team": 0.275133353571784, "play_percent_away_team": 0.388721329318759, "F_personal_away_team": 15.8888888888888, "team_score_away_team": 74.2962962962962, "rest_days_away_team": 4.42307692307692, "attendance_away_team": 2598.57692307692, "tz_dif_H_E_away_team": 0.0, "prev_game_dist_away_team": 487.538461538461, "travel_dist_away_team": 604.333333333333, "possession_away_team": 72.6515290376357, "opponent_team_score_away_team": 55.8518518518518, "largest_lead_away_team": 26.8148148148148, "BLK_away_team": 3.92592592592592, "STL_away_team": 9.81481481481481, "TOV_away_team": 13.7777777777777, "TOV_team_away_team": 0.444444444444444, "DREB_away_team": 28.7407407407407, "FGA_2_away_team": 47.3703703703703, "FGM_2_away_team": 21.2962962962962, "FGA_3_away_team": 18.8518518518518, "FGM_3_away_team": 5.96296296296296, "FTA_away_team": 19.5185185185185, "FTM_away_team": 13.8148148148148, "AST_away_team": 14.1481481481481, "OREB_away_team": 14.8148148148148, "F_tech_away_team": 0.148148148148148, "OT_length_min_tot_away_team": 0.185185185185185, "deff_away_team": 76.8763611608488, "ediff_away_team": 25.3875516300416, "tff_away_team": -0.0061441784753306, "ewin_away_team": 0.792126899936418, "pwin_away_team": 1.10731707317073, "oediff_away_team": 4.5553930433333 } }
{ "row": { "team_home": "rhode_island_rams", "team_away": "north_carolina_tar_heels", "rest_days_home": 6.0, "rest_days_away": 1.0, "travel_dist_home": 0.0, "travel_dist_away": 770.0, "score_difference_target": 0.0, "team_minutes_home_team": 240.0, "F_tech_home_team": 0.107142857142857, "FGM_3_home_team": 5.10714285714285, "BLK_home_team": 3.03571428571428, "OREB_home_team": 11.75, "FTA_home_team": 14.6428571428571, "DREB_home_team": 27.5357142857142, "AST_home_team": 13.8571428571428, "FTM_home_team": 9.82142857142857, "FGM_2_home_team": 19.3214285714285, "FGA_3_home_team": 15.0357142857142, "team_score_home_team": 63.7857142857142, "TOV_home_team": 14.3571428571428, "TOV_team_home_team": 0.785714285714285, "F_personal_home_team": 12.5, "STL_home_team": 7.85714285714285, "attendance_home_team": 1084.37037037037, "tz_dif_H_E_home_team": 0.0, "opponent_team_score_home_team": 52.4642857142857, "largest_lead_home_team": 18.1785714285714, "FGA_2_home_team": 41.4642857142857, "OT_length_min_tot_home_team": 0.0, "rest_days_home_team": 4.25925925925925, "possession_home_team": 64.9641154315191, "prev_game_dist_home_team": 382.703703703703, "winning_percentage_home_team": 0.785714285714286, "travel_dist_home_team": 454.538461538461, "points_scored_per_game_home_team": 63.7857142857143, "pace_home_team": 64.9641154315191, "opp_ediff_home_team": 1.08903417662952, "points_allowed_per_game_home_team": 52.4642857142857, "gff_home_team": -0.0339499122775174, "game_eff_diff_home_team": 16.210029487144, "games_home_team": 28.0, "total_points_home_team": 1786.0, "off_reb_pct_home_team": 0.354530530295122, "def_reb_pct_home_team": 0.752504172501668, "ft_rate_home_team": 0.264296646981574, "play_percent_home_team": 0.403667114846906, "total_points_allowed_home_team": 1469.0, "sum_possessions_home_team": 1818.99523208253, "avg_possessions_home_team": 64.9641154315191, "average_pace_home_team": 64.9641154315191, "avg_game_eff_diff_home_team": 16.210029487144, "cons_home_team": 25.5992152583661, "avg_gff_home_team": -0.0339499122775174, "average_points_differential_home_team": 11.3214285714285, "oeff_home_team": 98.1860737455171, "notD1_incomplete_home": 0.0, "deff_home_team": 80.7588702867663, "ediff_home_team": 17.4272034587507, "tff_home_team": -0.0339499122775174, "ewin_home_team": 0.739555411615853, "pwin_home_team": 0.872778745644599, "oediff_home_team": 1.08903417662952, "winning_percentage_away_team": 0.777777777777778, "points_scored_per_game_away_team": 74.2962962962963, "points_allowed_per_game_away_team": 55.8518518518519, "games_away_team": 27.0, "total_points_away_team": 2006.0, "total_points_allowed_away_team": 1508.0, "sum_possessions_away_team": 1961.59128401616, "avg_possessions_away_team": 72.6515290376357, "average_pace_away_team": 72.3916777293043, "avg_game_eff_diff_away_team": 24.766471125696, "cons_away_team": 31.3839730901777, "avg_gff_away_team": -0.0061441784753306, "average_points_differential_away_team": 18.4444444444444, "notD1_incomplete_away": 0.0, "team_minutes_away_team": 240.925925925925, "pace_away_team": 72.3916777293043, "game_eff_diff_away_team": 24.766471125696, "gff_away_team": -0.00614417847533067, "oeff_away_team": 102.26391279089, "opp_ediff_away_team": 4.5553930433333, "off_reb_pct_away_team": 0.34159056907685, "def_reb_pct_away_team": 0.723682241665781, "ft_rate_away_team": 0.275133353571784, "play_percent_away_team": 0.388721329318759, "F_personal_away_team": 15.8888888888888, "team_score_away_team": 74.2962962962962, "rest_days_away_team": 4.42307692307692, "attendance_away_team": 2598.57692307692, "tz_dif_H_E_away_team": 0.0, "prev_game_dist_away_team": 487.538461538461, "travel_dist_away_team": 604.333333333333, "possession_away_team": 72.6515290376357, "opponent_team_score_away_team": 55.8518518518518, "largest_lead_away_team": 26.8148148148148, "BLK_away_team": 3.92592592592592, "STL_away_team": 9.81481481481481, "TOV_away_team": 13.7777777777777, "TOV_team_away_team": 0.444444444444444, "DREB_away_team": 28.7407407407407, "FGA_2_away_team": 47.3703703703703, "FGM_2_away_team": 21.2962962962962, "FGA_3_away_team": 18.8518518518518, "FGM_3_away_team": 5.96296296296296, "FTA_away_team": 19.5185185185185, "FTM_away_team": 13.8148148148148, "AST_away_team": 14.1481481481481, "OREB_away_team": 14.8148148148148, "F_tech_away_team": 0.148148148148148, "OT_length_min_tot_away_team": 0.185185185185185, "deff_away_team": 76.8763611608488, "ediff_away_team": 25.3875516300416, "tff_away_team": -0.0061441784753306, "ewin_away_team": 0.792126899936418, "pwin_away_team": 1.10731707317073, "oediff_away_team": 4.5553930433333 }, "row_id": 1, "url": "https://csvbase.com/zsvbcncv/Test/rows/1" }
Status code 201 upon success.
GET
from https://csvbase.com/zsvbcncv/Test/rows/1
No body is provided with this request. Status code 200 upon success.
{ "row": { "team_home": "rhode_island_rams", "team_away": "north_carolina_tar_heels", "rest_days_home": 6.0, "rest_days_away": 1.0, "travel_dist_home": 0.0, "travel_dist_away": 770.0, "score_difference_target": 0.0, "team_minutes_home_team": 240.0, "F_tech_home_team": 0.107142857142857, "FGM_3_home_team": 5.10714285714285, "BLK_home_team": 3.03571428571428, "OREB_home_team": 11.75, "FTA_home_team": 14.6428571428571, "DREB_home_team": 27.5357142857142, "AST_home_team": 13.8571428571428, "FTM_home_team": 9.82142857142857, "FGM_2_home_team": 19.3214285714285, "FGA_3_home_team": 15.0357142857142, "team_score_home_team": 63.7857142857142, "TOV_home_team": 14.3571428571428, "TOV_team_home_team": 0.785714285714285, "F_personal_home_team": 12.5, "STL_home_team": 7.85714285714285, "attendance_home_team": 1084.37037037037, "tz_dif_H_E_home_team": 0.0, "opponent_team_score_home_team": 52.4642857142857, "largest_lead_home_team": 18.1785714285714, "FGA_2_home_team": 41.4642857142857, "OT_length_min_tot_home_team": 0.0, "rest_days_home_team": 4.25925925925925, "possession_home_team": 64.9641154315191, "prev_game_dist_home_team": 382.703703703703, "winning_percentage_home_team": 0.785714285714286, "travel_dist_home_team": 454.538461538461, "points_scored_per_game_home_team": 63.7857142857143, "pace_home_team": 64.9641154315191, "opp_ediff_home_team": 1.08903417662952, "points_allowed_per_game_home_team": 52.4642857142857, "gff_home_team": -0.0339499122775174, "game_eff_diff_home_team": 16.210029487144, "games_home_team": 28.0, "total_points_home_team": 1786.0, "off_reb_pct_home_team": 0.354530530295122, "def_reb_pct_home_team": 0.752504172501668, "ft_rate_home_team": 0.264296646981574, "play_percent_home_team": 0.403667114846906, "total_points_allowed_home_team": 1469.0, "sum_possessions_home_team": 1818.99523208253, "avg_possessions_home_team": 64.9641154315191, "average_pace_home_team": 64.9641154315191, "avg_game_eff_diff_home_team": 16.210029487144, "cons_home_team": 25.5992152583661, "avg_gff_home_team": -0.0339499122775174, "average_points_differential_home_team": 11.3214285714285, "oeff_home_team": 98.1860737455171, "notD1_incomplete_home": 0.0, "deff_home_team": 80.7588702867663, "ediff_home_team": 17.4272034587507, "tff_home_team": -0.0339499122775174, "ewin_home_team": 0.739555411615853, "pwin_home_team": 0.872778745644599, "oediff_home_team": 1.08903417662952, "winning_percentage_away_team": 0.777777777777778, "points_scored_per_game_away_team": 74.2962962962963, "points_allowed_per_game_away_team": 55.8518518518519, "games_away_team": 27.0, "total_points_away_team": 2006.0, "total_points_allowed_away_team": 1508.0, "sum_possessions_away_team": 1961.59128401616, "avg_possessions_away_team": 72.6515290376357, "average_pace_away_team": 72.3916777293043, "avg_game_eff_diff_away_team": 24.766471125696, "cons_away_team": 31.3839730901777, "avg_gff_away_team": -0.0061441784753306, "average_points_differential_away_team": 18.4444444444444, "notD1_incomplete_away": 0.0, "team_minutes_away_team": 240.925925925925, "pace_away_team": 72.3916777293043, "game_eff_diff_away_team": 24.766471125696, "gff_away_team": -0.00614417847533067, "oeff_away_team": 102.26391279089, "opp_ediff_away_team": 4.5553930433333, "off_reb_pct_away_team": 0.34159056907685, "def_reb_pct_away_team": 0.723682241665781, "ft_rate_away_team": 0.275133353571784, "play_percent_away_team": 0.388721329318759, "F_personal_away_team": 15.8888888888888, "team_score_away_team": 74.2962962962962, "rest_days_away_team": 4.42307692307692, "attendance_away_team": 2598.57692307692, "tz_dif_H_E_away_team": 0.0, "prev_game_dist_away_team": 487.538461538461, "travel_dist_away_team": 604.333333333333, "possession_away_team": 72.6515290376357, "opponent_team_score_away_team": 55.8518518518518, "largest_lead_away_team": 26.8148148148148, "BLK_away_team": 3.92592592592592, "STL_away_team": 9.81481481481481, "TOV_away_team": 13.7777777777777, "TOV_team_away_team": 0.444444444444444, "DREB_away_team": 28.7407407407407, "FGA_2_away_team": 47.3703703703703, "FGM_2_away_team": 21.2962962962962, "FGA_3_away_team": 18.8518518518518, "FGM_3_away_team": 5.96296296296296, "FTA_away_team": 19.5185185185185, "FTM_away_team": 13.8148148148148, "AST_away_team": 14.1481481481481, "OREB_away_team": 14.8148148148148, "F_tech_away_team": 0.148148148148148, "OT_length_min_tot_away_team": 0.185185185185185, "deff_away_team": 76.8763611608488, "ediff_away_team": 25.3875516300416, "tff_away_team": -0.0061441784753306, "ewin_away_team": 0.792126899936418, "pwin_away_team": 1.10731707317073, "oediff_away_team": 4.5553930433333 }, "row_id": 1, "url": "https://csvbase.com/zsvbcncv/Test/rows/1" }
PUT
to https://<some_user>:<some_api_key>@csvbase.com/zsvbcncv/Test/rows/1
{ "row": { "team_home": "rhode_island_rams", "team_away": "north_carolina_tar_heels", "rest_days_home": 6.0, "rest_days_away": 1.0, "travel_dist_home": 0.0, "travel_dist_away": 770.0, "score_difference_target": 0.0, "team_minutes_home_team": 240.0, "F_tech_home_team": 0.107142857142857, "FGM_3_home_team": 5.10714285714285, "BLK_home_team": 3.03571428571428, "OREB_home_team": 11.75, "FTA_home_team": 14.6428571428571, "DREB_home_team": 27.5357142857142, "AST_home_team": 13.8571428571428, "FTM_home_team": 9.82142857142857, "FGM_2_home_team": 19.3214285714285, "FGA_3_home_team": 15.0357142857142, "team_score_home_team": 63.7857142857142, "TOV_home_team": 14.3571428571428, "TOV_team_home_team": 0.785714285714285, "F_personal_home_team": 12.5, "STL_home_team": 7.85714285714285, "attendance_home_team": 1084.37037037037, "tz_dif_H_E_home_team": 0.0, "opponent_team_score_home_team": 52.4642857142857, "largest_lead_home_team": 18.1785714285714, "FGA_2_home_team": 41.4642857142857, "OT_length_min_tot_home_team": 0.0, "rest_days_home_team": 4.25925925925925, "possession_home_team": 64.9641154315191, "prev_game_dist_home_team": 382.703703703703, "winning_percentage_home_team": 0.785714285714286, "travel_dist_home_team": 454.538461538461, "points_scored_per_game_home_team": 63.7857142857143, "pace_home_team": 64.9641154315191, "opp_ediff_home_team": 1.08903417662952, "points_allowed_per_game_home_team": 52.4642857142857, "gff_home_team": -0.0339499122775174, "game_eff_diff_home_team": 16.210029487144, "games_home_team": 28.0, "total_points_home_team": 1786.0, "off_reb_pct_home_team": 0.354530530295122, "def_reb_pct_home_team": 0.752504172501668, "ft_rate_home_team": 0.264296646981574, "play_percent_home_team": 0.403667114846906, "total_points_allowed_home_team": 1469.0, "sum_possessions_home_team": 1818.99523208253, "avg_possessions_home_team": 64.9641154315191, "average_pace_home_team": 64.9641154315191, "avg_game_eff_diff_home_team": 16.210029487144, "cons_home_team": 25.5992152583661, "avg_gff_home_team": -0.0339499122775174, "average_points_differential_home_team": 11.3214285714285, "oeff_home_team": 98.1860737455171, "notD1_incomplete_home": 0.0, "deff_home_team": 80.7588702867663, "ediff_home_team": 17.4272034587507, "tff_home_team": -0.0339499122775174, "ewin_home_team": 0.739555411615853, "pwin_home_team": 0.872778745644599, "oediff_home_team": 1.08903417662952, "winning_percentage_away_team": 0.777777777777778, "points_scored_per_game_away_team": 74.2962962962963, "points_allowed_per_game_away_team": 55.8518518518519, "games_away_team": 27.0, "total_points_away_team": 2006.0, "total_points_allowed_away_team": 1508.0, "sum_possessions_away_team": 1961.59128401616, "avg_possessions_away_team": 72.6515290376357, "average_pace_away_team": 72.3916777293043, "avg_game_eff_diff_away_team": 24.766471125696, "cons_away_team": 31.3839730901777, "avg_gff_away_team": -0.0061441784753306, "average_points_differential_away_team": 18.4444444444444, "notD1_incomplete_away": 0.0, "team_minutes_away_team": 240.925925925925, "pace_away_team": 72.3916777293043, "game_eff_diff_away_team": 24.766471125696, "gff_away_team": -0.00614417847533067, "oeff_away_team": 102.26391279089, "opp_ediff_away_team": 4.5553930433333, "off_reb_pct_away_team": 0.34159056907685, "def_reb_pct_away_team": 0.723682241665781, "ft_rate_away_team": 0.275133353571784, "play_percent_away_team": 0.388721329318759, "F_personal_away_team": 15.8888888888888, "team_score_away_team": 74.2962962962962, "rest_days_away_team": 4.42307692307692, "attendance_away_team": 2598.57692307692, "tz_dif_H_E_away_team": 0.0, "prev_game_dist_away_team": 487.538461538461, "travel_dist_away_team": 604.333333333333, "possession_away_team": 72.6515290376357, "opponent_team_score_away_team": 55.8518518518518, "largest_lead_away_team": 26.8148148148148, "BLK_away_team": 3.92592592592592, "STL_away_team": 9.81481481481481, "TOV_away_team": 13.7777777777777, "TOV_team_away_team": 0.444444444444444, "DREB_away_team": 28.7407407407407, "FGA_2_away_team": 47.3703703703703, "FGM_2_away_team": 21.2962962962962, "FGA_3_away_team": 18.8518518518518, "FGM_3_away_team": 5.96296296296296, "FTA_away_team": 19.5185185185185, "FTM_away_team": 13.8148148148148, "AST_away_team": 14.1481481481481, "OREB_away_team": 14.8148148148148, "F_tech_away_team": 0.148148148148148, "OT_length_min_tot_away_team": 0.185185185185185, "deff_away_team": 76.8763611608488, "ediff_away_team": 25.3875516300416, "tff_away_team": -0.0061441784753306, "ewin_away_team": 0.792126899936418, "pwin_away_team": 1.10731707317073, "oediff_away_team": 4.5553930433333 }, "row_id": 1, "url": "https://csvbase.com/zsvbcncv/Test/rows/1" }
Upon success the body you sent will be echoed back, with status code 200.
DELETE
from https://<some_user>:<some_api_key>@csvbase.com/zsvbcncv/Test/rows/1
No body is required. Status code 204 upon success.