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 |
---|---|---|---|---|---|---|---|
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 |
253005 | 253005 | 2020-06-19 | Crawford | Georgia | 13079 | 34 | 0 |
253183 | 253183 | 2020-06-19 | Crawford | Illinois | 17033 | 17 | 0 |
253281 | 253281 | 2020-06-19 | Crawford | Indiana | 18025 | 28 | 1 |
253384 | 253384 | 2020-06-19 | Crawford | Iowa | 19047 | 635 | 2 |
253479 | 253479 | 2020-06-19 | Crawford | Kansas | 20037 | 167 | 1 |
253812 | 253812 | 2020-06-19 | Crawford | Michigan | 26039 | 66 | 5 |
254072 | 254072 | 2020-06-19 | Crawford | Missouri | 29055 | 10 | 0 |
254569 | 254569 | 2020-06-19 | Crawford | Ohio | 39033 | 122 | 5 |
254768 | 254768 | 2020-06-19 | Crawford | Pennsylvania | 42039 | 38 | 0 |
255621 | 255621 | 2020-06-19 | Crawford | Wisconsin | 55023 | 27 | 0 |
249593 | 249593 | 2020-06-18 | Crawford | Arkansas | 5033 | 75 | 0 |
249890 | 249890 | 2020-06-18 | Crawford | Georgia | 13079 | 32 | 0 |
250068 | 250068 | 2020-06-18 | Crawford | Illinois | 17033 | 17 | 0 |
250166 | 250166 | 2020-06-18 | Crawford | Indiana | 18025 | 28 | 1 |
250269 | 250269 | 2020-06-18 | Crawford | Iowa | 19047 | 633 | 2 |
250364 | 250364 | 2020-06-18 | Crawford | Kansas | 20037 | 156 | 1 |
250697 | 250697 | 2020-06-18 | Crawford | Michigan | 26039 | 65 | 5 |
250957 | 250957 | 2020-06-18 | Crawford | Missouri | 29055 | 10 | 0 |
251454 | 251454 | 2020-06-18 | Crawford | Ohio | 39033 | 122 | 5 |
251653 | 251653 | 2020-06-18 | Crawford | Pennsylvania | 42039 | 35 | 0 |
252502 | 252502 | 2020-06-18 | Crawford | Wisconsin | 55023 | 27 | 0 |
246481 | 246481 | 2020-06-17 | Crawford | Arkansas | 5033 | 69 | 0 |
246778 | 246778 | 2020-06-17 | Crawford | Georgia | 13079 | 32 | 0 |
246956 | 246956 | 2020-06-17 | Crawford | Illinois | 17033 | 17 | 0 |
247054 | 247054 | 2020-06-17 | Crawford | Indiana | 18025 | 28 | 1 |
247157 | 247157 | 2020-06-17 | Crawford | Iowa | 19047 | 630 | 2 |
247252 | 247252 | 2020-06-17 | Crawford | Kansas | 20037 | 156 | 1 |
247585 | 247585 | 2020-06-17 | Crawford | Michigan | 26039 | 65 | 5 |
247844 | 247844 | 2020-06-17 | Crawford | Missouri | 29055 | 9 | 0 |
248339 | 248339 | 2020-06-17 | Crawford | Ohio | 39033 | 122 | 5 |
248538 | 248538 | 2020-06-17 | Crawford | Pennsylvania | 42039 | 35 | 0 |
249387 | 249387 | 2020-06-17 | Crawford | Wisconsin | 55023 | 27 | 0 |
243368 | 243368 | 2020-06-16 | Crawford | Arkansas | 5033 | 65 | 0 |
243665 | 243665 | 2020-06-16 | Crawford | Georgia | 13079 | 32 | 0 |
243843 | 243843 | 2020-06-16 | Crawford | Illinois | 17033 | 17 | 0 |
243941 | 243941 | 2020-06-16 | Crawford | Indiana | 18025 | 28 | 1 |
244044 | 244044 | 2020-06-16 | Crawford | Iowa | 19047 | 623 | 2 |
244139 | 244139 | 2020-06-16 | Crawford | Kansas | 20037 | 96 | 1 |
244472 | 244472 | 2020-06-16 | Crawford | Michigan | 26039 | 65 | 5 |
244731 | 244731 | 2020-06-16 | Crawford | Missouri | 29055 | 9 | 0 |
245226 | 245226 | 2020-06-16 | Crawford | Ohio | 39033 | 123 | 5 |
245425 | 245425 | 2020-06-16 | Crawford | Pennsylvania | 42039 | 35 | 0 |
246275 | 246275 | 2020-06-16 | Crawford | Wisconsin | 55023 | 27 | 0 |
240257 | 240257 | 2020-06-15 | Crawford | Arkansas | 5033 | 61 | 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);