ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,567 rows where county = "Kendall" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3930 | 3930 | 2020-03-18 | Kendall | Illinois | 17093 | 3 | 0 |
4606 | 4606 | 2020-03-19 | Kendall | Illinois | 17093 | 3 | 0 |
5411 | 5411 | 2020-03-20 | Kendall | Illinois | 17093 | 3 | 0 |
6346 | 6346 | 2020-03-21 | Kendall | Illinois | 17093 | 3 | 0 |
7397 | 7397 | 2020-03-22 | Kendall | Illinois | 17093 | 4 | 0 |
8552 | 8552 | 2020-03-23 | Kendall | Illinois | 17093 | 4 | 0 |
9816 | 9816 | 2020-03-24 | Kendall | Illinois | 17093 | 4 | 0 |
11207 | 11207 | 2020-03-25 | Kendall | Illinois | 17093 | 6 | 0 |
12159 | 12159 | 2020-03-25 | Kendall | Texas | 48259 | 3 | 0 |
12763 | 12763 | 2020-03-26 | Kendall | Illinois | 17093 | 7 | 0 |
13790 | 13790 | 2020-03-26 | Kendall | Texas | 48259 | 3 | 0 |
14441 | 14441 | 2020-03-27 | Kendall | Illinois | 17093 | 8 | 0 |
15546 | 15546 | 2020-03-27 | Kendall | Texas | 48259 | 4 | 0 |
16236 | 16236 | 2020-03-28 | Kendall | Illinois | 17093 | 11 | 0 |
17415 | 17415 | 2020-03-28 | Kendall | Texas | 48259 | 6 | 0 |
18135 | 18135 | 2020-03-29 | Kendall | Illinois | 17093 | 15 | 1 |
19369 | 19369 | 2020-03-29 | Kendall | Texas | 48259 | 7 | 0 |
20137 | 20137 | 2020-03-30 | Kendall | Illinois | 17093 | 18 | 2 |
21429 | 21429 | 2020-03-30 | Kendall | Texas | 48259 | 7 | 0 |
22229 | 22229 | 2020-03-31 | Kendall | Illinois | 17093 | 19 | 2 |
23568 | 23568 | 2020-03-31 | Kendall | Texas | 48259 | 7 | 0 |
24397 | 24397 | 2020-04-01 | Kendall | Illinois | 17093 | 27 | 2 |
25778 | 25778 | 2020-04-01 | Kendall | Texas | 48259 | 7 | 0 |
26630 | 26630 | 2020-04-02 | Kendall | Illinois | 17093 | 36 | 2 |
28063 | 28063 | 2020-04-02 | Kendall | Texas | 48259 | 8 | 0 |
28940 | 28940 | 2020-04-03 | Kendall | Illinois | 17093 | 37 | 2 |
30398 | 30398 | 2020-04-03 | Kendall | Texas | 48259 | 8 | 0 |
31303 | 31303 | 2020-04-04 | Kendall | Illinois | 17093 | 47 | 2 |
32793 | 32793 | 2020-04-04 | Kendall | Texas | 48259 | 9 | 0 |
33713 | 33713 | 2020-04-05 | Kendall | Illinois | 17093 | 49 | 2 |
35231 | 35231 | 2020-04-05 | Kendall | Texas | 48259 | 10 | 0 |
36165 | 36165 | 2020-04-06 | Kendall | Illinois | 17093 | 55 | 2 |
37707 | 37707 | 2020-04-06 | Kendall | Texas | 48259 | 10 | 0 |
38660 | 38660 | 2020-04-07 | Kendall | Illinois | 17093 | 61 | 2 |
40234 | 40234 | 2020-04-07 | Kendall | Texas | 48259 | 10 | 0 |
41205 | 41205 | 2020-04-08 | Kendall | Illinois | 17093 | 79 | 2 |
42802 | 42802 | 2020-04-08 | Kendall | Texas | 48259 | 9 | 0 |
43779 | 43779 | 2020-04-09 | Kendall | Illinois | 17093 | 86 | 2 |
45392 | 45392 | 2020-04-09 | Kendall | Texas | 48259 | 9 | 0 |
46383 | 46383 | 2020-04-10 | Kendall | Illinois | 17093 | 92 | 2 |
48013 | 48013 | 2020-04-10 | Kendall | Texas | 48259 | 10 | 0 |
49014 | 49014 | 2020-04-11 | Kendall | Illinois | 17093 | 103 | 2 |
50671 | 50671 | 2020-04-11 | Kendall | Texas | 48259 | 10 | 0 |
51676 | 51676 | 2020-04-12 | Kendall | Illinois | 17093 | 105 | 2 |
53346 | 53346 | 2020-04-12 | Kendall | Texas | 48259 | 11 | 0 |
54357 | 54357 | 2020-04-13 | Kendall | Illinois | 17093 | 114 | 2 |
56034 | 56034 | 2020-04-13 | Kendall | Texas | 48259 | 11 | 0 |
57050 | 57050 | 2020-04-14 | Kendall | Illinois | 17093 | 114 | 2 |
58739 | 58739 | 2020-04-14 | Kendall | Texas | 48259 | 12 | 0 |
59757 | 59757 | 2020-04-15 | Kendall | Illinois | 17093 | 116 | 2 |
61457 | 61457 | 2020-04-15 | Kendall | Texas | 48259 | 14 | 0 |
62478 | 62478 | 2020-04-16 | Kendall | Illinois | 17093 | 119 | 2 |
64184 | 64184 | 2020-04-16 | Kendall | Texas | 48259 | 14 | 0 |
65211 | 65211 | 2020-04-17 | Kendall | Illinois | 17093 | 123 | 2 |
66931 | 66931 | 2020-04-17 | Kendall | Texas | 48259 | 14 | 0 |
67960 | 67960 | 2020-04-18 | Kendall | Illinois | 17093 | 135 | 3 |
69691 | 69691 | 2020-04-18 | Kendall | Texas | 48259 | 14 | 0 |
70722 | 70722 | 2020-04-19 | Kendall | Illinois | 17093 | 135 | 3 |
72460 | 72460 | 2020-04-19 | Kendall | Texas | 48259 | 14 | 0 |
73492 | 73492 | 2020-04-20 | Kendall | Illinois | 17093 | 138 | 3 |
75236 | 75236 | 2020-04-20 | Kendall | Texas | 48259 | 14 | 0 |
76269 | 76269 | 2020-04-21 | Kendall | Illinois | 17093 | 146 | 3 |
78018 | 78018 | 2020-04-21 | Kendall | Texas | 48259 | 14 | 0 |
79053 | 79053 | 2020-04-22 | Kendall | Illinois | 17093 | 157 | 4 |
80809 | 80809 | 2020-04-22 | Kendall | Texas | 48259 | 14 | 0 |
81846 | 81846 | 2020-04-23 | Kendall | Illinois | 17093 | 171 | 5 |
83610 | 83610 | 2020-04-23 | Kendall | Texas | 48259 | 15 | 0 |
84646 | 84646 | 2020-04-24 | Kendall | Illinois | 17093 | 191 | 5 |
86415 | 86415 | 2020-04-24 | Kendall | Texas | 48259 | 15 | 0 |
87456 | 87456 | 2020-04-25 | Kendall | Illinois | 17093 | 203 | 5 |
89230 | 89230 | 2020-04-25 | Kendall | Texas | 48259 | 16 | 0 |
90272 | 90272 | 2020-04-26 | Kendall | Illinois | 17093 | 208 | 5 |
92047 | 92047 | 2020-04-26 | Kendall | Texas | 48259 | 16 | 0 |
93091 | 93091 | 2020-04-27 | Kendall | Illinois | 17093 | 218 | 5 |
94876 | 94876 | 2020-04-27 | Kendall | Texas | 48259 | 16 | 0 |
95923 | 95923 | 2020-04-28 | Kendall | Illinois | 17093 | 235 | 5 |
97716 | 97716 | 2020-04-28 | Kendall | Texas | 48259 | 16 | 0 |
98767 | 98767 | 2020-04-29 | Kendall | Illinois | 17093 | 255 | 7 |
100566 | 100566 | 2020-04-29 | Kendall | Texas | 48259 | 16 | 0 |
101618 | 101618 | 2020-04-30 | Kendall | Illinois | 17093 | 266 | 7 |
103421 | 103421 | 2020-04-30 | Kendall | Texas | 48259 | 16 | 0 |
104474 | 104474 | 2020-05-01 | Kendall | Illinois | 17093 | 281 | 7 |
106285 | 106285 | 2020-05-01 | Kendall | Texas | 48259 | 16 | 0 |
107339 | 107339 | 2020-05-02 | Kendall | Illinois | 17093 | 291 | 9 |
109154 | 109154 | 2020-05-02 | Kendall | Texas | 48259 | 16 | 0 |
110209 | 110209 | 2020-05-03 | Kendall | Illinois | 17093 | 305 | 9 |
112028 | 112028 | 2020-05-03 | Kendall | Texas | 48259 | 16 | 0 |
113084 | 113084 | 2020-05-04 | Kendall | Illinois | 17093 | 326 | 9 |
114910 | 114910 | 2020-05-04 | Kendall | Texas | 48259 | 16 | 0 |
115967 | 115967 | 2020-05-05 | Kendall | Illinois | 17093 | 334 | 9 |
117869 | 117869 | 2020-05-05 | Kendall | Texas | 48259 | 17 | 0 |
118927 | 118927 | 2020-05-06 | Kendall | Illinois | 17093 | 346 | 10 |
120833 | 120833 | 2020-05-06 | Kendall | Texas | 48259 | 17 | 0 |
121897 | 121897 | 2020-05-07 | Kendall | Illinois | 17093 | 363 | 14 |
123812 | 123812 | 2020-05-07 | Kendall | Texas | 48259 | 18 | 0 |
124876 | 124876 | 2020-05-08 | Kendall | Illinois | 17093 | 373 | 14 |
126795 | 126795 | 2020-05-08 | Kendall | Texas | 48259 | 18 | 0 |
127863 | 127863 | 2020-05-09 | Kendall | Illinois | 17093 | 388 | 14 |
129784 | 129784 | 2020-05-09 | Kendall | Texas | 48259 | 19 | 0 |
130854 | 130854 | 2020-05-10 | Kendall | Illinois | 17093 | 421 | 14 |
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);