ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,543 rows where county = "Crawford" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
280909 | 280909 | 2020-06-28 | Crawford | Arkansas | 5033 | 148 | 0 |
281207 | 281207 | 2020-06-28 | Crawford | Georgia | 13079 | 39 | 0 |
281389 | 281389 | 2020-06-28 | Crawford | Illinois | 17033 | 18 | 0 |
281487 | 281487 | 2020-06-28 | Crawford | Indiana | 18025 | 29 | 1 |
281590 | 281590 | 2020-06-28 | Crawford | Iowa | 19047 | 661 | 2 |
281685 | 281685 | 2020-06-28 | Crawford | Kansas | 20037 | 246 | 1 |
282022 | 282022 | 2020-06-28 | Crawford | Michigan | 26039 | 68 | 5 |
282282 | 282282 | 2020-06-28 | Crawford | Missouri | 29055 | 11 | 0 |
282791 | 282791 | 2020-06-28 | Crawford | Ohio | 39033 | 130 | 6 |
282991 | 282991 | 2020-06-28 | Crawford | Pennsylvania | 42039 | 53 | 0 |
283849 | 283849 | 2020-06-28 | Crawford | Wisconsin | 55023 | 33 | 0 |
277762 | 277762 | 2020-06-27 | Crawford | Arkansas | 5033 | 135 | 0 |
278060 | 278060 | 2020-06-27 | Crawford | Georgia | 13079 | 39 | 0 |
278241 | 278241 | 2020-06-27 | Crawford | Illinois | 17033 | 18 | 0 |
278339 | 278339 | 2020-06-27 | Crawford | Indiana | 18025 | 28 | 1 |
278442 | 278442 | 2020-06-27 | Crawford | Iowa | 19047 | 659 | 2 |
278537 | 278537 | 2020-06-27 | Crawford | Kansas | 20037 | 246 | 1 |
278874 | 278874 | 2020-06-27 | Crawford | Michigan | 26039 | 68 | 5 |
279134 | 279134 | 2020-06-27 | Crawford | Missouri | 29055 | 11 | 0 |
279645 | 279645 | 2020-06-27 | Crawford | Ohio | 39033 | 129 | 5 |
279845 | 279845 | 2020-06-27 | Crawford | Pennsylvania | 42039 | 53 | 0 |
280703 | 280703 | 2020-06-27 | Crawford | Wisconsin | 55023 | 32 | 0 |
274614 | 274614 | 2020-06-26 | Crawford | Arkansas | 5033 | 131 | 0 |
274912 | 274912 | 2020-06-26 | Crawford | Georgia | 13079 | 39 | 0 |
275093 | 275093 | 2020-06-26 | Crawford | Illinois | 17033 | 18 | 0 |
275191 | 275191 | 2020-06-26 | Crawford | Indiana | 18025 | 28 | 1 |
275294 | 275294 | 2020-06-26 | Crawford | Iowa | 19047 | 658 | 2 |
275389 | 275389 | 2020-06-26 | Crawford | Kansas | 20037 | 246 | 1 |
275726 | 275726 | 2020-06-26 | Crawford | Michigan | 26039 | 68 | 5 |
275986 | 275986 | 2020-06-26 | Crawford | Missouri | 29055 | 11 | 0 |
276497 | 276497 | 2020-06-26 | Crawford | Ohio | 39033 | 127 | 5 |
276697 | 276697 | 2020-06-26 | Crawford | Pennsylvania | 42039 | 51 | 0 |
277555 | 277555 | 2020-06-26 | Crawford | Wisconsin | 55023 | 32 | 0 |
271474 | 271474 | 2020-06-25 | Crawford | Arkansas | 5033 | 121 | 0 |
271772 | 271772 | 2020-06-25 | Crawford | Georgia | 13079 | 39 | 0 |
271951 | 271951 | 2020-06-25 | Crawford | Illinois | 17033 | 18 | 0 |
272049 | 272049 | 2020-06-25 | Crawford | Indiana | 18025 | 28 | 1 |
272152 | 272152 | 2020-06-25 | Crawford | Iowa | 19047 | 650 | 2 |
272247 | 272247 | 2020-06-25 | Crawford | Kansas | 20037 | 220 | 1 |
272583 | 272583 | 2020-06-25 | Crawford | Michigan | 26039 | 68 | 5 |
272843 | 272843 | 2020-06-25 | Crawford | Missouri | 29055 | 10 | 0 |
273350 | 273350 | 2020-06-25 | Crawford | Ohio | 39033 | 126 | 5 |
273550 | 273550 | 2020-06-25 | Crawford | Pennsylvania | 42039 | 50 | 0 |
274407 | 274407 | 2020-06-25 | Crawford | Wisconsin | 55023 | 32 | 0 |
268339 | 268339 | 2020-06-24 | Crawford | Arkansas | 5033 | 112 | 0 |
268636 | 268636 | 2020-06-24 | Crawford | Georgia | 13079 | 39 | 0 |
268814 | 268814 | 2020-06-24 | Crawford | Illinois | 17033 | 18 | 0 |
268912 | 268912 | 2020-06-24 | Crawford | Indiana | 18025 | 28 | 1 |
269015 | 269015 | 2020-06-24 | Crawford | Iowa | 19047 | 647 | 2 |
269110 | 269110 | 2020-06-24 | Crawford | Kansas | 20037 | 220 | 1 |
269446 | 269446 | 2020-06-24 | Crawford | Michigan | 26039 | 68 | 5 |
269705 | 269705 | 2020-06-24 | Crawford | Missouri | 29055 | 10 | 0 |
270211 | 270211 | 2020-06-24 | Crawford | Ohio | 39033 | 125 | 5 |
270411 | 270411 | 2020-06-24 | Crawford | Pennsylvania | 42039 | 48 | 0 |
271267 | 271267 | 2020-06-24 | Crawford | Wisconsin | 55023 | 32 | 0 |
265209 | 265209 | 2020-06-23 | Crawford | Arkansas | 5033 | 105 | 0 |
265506 | 265506 | 2020-06-23 | Crawford | Georgia | 13079 | 37 | 0 |
265684 | 265684 | 2020-06-23 | Crawford | Illinois | 17033 | 18 | 0 |
265782 | 265782 | 2020-06-23 | Crawford | Indiana | 18025 | 28 | 1 |
265885 | 265885 | 2020-06-23 | Crawford | Iowa | 19047 | 642 | 2 |
265980 | 265980 | 2020-06-23 | Crawford | Kansas | 20037 | 192 | 1 |
266313 | 266313 | 2020-06-23 | Crawford | Michigan | 26039 | 66 | 5 |
266572 | 266572 | 2020-06-23 | Crawford | Missouri | 29055 | 10 | 0 |
267077 | 267077 | 2020-06-23 | Crawford | Ohio | 39033 | 125 | 5 |
267277 | 267277 | 2020-06-23 | Crawford | Pennsylvania | 42039 | 43 | 0 |
268133 | 268133 | 2020-06-23 | Crawford | Wisconsin | 55023 | 31 | 0 |
262081 | 262081 | 2020-06-22 | Crawford | Arkansas | 5033 | 98 | 0 |
262378 | 262378 | 2020-06-22 | Crawford | Georgia | 13079 | 36 | 0 |
262556 | 262556 | 2020-06-22 | Crawford | Illinois | 17033 | 18 | 0 |
262654 | 262654 | 2020-06-22 | Crawford | Indiana | 18025 | 28 | 1 |
262757 | 262757 | 2020-06-22 | Crawford | Iowa | 19047 | 641 | 2 |
262852 | 262852 | 2020-06-22 | Crawford | Kansas | 20037 | 192 | 1 |
263187 | 263187 | 2020-06-22 | Crawford | Michigan | 26039 | 66 | 5 |
263446 | 263446 | 2020-06-22 | Crawford | Missouri | 29055 | 10 | 0 |
263949 | 263949 | 2020-06-22 | Crawford | Ohio | 39033 | 122 | 5 |
264149 | 264149 | 2020-06-22 | Crawford | Pennsylvania | 42039 | 42 | 0 |
265004 | 265004 | 2020-06-22 | Crawford | Wisconsin | 55023 | 31 | 0 |
258954 | 258954 | 2020-06-21 | Crawford | Arkansas | 5033 | 97 | 0 |
259251 | 259251 | 2020-06-21 | Crawford | Georgia | 13079 | 36 | 0 |
259429 | 259429 | 2020-06-21 | Crawford | Illinois | 17033 | 18 | 0 |
259527 | 259527 | 2020-06-21 | Crawford | Indiana | 18025 | 28 | 1 |
259630 | 259630 | 2020-06-21 | Crawford | Iowa | 19047 | 640 | 2 |
259725 | 259725 | 2020-06-21 | Crawford | Kansas | 20037 | 167 | 1 |
260058 | 260058 | 2020-06-21 | Crawford | Michigan | 26039 | 66 | 5 |
260318 | 260318 | 2020-06-21 | Crawford | Missouri | 29055 | 10 | 0 |
260821 | 260821 | 2020-06-21 | Crawford | Ohio | 39033 | 122 | 5 |
261021 | 261021 | 2020-06-21 | Crawford | Pennsylvania | 42039 | 40 | 0 |
261875 | 261875 | 2020-06-21 | Crawford | Wisconsin | 55023 | 31 | 0 |
255827 | 255827 | 2020-06-20 | Crawford | Arkansas | 5033 | 91 | 0 |
256124 | 256124 | 2020-06-20 | Crawford | Georgia | 13079 | 36 | 0 |
256303 | 256303 | 2020-06-20 | Crawford | Illinois | 17033 | 17 | 0 |
256401 | 256401 | 2020-06-20 | Crawford | Indiana | 18025 | 28 | 1 |
256504 | 256504 | 2020-06-20 | Crawford | Iowa | 19047 | 637 | 2 |
256599 | 256599 | 2020-06-20 | Crawford | Kansas | 20037 | 167 | 1 |
256932 | 256932 | 2020-06-20 | Crawford | Michigan | 26039 | 66 | 5 |
257192 | 257192 | 2020-06-20 | Crawford | Missouri | 29055 | 10 | 0 |
257694 | 257694 | 2020-06-20 | Crawford | Ohio | 39033 | 122 | 5 |
257894 | 257894 | 2020-06-20 | Crawford | Pennsylvania | 42039 | 40 | 0 |
258748 | 258748 | 2020-06-20 | Crawford | Wisconsin | 55023 | 29 | 0 |
252708 | 252708 | 2020-06-19 | Crawford | Arkansas | 5033 | 83 | 0 |
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);