csvbase is a simple website for sharing table data. Join the discord.
Table of contents
The basics: auth and content negotiation
Authentication
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.
Content negotiation
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.
The API: endpoint-by-endpoint
There are three kinds of thing in csvbase:
- users
- tables
- rows
While there's no API for users so far, there is for tables and rows.
Tables
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.
Reading a table
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
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"
}
Creating a new row
POST to https://<some_user>:<some_api_key>@csvbase.com/zsvbcncv/Test/rows/
Example body
{
"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
}
}
Example response
{
"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.
Reading a row
GET from https://csvbase.com/zsvbcncv/Test/rows/1
No body is provided with this request. Status code 200 upon success.
Example response
{
"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"
}
Updating an existing row
PUT to https://<some_user>:<some_api_key>@csvbase.com/zsvbcncv/Test/rows/1
Example body
{
"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"
}
Response
Upon success the body you sent will be echoed back, with status code 200.
Deleting a row
DELETE from https://<some_user>:<some_api_key>@csvbase.com/zsvbcncv/Test/rows/1
No body is required. Status code 204 upon success.