ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

15,570 rows where county = "Madison" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 20

fips 20

county 1

  • Madison · 15,570 ✖
Link rowid date ▲ county state fips cases deaths
2499619 2499619 2022-05-13 Madison Alabama 1089 90395 968
2499729 2499729 2022-05-13 Madison Arkansas 5087 3975 61
2499936 2499936 2022-05-13 Madison Florida 12079 5849 97
2500060 2500060 2022-05-13 Madison Georgia 13195 6950 110
2500165 2500165 2022-05-13 Madison Idaho 16065 12674 50
2500233 2500233 2022-05-13 Madison Illinois 17119 71577 866
2500327 2500327 2022-05-13 Madison Indiana 18095 32870 653
2500433 2500433 2022-05-13 Madison Iowa 19121 3181 40
2500651 2500651 2022-05-13 Madison Kentucky 21151 27833 280
2500731 2500731 2022-05-13 Madison Louisiana 22065 3264 59
2501037 2501037 2022-05-13 Madison Mississippi 28089 24189 329
2501138 2501138 2022-05-13 Madison Missouri 29123 3622 57
2501220 2501220 2022-05-13 Madison Montana 30057 1819 20
2501307 2501307 2022-05-13 Madison Nebraska 31119 9669 69
2501452 2501452 2022-05-13 Madison New York 36053 14319 127
2501542 2501542 2022-05-13 Madison North Carolina 37115 5186 81
2501692 2501692 2022-05-13 Madison Ohio 39097 9754 136
2502165 2502165 2022-05-13 Madison Tennessee 47113 30250 427
2502360 2502360 2022-05-13 Madison Texas 48313 3778 54
2502584 2502584 2022-05-13 Madison Virginia 51113 2451 41
2496361 2496361 2022-05-12 Madison Alabama 1089 90339 967
2496471 2496471 2022-05-12 Madison Arkansas 5087 3975 61
2496678 2496678 2022-05-12 Madison Florida 12079 5849 97
2496802 2496802 2022-05-12 Madison Georgia 13195 6950 110
2496907 2496907 2022-05-12 Madison Idaho 16065 12669 50
2496975 2496975 2022-05-12 Madison Illinois 17119 71499 866
2497069 2497069 2022-05-12 Madison Indiana 18095 32850 653
2497175 2497175 2022-05-12 Madison Iowa 19121 3181 40
2497393 2497393 2022-05-12 Madison Kentucky 21151 27833 280
2497473 2497473 2022-05-12 Madison Louisiana 22065 3264 59
2497779 2497779 2022-05-12 Madison Mississippi 28089 24189 329
2497880 2497880 2022-05-12 Madison Missouri 29123 3615 57
2497962 2497962 2022-05-12 Madison Montana 30057 1818 20
2498049 2498049 2022-05-12 Madison Nebraska 31119 9664 68
2498194 2498194 2022-05-12 Madison New York 36053 14319 127
2498284 2498284 2022-05-12 Madison North Carolina 37115 5186 81
2498434 2498434 2022-05-12 Madison Ohio 39097 9754 136
2498907 2498907 2022-05-12 Madison Tennessee 47113 30250 427
2499102 2499102 2022-05-12 Madison Texas 48313 3777 54
2499326 2499326 2022-05-12 Madison Virginia 51113 2448 41
2493103 2493103 2022-05-11 Madison Alabama 1089 90260 966
2493213 2493213 2022-05-11 Madison Arkansas 5087 3972 61
2493420 2493420 2022-05-11 Madison Florida 12079 5849 97
2493544 2493544 2022-05-11 Madison Georgia 13195 6950 110
2493649 2493649 2022-05-11 Madison Idaho 16065 12669 50
2493717 2493717 2022-05-11 Madison Illinois 17119 71410 866
2493811 2493811 2022-05-11 Madison Indiana 18095 32850 653
2493917 2493917 2022-05-11 Madison Iowa 19121 3181 40
2494135 2494135 2022-05-11 Madison Kentucky 21151 27833 280
2494215 2494215 2022-05-11 Madison Louisiana 22065 3262 59
2494521 2494521 2022-05-11 Madison Mississippi 28089 24189 329
2494622 2494622 2022-05-11 Madison Missouri 29123 3615 57
2494704 2494704 2022-05-11 Madison Montana 30057 1818 20
2494791 2494791 2022-05-11 Madison Nebraska 31119 9664 68
2494936 2494936 2022-05-11 Madison New York 36053 14290 127
2495026 2495026 2022-05-11 Madison North Carolina 37115 5186 81
2495176 2495176 2022-05-11 Madison Ohio 39097 9728 134
2495649 2495649 2022-05-11 Madison Tennessee 47113 30250 427
2495844 2495844 2022-05-11 Madison Texas 48313 3775 54
2496068 2496068 2022-05-11 Madison Virginia 51113 2440 41
2489845 2489845 2022-05-10 Madison Alabama 1089 90210 966
2489955 2489955 2022-05-10 Madison Arkansas 5087 3971 61
2490162 2490162 2022-05-10 Madison Florida 12079 5849 97
2490286 2490286 2022-05-10 Madison Georgia 13195 6941 110
2490391 2490391 2022-05-10 Madison Idaho 16065 12669 50
2490459 2490459 2022-05-10 Madison Illinois 17119 71341 866
2490553 2490553 2022-05-10 Madison Indiana 18095 32835 653
2490659 2490659 2022-05-10 Madison Iowa 19121 3173 40
2490877 2490877 2022-05-10 Madison Kentucky 21151 27833 280
2490957 2490957 2022-05-10 Madison Louisiana 22065 3261 59
2491263 2491263 2022-05-10 Madison Mississippi 28089 24189 329
2491364 2491364 2022-05-10 Madison Missouri 29123 3615 57
2491446 2491446 2022-05-10 Madison Montana 30057 1818 20
2491533 2491533 2022-05-10 Madison Nebraska 31119 9705 68
2491678 2491678 2022-05-10 Madison New York 36053 14264 127
2491768 2491768 2022-05-10 Madison North Carolina 37115 5165 81
2491918 2491918 2022-05-10 Madison Ohio 39097 9728 134
2492391 2492391 2022-05-10 Madison Tennessee 47113 30181 427
2492586 2492586 2022-05-10 Madison Texas 48313 3775 54
2492810 2492810 2022-05-10 Madison Virginia 51113 2438 41
2486588 2486588 2022-05-09 Madison Alabama 1089 90166 965
2486698 2486698 2022-05-09 Madison Arkansas 5087 3968 61
2486905 2486905 2022-05-09 Madison Florida 12079 5849 97
2487029 2487029 2022-05-09 Madison Georgia 13195 6941 110
2487134 2487134 2022-05-09 Madison Idaho 16065 12669 50
2487202 2487202 2022-05-09 Madison Illinois 17119 71260 865
2487296 2487296 2022-05-09 Madison Indiana 18095 32835 653
2487402 2487402 2022-05-09 Madison Iowa 19121 3173 40
2487620 2487620 2022-05-09 Madison Kentucky 21151 27833 280
2487700 2487700 2022-05-09 Madison Louisiana 22065 3260 59
2488006 2488006 2022-05-09 Madison Mississippi 28089 24189 329
2488106 2488106 2022-05-09 Madison Missouri 29123 3615 57
2488188 2488188 2022-05-09 Madison Montana 30057 1818 20
2488275 2488275 2022-05-09 Madison Nebraska 31119 9705 68
2488420 2488420 2022-05-09 Madison New York 36053 14245 127
2488510 2488510 2022-05-09 Madison North Carolina 37115 5165 81
2488660 2488660 2022-05-09 Madison Ohio 39097 9728 134
2489133 2489133 2022-05-09 Madison Tennessee 47113 30181 427
2489328 2489328 2022-05-09 Madison Texas 48313 3773 54
2489552 2489552 2022-05-09 Madison Virginia 51113 2437 41

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);