csvbase is a simple website for sharing table data. Join the discord.

10 rows, last changed 3 weeks ago

Table of contents

  1. The basics: auth and content negotations
    1. Authentication
    2. Content negotiation
  2. The API: endpoint-by-endpoint
    1. Tables
      1. Reading a table
    2. Rows
      1. Creating a new row
      2. Reading a row
      3. Updating an existing row
      4. Deleting a row

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:

  1. users
  2. tables
  3. 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.