ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,356 rows where county = "Christian" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
county 1
- Christian · 2,356 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4667 | 4667 | 2020-03-19 | Christian | Kentucky | 21047 | 1 | 0 |
5403 | 5403 | 2020-03-20 | Christian | Illinois | 17021 | 1 | 0 |
5481 | 5481 | 2020-03-20 | Christian | Kentucky | 21047 | 1 | 0 |
5636 | 5636 | 2020-03-20 | Christian | Missouri | 29043 | 2 | 0 |
6337 | 6337 | 2020-03-21 | Christian | Illinois | 17021 | 1 | 0 |
6427 | 6427 | 2020-03-21 | Christian | Kentucky | 21047 | 1 | 0 |
6624 | 6624 | 2020-03-21 | Christian | Missouri | 29043 | 2 | 0 |
7387 | 7387 | 2020-03-22 | Christian | Illinois | 17021 | 1 | 0 |
7498 | 7498 | 2020-03-22 | Christian | Kentucky | 21047 | 2 | 0 |
7713 | 7713 | 2020-03-22 | Christian | Missouri | 29043 | 2 | 0 |
8542 | 8542 | 2020-03-23 | Christian | Illinois | 17021 | 1 | 0 |
8660 | 8660 | 2020-03-23 | Christian | Kentucky | 21047 | 2 | 0 |
8899 | 8899 | 2020-03-23 | Christian | Missouri | 29043 | 2 | 0 |
9805 | 9805 | 2020-03-24 | Christian | Illinois | 17021 | 1 | 0 |
9943 | 9943 | 2020-03-24 | Christian | Kentucky | 21047 | 3 | 0 |
10198 | 10198 | 2020-03-24 | Christian | Missouri | 29043 | 2 | 0 |
11195 | 11195 | 2020-03-25 | Christian | Illinois | 17021 | 1 | 0 |
11343 | 11343 | 2020-03-25 | Christian | Kentucky | 21047 | 3 | 0 |
11619 | 11619 | 2020-03-25 | Christian | Missouri | 29043 | 2 | 0 |
12750 | 12750 | 2020-03-26 | Christian | Illinois | 17021 | 1 | 0 |
12913 | 12913 | 2020-03-26 | Christian | Kentucky | 21047 | 5 | 0 |
13217 | 13217 | 2020-03-26 | Christian | Missouri | 29043 | 2 | 0 |
14426 | 14426 | 2020-03-27 | Christian | Illinois | 17021 | 1 | 0 |
14618 | 14618 | 2020-03-27 | Christian | Kentucky | 21047 | 6 | 0 |
14942 | 14942 | 2020-03-27 | Christian | Missouri | 29043 | 3 | 0 |
16220 | 16220 | 2020-03-28 | Christian | Illinois | 17021 | 1 | 0 |
16431 | 16431 | 2020-03-28 | Christian | Kentucky | 21047 | 6 | 0 |
16766 | 16766 | 2020-03-28 | Christian | Missouri | 29043 | 6 | 0 |
18119 | 18119 | 2020-03-29 | Christian | Illinois | 17021 | 19 | 0 |
18341 | 18341 | 2020-03-29 | Christian | Kentucky | 21047 | 6 | 0 |
18688 | 18688 | 2020-03-29 | Christian | Missouri | 29043 | 7 | 0 |
20119 | 20119 | 2020-03-30 | Christian | Illinois | 17021 | 19 | 0 |
20355 | 20355 | 2020-03-30 | Christian | Kentucky | 21047 | 7 | 0 |
20713 | 20713 | 2020-03-30 | Christian | Missouri | 29043 | 12 | 0 |
22210 | 22210 | 2020-03-31 | Christian | Illinois | 17021 | 14 | 0 |
22455 | 22455 | 2020-03-31 | Christian | Kentucky | 21047 | 8 | 0 |
22831 | 22831 | 2020-03-31 | Christian | Missouri | 29043 | 11 | 0 |
24378 | 24378 | 2020-04-01 | Christian | Illinois | 17021 | 14 | 0 |
24631 | 24631 | 2020-04-01 | Christian | Kentucky | 21047 | 9 | 0 |
25017 | 25017 | 2020-04-01 | Christian | Missouri | 29043 | 11 | 0 |
26611 | 26611 | 2020-04-02 | Christian | Illinois | 17021 | 15 | 1 |
26876 | 26876 | 2020-04-02 | Christian | Kentucky | 21047 | 15 | 0 |
27272 | 27272 | 2020-04-02 | Christian | Missouri | 29043 | 12 | 0 |
28918 | 28918 | 2020-04-03 | Christian | Illinois | 17021 | 17 | 2 |
29192 | 29192 | 2020-04-03 | Christian | Kentucky | 21047 | 15 | 0 |
29591 | 29591 | 2020-04-03 | Christian | Missouri | 29043 | 13 | 0 |
31280 | 31280 | 2020-04-04 | Christian | Illinois | 17021 | 18 | 3 |
31567 | 31567 | 2020-04-04 | Christian | Kentucky | 21047 | 18 | 0 |
31971 | 31971 | 2020-04-04 | Christian | Missouri | 29043 | 16 | 0 |
33689 | 33689 | 2020-04-05 | Christian | Illinois | 17021 | 21 | 3 |
33985 | 33985 | 2020-04-05 | Christian | Kentucky | 21047 | 23 | 0 |
34399 | 34399 | 2020-04-05 | Christian | Missouri | 29043 | 16 | 0 |
36140 | 36140 | 2020-04-06 | Christian | Illinois | 17021 | 22 | 3 |
36443 | 36443 | 2020-04-06 | Christian | Kentucky | 21047 | 23 | 0 |
36862 | 36862 | 2020-04-06 | Christian | Missouri | 29043 | 17 | 0 |
38634 | 38634 | 2020-04-07 | Christian | Illinois | 17021 | 24 | 4 |
38948 | 38948 | 2020-04-07 | Christian | Kentucky | 21047 | 33 | 0 |
39373 | 39373 | 2020-04-07 | Christian | Missouri | 29043 | 17 | 0 |
41178 | 41178 | 2020-04-08 | Christian | Illinois | 17021 | 24 | 4 |
41497 | 41497 | 2020-04-08 | Christian | Kentucky | 21047 | 45 | 0 |
41927 | 41927 | 2020-04-08 | Christian | Missouri | 29043 | 17 | 0 |
43752 | 43752 | 2020-04-09 | Christian | Illinois | 17021 | 24 | 4 |
44072 | 44072 | 2020-04-09 | Christian | Kentucky | 21047 | 45 | 0 |
44504 | 44504 | 2020-04-09 | Christian | Missouri | 29043 | 17 | 0 |
46354 | 46354 | 2020-04-10 | Christian | Illinois | 17021 | 24 | 4 |
46680 | 46680 | 2020-04-10 | Christian | Kentucky | 21047 | 54 | 3 |
47113 | 47113 | 2020-04-10 | Christian | Missouri | 29043 | 17 | 0 |
48985 | 48985 | 2020-04-11 | Christian | Illinois | 17021 | 24 | 4 |
49317 | 49317 | 2020-04-11 | Christian | Kentucky | 21047 | 62 | 3 |
49760 | 49760 | 2020-04-11 | Christian | Missouri | 29043 | 17 | 0 |
51647 | 51647 | 2020-04-12 | Christian | Illinois | 17021 | 24 | 4 |
51983 | 51983 | 2020-04-12 | Christian | Kentucky | 21047 | 67 | 3 |
52433 | 52433 | 2020-04-12 | Christian | Missouri | 29043 | 17 | 0 |
54327 | 54327 | 2020-04-13 | Christian | Illinois | 17021 | 25 | 4 |
54664 | 54664 | 2020-04-13 | Christian | Kentucky | 21047 | 69 | 3 |
55115 | 55115 | 2020-04-13 | Christian | Missouri | 29043 | 17 | 0 |
57019 | 57019 | 2020-04-14 | Christian | Illinois | 17021 | 25 | 5 |
57360 | 57360 | 2020-04-14 | Christian | Kentucky | 21047 | 71 | 3 |
57813 | 57813 | 2020-04-14 | Christian | Missouri | 29043 | 19 | 0 |
59726 | 59726 | 2020-04-15 | Christian | Illinois | 17021 | 25 | 5 |
60069 | 60069 | 2020-04-15 | Christian | Kentucky | 21047 | 73 | 3 |
60524 | 60524 | 2020-04-15 | Christian | Missouri | 29043 | 18 | 0 |
62447 | 62447 | 2020-04-16 | Christian | Illinois | 17021 | 25 | 5 |
62789 | 62789 | 2020-04-16 | Christian | Kentucky | 21047 | 73 | 3 |
63246 | 63246 | 2020-04-16 | Christian | Missouri | 29043 | 17 | 0 |
65179 | 65179 | 2020-04-17 | Christian | Illinois | 17021 | 25 | 5 |
65528 | 65528 | 2020-04-17 | Christian | Kentucky | 21047 | 81 | 3 |
65986 | 65986 | 2020-04-17 | Christian | Missouri | 29043 | 17 | 0 |
67927 | 67927 | 2020-04-18 | Christian | Illinois | 17021 | 25 | 5 |
68277 | 68277 | 2020-04-18 | Christian | Kentucky | 21047 | 81 | 3 |
68738 | 68738 | 2020-04-18 | Christian | Missouri | 29043 | 17 | 0 |
70689 | 70689 | 2020-04-19 | Christian | Illinois | 17021 | 25 | 5 |
71038 | 71038 | 2020-04-19 | Christian | Kentucky | 21047 | 81 | 3 |
71505 | 71505 | 2020-04-19 | Christian | Missouri | 29043 | 17 | 0 |
73459 | 73459 | 2020-04-20 | Christian | Illinois | 17021 | 27 | 5 |
73810 | 73810 | 2020-04-20 | Christian | Kentucky | 21047 | 81 | 3 |
74278 | 74278 | 2020-04-20 | Christian | Missouri | 29043 | 18 | 0 |
76235 | 76235 | 2020-04-21 | Christian | Illinois | 17021 | 26 | 5 |
76590 | 76590 | 2020-04-21 | Christian | Kentucky | 21047 | 84 | 3 |
77059 | 77059 | 2020-04-21 | Christian | Missouri | 29043 | 18 | 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);