ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15,570 rows where county = "Madison" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
280832 | 280832 | 2020-06-28 | Madison | Alabama | 1089 | 930 | 7 |
280936 | 280936 | 2020-06-28 | Madison | Arkansas | 5087 | 188 | 0 |
281139 | 281139 | 2020-06-28 | Madison | Florida | 12079 | 187 | 3 |
281263 | 281263 | 2020-06-28 | Madison | Georgia | 13195 | 89 | 4 |
281362 | 281362 | 2020-06-28 | Madison | Idaho | 16065 | 34 | 0 |
281429 | 281429 | 2020-06-28 | Madison | Illinois | 17119 | 917 | 68 |
281522 | 281522 | 2020-06-28 | Madison | Indiana | 18095 | 649 | 73 |
281627 | 281627 | 2020-06-28 | Madison | Iowa | 19121 | 37 | 2 |
281834 | 281834 | 2020-06-28 | Madison | Kentucky | 21151 | 125 | 1 |
281913 | 281913 | 2020-06-28 | Madison | Louisiana | 22065 | 347 | 2 |
282217 | 282217 | 2020-06-28 | Madison | Mississippi | 28089 | 1145 | 32 |
282316 | 282316 | 2020-06-28 | Madison | Missouri | 29123 | 5 | 0 |
282391 | 282391 | 2020-06-28 | Madison | Montana | 30057 | 8 | 1 |
282455 | 282455 | 2020-06-28 | Madison | Nebraska | 31119 | 365 | 4 |
282590 | 282590 | 2020-06-28 | Madison | New York | 36053 | 352 | 4 |
282680 | 282680 | 2020-06-28 | Madison | North Carolina | 37115 | 12 | 0 |
282823 | 282823 | 2020-06-28 | Madison | Ohio | 39097 | 184 | 8 |
283283 | 283283 | 2020-06-28 | Madison | Tennessee | 47113 | 228 | 2 |
283471 | 283471 | 2020-06-28 | Madison | Texas | 48313 | 30 | 0 |
283688 | 283688 | 2020-06-28 | Madison | Virginia | 51113 | 43 | 1 |
277684 | 277684 | 2020-06-27 | Madison | Alabama | 1089 | 921 | 7 |
277789 | 277789 | 2020-06-27 | Madison | Arkansas | 5087 | 175 | 0 |
277992 | 277992 | 2020-06-27 | Madison | Florida | 12079 | 179 | 3 |
278116 | 278116 | 2020-06-27 | Madison | Georgia | 13195 | 87 | 4 |
278215 | 278215 | 2020-06-27 | Madison | Idaho | 16065 | 33 | 0 |
278281 | 278281 | 2020-06-27 | Madison | Illinois | 17119 | 903 | 68 |
278374 | 278374 | 2020-06-27 | Madison | Indiana | 18095 | 648 | 73 |
278479 | 278479 | 2020-06-27 | Madison | Iowa | 19121 | 36 | 2 |
278686 | 278686 | 2020-06-27 | Madison | Kentucky | 21151 | 112 | 1 |
278765 | 278765 | 2020-06-27 | Madison | Louisiana | 22065 | 331 | 2 |
279069 | 279069 | 2020-06-27 | Madison | Mississippi | 28089 | 1127 | 32 |
279168 | 279168 | 2020-06-27 | Madison | Missouri | 29123 | 4 | 0 |
279243 | 279243 | 2020-06-27 | Madison | Montana | 30057 | 8 | 1 |
279307 | 279307 | 2020-06-27 | Madison | Nebraska | 31119 | 365 | 4 |
279444 | 279444 | 2020-06-27 | Madison | New York | 36053 | 351 | 4 |
279534 | 279534 | 2020-06-27 | Madison | North Carolina | 37115 | 11 | 0 |
279677 | 279677 | 2020-06-27 | Madison | Ohio | 39097 | 182 | 8 |
280137 | 280137 | 2020-06-27 | Madison | Tennessee | 47113 | 228 | 2 |
280325 | 280325 | 2020-06-27 | Madison | Texas | 48313 | 28 | 0 |
280542 | 280542 | 2020-06-27 | Madison | Virginia | 51113 | 43 | 1 |
274536 | 274536 | 2020-06-26 | Madison | Alabama | 1089 | 889 | 7 |
274641 | 274641 | 2020-06-26 | Madison | Arkansas | 5087 | 174 | 0 |
274844 | 274844 | 2020-06-26 | Madison | Florida | 12079 | 170 | 3 |
274968 | 274968 | 2020-06-26 | Madison | Georgia | 13195 | 86 | 4 |
275067 | 275067 | 2020-06-26 | Madison | Idaho | 16065 | 31 | 0 |
275133 | 275133 | 2020-06-26 | Madison | Illinois | 17119 | 892 | 68 |
275226 | 275226 | 2020-06-26 | Madison | Indiana | 18095 | 642 | 73 |
275331 | 275331 | 2020-06-26 | Madison | Iowa | 19121 | 35 | 2 |
275538 | 275538 | 2020-06-26 | Madison | Kentucky | 21151 | 107 | 1 |
275617 | 275617 | 2020-06-26 | Madison | Louisiana | 22065 | 331 | 2 |
275921 | 275921 | 2020-06-26 | Madison | Mississippi | 28089 | 1112 | 31 |
276020 | 276020 | 2020-06-26 | Madison | Missouri | 29123 | 3 | 0 |
276095 | 276095 | 2020-06-26 | Madison | Montana | 30057 | 8 | 1 |
276159 | 276159 | 2020-06-26 | Madison | Nebraska | 31119 | 365 | 4 |
276296 | 276296 | 2020-06-26 | Madison | New York | 36053 | 351 | 4 |
276386 | 276386 | 2020-06-26 | Madison | North Carolina | 37115 | 9 | 0 |
276529 | 276529 | 2020-06-26 | Madison | Ohio | 39097 | 181 | 8 |
276989 | 276989 | 2020-06-26 | Madison | Tennessee | 47113 | 210 | 2 |
277177 | 277177 | 2020-06-26 | Madison | Texas | 48313 | 27 | 0 |
277394 | 277394 | 2020-06-26 | Madison | Virginia | 51113 | 43 | 1 |
271396 | 271396 | 2020-06-25 | Madison | Alabama | 1089 | 842 | 6 |
271501 | 271501 | 2020-06-25 | Madison | Arkansas | 5087 | 168 | 0 |
271704 | 271704 | 2020-06-25 | Madison | Florida | 12079 | 156 | 3 |
271828 | 271828 | 2020-06-25 | Madison | Georgia | 13195 | 86 | 4 |
271925 | 271925 | 2020-06-25 | Madison | Idaho | 16065 | 31 | 0 |
271991 | 271991 | 2020-06-25 | Madison | Illinois | 17119 | 877 | 68 |
272084 | 272084 | 2020-06-25 | Madison | Indiana | 18095 | 634 | 73 |
272189 | 272189 | 2020-06-25 | Madison | Iowa | 19121 | 35 | 2 |
272395 | 272395 | 2020-06-25 | Madison | Kentucky | 21151 | 106 | 1 |
272474 | 272474 | 2020-06-25 | Madison | Louisiana | 22065 | 324 | 2 |
272778 | 272778 | 2020-06-25 | Madison | Mississippi | 28089 | 1082 | 31 |
272877 | 272877 | 2020-06-25 | Madison | Missouri | 29123 | 3 | 0 |
272952 | 272952 | 2020-06-25 | Madison | Montana | 30057 | 8 | 1 |
273016 | 273016 | 2020-06-25 | Madison | Nebraska | 31119 | 365 | 4 |
273150 | 273150 | 2020-06-25 | Madison | New York | 36053 | 349 | 4 |
273240 | 273240 | 2020-06-25 | Madison | North Carolina | 37115 | 9 | 0 |
273382 | 273382 | 2020-06-25 | Madison | Ohio | 39097 | 179 | 8 |
273842 | 273842 | 2020-06-25 | Madison | Tennessee | 47113 | 206 | 2 |
274029 | 274029 | 2020-06-25 | Madison | Texas | 48313 | 26 | 0 |
274246 | 274246 | 2020-06-25 | Madison | Virginia | 51113 | 43 | 1 |
268262 | 268262 | 2020-06-24 | Madison | Alabama | 1089 | 775 | 6 |
268366 | 268366 | 2020-06-24 | Madison | Arkansas | 5087 | 163 | 0 |
268568 | 268568 | 2020-06-24 | Madison | Florida | 12079 | 143 | 3 |
268692 | 268692 | 2020-06-24 | Madison | Georgia | 13195 | 83 | 4 |
268788 | 268788 | 2020-06-24 | Madison | Idaho | 16065 | 31 | 0 |
268854 | 268854 | 2020-06-24 | Madison | Illinois | 17119 | 852 | 68 |
268947 | 268947 | 2020-06-24 | Madison | Indiana | 18095 | 634 | 73 |
269052 | 269052 | 2020-06-24 | Madison | Iowa | 19121 | 35 | 2 |
269259 | 269259 | 2020-06-24 | Madison | Kentucky | 21151 | 103 | 1 |
269338 | 269338 | 2020-06-24 | Madison | Louisiana | 22065 | 322 | 2 |
269640 | 269640 | 2020-06-24 | Madison | Mississippi | 28089 | 1034 | 31 |
269738 | 269738 | 2020-06-24 | Madison | Missouri | 29123 | 3 | 0 |
269813 | 269813 | 2020-06-24 | Madison | Montana | 30057 | 8 | 1 |
269877 | 269877 | 2020-06-24 | Madison | Nebraska | 31119 | 355 | 4 |
270011 | 270011 | 2020-06-24 | Madison | New York | 36053 | 347 | 4 |
270101 | 270101 | 2020-06-24 | Madison | North Carolina | 37115 | 8 | 0 |
270243 | 270243 | 2020-06-24 | Madison | Ohio | 39097 | 177 | 8 |
270703 | 270703 | 2020-06-24 | Madison | Tennessee | 47113 | 201 | 2 |
270889 | 270889 | 2020-06-24 | Madison | Texas | 48313 | 27 | 0 |
271106 | 271106 | 2020-06-24 | Madison | Virginia | 51113 | 43 | 1 |
Advanced export
JSON shape: default, array, newline-delimited
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);