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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9534 | 9534 | 2020-03-24 | Crawford | Arkansas | 5033 | 1 | 0 |
10416 | 10416 | 2020-03-24 | Crawford | Ohio | 39033 | 1 | 0 |
10904 | 10904 | 2020-03-25 | Crawford | Arkansas | 5033 | 1 | 0 |
11318 | 11318 | 2020-03-25 | Crawford | Kansas | 20037 | 1 | 0 |
11863 | 11863 | 2020-03-25 | Crawford | Ohio | 39033 | 1 | 0 |
12446 | 12446 | 2020-03-26 | Crawford | Arkansas | 5033 | 1 | 0 |
12885 | 12885 | 2020-03-26 | Crawford | Kansas | 20037 | 3 | 0 |
13470 | 13470 | 2020-03-26 | Crawford | Ohio | 39033 | 1 | 0 |
13587 | 13587 | 2020-03-26 | Crawford | Pennsylvania | 42039 | 1 | 0 |
14110 | 14110 | 2020-03-27 | Crawford | Arkansas | 5033 | 1 | 0 |
14583 | 14583 | 2020-03-27 | Crawford | Kansas | 20037 | 3 | 0 |
14770 | 14770 | 2020-03-27 | Crawford | Michigan | 26039 | 1 | 0 |
15207 | 15207 | 2020-03-27 | Crawford | Ohio | 39033 | 1 | 0 |
15333 | 15333 | 2020-03-27 | Crawford | Pennsylvania | 42039 | 1 | 0 |
15890 | 15890 | 2020-03-28 | Crawford | Arkansas | 5033 | 1 | 0 |
16268 | 16268 | 2020-03-28 | Crawford | Indiana | 18025 | 1 | 0 |
16390 | 16390 | 2020-03-28 | Crawford | Kansas | 20037 | 3 | 0 |
16590 | 16590 | 2020-03-28 | Crawford | Michigan | 26039 | 1 | 0 |
17049 | 17049 | 2020-03-28 | Crawford | Ohio | 39033 | 2 | 0 |
17182 | 17182 | 2020-03-28 | Crawford | Pennsylvania | 42039 | 2 | 0 |
17776 | 17776 | 2020-03-29 | Crawford | Arkansas | 5033 | 2 | 0 |
18170 | 18170 | 2020-03-29 | Crawford | Indiana | 18025 | 1 | 0 |
18295 | 18295 | 2020-03-29 | Crawford | Kansas | 20037 | 4 | 0 |
18506 | 18506 | 2020-03-29 | Crawford | Michigan | 26039 | 1 | 0 |
18983 | 18983 | 2020-03-29 | Crawford | Ohio | 39033 | 2 | 0 |
19120 | 19120 | 2020-03-29 | Crawford | Pennsylvania | 42039 | 3 | 0 |
19750 | 19750 | 2020-03-30 | Crawford | Arkansas | 5033 | 2 | 0 |
20123 | 20123 | 2020-03-30 | Crawford | Illinois | 17033 | 1 | 0 |
20176 | 20176 | 2020-03-30 | Crawford | Indiana | 18025 | 1 | 0 |
20260 | 20260 | 2020-03-30 | Crawford | Iowa | 19047 | 1 | 0 |
20308 | 20308 | 2020-03-30 | Crawford | Kansas | 20037 | 5 | 1 |
20523 | 20523 | 2020-03-30 | Crawford | Michigan | 26039 | 1 | 0 |
20718 | 20718 | 2020-03-30 | Crawford | Missouri | 29055 | 1 | 0 |
21027 | 21027 | 2020-03-30 | Crawford | Ohio | 39033 | 5 | 0 |
21170 | 21170 | 2020-03-30 | Crawford | Pennsylvania | 42039 | 4 | 0 |
21822 | 21822 | 2020-03-31 | Crawford | Arkansas | 5033 | 3 | 0 |
22214 | 22214 | 2020-03-31 | Crawford | Illinois | 17033 | 1 | 0 |
22270 | 22270 | 2020-03-31 | Crawford | Indiana | 18025 | 1 | 0 |
22356 | 22356 | 2020-03-31 | Crawford | Iowa | 19047 | 1 | 0 |
22406 | 22406 | 2020-03-31 | Crawford | Kansas | 20037 | 5 | 1 |
22634 | 22634 | 2020-03-31 | Crawford | Michigan | 26039 | 1 | 0 |
22836 | 22836 | 2020-03-31 | Crawford | Missouri | 29055 | 1 | 0 |
23159 | 23159 | 2020-03-31 | Crawford | Ohio | 39033 | 5 | 0 |
23306 | 23306 | 2020-03-31 | Crawford | Pennsylvania | 42039 | 4 | 0 |
23979 | 23979 | 2020-04-01 | Crawford | Arkansas | 5033 | 3 | 0 |
24382 | 24382 | 2020-04-01 | Crawford | Illinois | 17033 | 1 | 0 |
24440 | 24440 | 2020-04-01 | Crawford | Indiana | 18025 | 1 | 0 |
24528 | 24528 | 2020-04-01 | Crawford | Iowa | 19047 | 1 | 0 |
24581 | 24581 | 2020-04-01 | Crawford | Kansas | 20037 | 5 | 1 |
24813 | 24813 | 2020-04-01 | Crawford | Michigan | 26039 | 1 | 0 |
25022 | 25022 | 2020-04-01 | Crawford | Missouri | 29055 | 1 | 0 |
25354 | 25354 | 2020-04-01 | Crawford | Ohio | 39033 | 5 | 0 |
25504 | 25504 | 2020-04-01 | Crawford | Pennsylvania | 42039 | 5 | 0 |
26044 | 26044 | 2020-04-01 | Crawford | Wisconsin | 55023 | 1 | 0 |
26203 | 26203 | 2020-04-02 | Crawford | Arkansas | 5033 | 3 | 0 |
26615 | 26615 | 2020-04-02 | Crawford | Illinois | 17033 | 1 | 0 |
26679 | 26679 | 2020-04-02 | Crawford | Indiana | 18025 | 1 | 0 |
26769 | 26769 | 2020-04-02 | Crawford | Iowa | 19047 | 1 | 0 |
26825 | 26825 | 2020-04-02 | Crawford | Kansas | 20037 | 6 | 1 |
27065 | 27065 | 2020-04-02 | Crawford | Michigan | 26039 | 1 | 0 |
27277 | 27277 | 2020-04-02 | Crawford | Missouri | 29055 | 1 | 0 |
27620 | 27620 | 2020-04-02 | Crawford | Ohio | 39033 | 6 | 0 |
27776 | 27776 | 2020-04-02 | Crawford | Pennsylvania | 42039 | 5 | 0 |
28337 | 28337 | 2020-04-02 | Crawford | Wisconsin | 55023 | 1 | 0 |
28500 | 28500 | 2020-04-03 | Crawford | Arkansas | 5033 | 3 | 0 |
28922 | 28922 | 2020-04-03 | Crawford | Illinois | 17033 | 1 | 0 |
28989 | 28989 | 2020-04-03 | Crawford | Indiana | 18025 | 3 | 0 |
29080 | 29080 | 2020-04-03 | Crawford | Iowa | 19047 | 4 | 0 |
29139 | 29139 | 2020-04-03 | Crawford | Kansas | 20037 | 6 | 1 |
29383 | 29383 | 2020-04-03 | Crawford | Michigan | 26039 | 1 | 0 |
29597 | 29597 | 2020-04-03 | Crawford | Missouri | 29055 | 1 | 0 |
29949 | 29949 | 2020-04-03 | Crawford | Ohio | 39033 | 7 | 0 |
30110 | 30110 | 2020-04-03 | Crawford | Pennsylvania | 42039 | 5 | 0 |
30692 | 30692 | 2020-04-03 | Crawford | Wisconsin | 55023 | 1 | 0 |
30857 | 30857 | 2020-04-04 | Crawford | Arkansas | 5033 | 3 | 0 |
31284 | 31284 | 2020-04-04 | Crawford | Illinois | 17033 | 2 | 0 |
31355 | 31355 | 2020-04-04 | Crawford | Indiana | 18025 | 5 | 0 |
31448 | 31448 | 2020-04-04 | Crawford | Iowa | 19047 | 4 | 0 |
31511 | 31511 | 2020-04-04 | Crawford | Kansas | 20037 | 6 | 1 |
31761 | 31761 | 2020-04-04 | Crawford | Michigan | 26039 | 1 | 0 |
31977 | 31977 | 2020-04-04 | Crawford | Missouri | 29055 | 2 | 0 |
32338 | 32338 | 2020-04-04 | Crawford | Ohio | 39033 | 7 | 0 |
32500 | 32500 | 2020-04-04 | Crawford | Pennsylvania | 42039 | 5 | 0 |
33093 | 33093 | 2020-04-04 | Crawford | Wisconsin | 55023 | 1 | 0 |
33261 | 33261 | 2020-04-05 | Crawford | Arkansas | 5033 | 3 | 0 |
33531 | 33531 | 2020-04-05 | Crawford | Georgia | 13079 | 1 | 0 |
33693 | 33693 | 2020-04-05 | Crawford | Illinois | 17033 | 3 | 0 |
33765 | 33765 | 2020-04-05 | Crawford | Indiana | 18025 | 5 | 0 |
33860 | 33860 | 2020-04-05 | Crawford | Iowa | 19047 | 4 | 0 |
33924 | 33924 | 2020-04-05 | Crawford | Kansas | 20037 | 6 | 1 |
34186 | 34186 | 2020-04-05 | Crawford | Michigan | 26039 | 1 | 0 |
34405 | 34405 | 2020-04-05 | Crawford | Missouri | 29055 | 3 | 0 |
34771 | 34771 | 2020-04-05 | Crawford | Ohio | 39033 | 9 | 0 |
34935 | 34935 | 2020-04-05 | Crawford | Pennsylvania | 42039 | 7 | 0 |
35531 | 35531 | 2020-04-05 | Crawford | Wisconsin | 55023 | 2 | 0 |
35702 | 35702 | 2020-04-06 | Crawford | Arkansas | 5033 | 3 | 0 |
35979 | 35979 | 2020-04-06 | Crawford | Georgia | 13079 | 1 | 0 |
36144 | 36144 | 2020-04-06 | Crawford | Illinois | 17033 | 5 | 0 |
36218 | 36218 | 2020-04-06 | Crawford | Indiana | 18025 | 6 | 0 |
36314 | 36314 | 2020-04-06 | Crawford | Iowa | 19047 | 5 | 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);