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 cases
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 |
12159 | 12159 | 2020-03-25 | Kendall | Texas | 48259 | 3 | 0 |
13790 | 13790 | 2020-03-26 | Kendall | Texas | 48259 | 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 |
15546 | 15546 | 2020-03-27 | Kendall | Texas | 48259 | 4 | 0 |
11207 | 11207 | 2020-03-25 | Kendall | Illinois | 17093 | 6 | 0 |
17415 | 17415 | 2020-03-28 | Kendall | Texas | 48259 | 6 | 0 |
12763 | 12763 | 2020-03-26 | Kendall | Illinois | 17093 | 7 | 0 |
19369 | 19369 | 2020-03-29 | Kendall | Texas | 48259 | 7 | 0 |
21429 | 21429 | 2020-03-30 | Kendall | Texas | 48259 | 7 | 0 |
23568 | 23568 | 2020-03-31 | Kendall | Texas | 48259 | 7 | 0 |
25778 | 25778 | 2020-04-01 | Kendall | Texas | 48259 | 7 | 0 |
14441 | 14441 | 2020-03-27 | Kendall | Illinois | 17093 | 8 | 0 |
28063 | 28063 | 2020-04-02 | Kendall | Texas | 48259 | 8 | 0 |
30398 | 30398 | 2020-04-03 | Kendall | Texas | 48259 | 8 | 0 |
32793 | 32793 | 2020-04-04 | Kendall | Texas | 48259 | 9 | 0 |
42802 | 42802 | 2020-04-08 | Kendall | Texas | 48259 | 9 | 0 |
45392 | 45392 | 2020-04-09 | Kendall | Texas | 48259 | 9 | 0 |
35231 | 35231 | 2020-04-05 | Kendall | Texas | 48259 | 10 | 0 |
37707 | 37707 | 2020-04-06 | Kendall | Texas | 48259 | 10 | 0 |
40234 | 40234 | 2020-04-07 | Kendall | Texas | 48259 | 10 | 0 |
48013 | 48013 | 2020-04-10 | Kendall | Texas | 48259 | 10 | 0 |
50671 | 50671 | 2020-04-11 | Kendall | Texas | 48259 | 10 | 0 |
16236 | 16236 | 2020-03-28 | Kendall | Illinois | 17093 | 11 | 0 |
53346 | 53346 | 2020-04-12 | Kendall | Texas | 48259 | 11 | 0 |
56034 | 56034 | 2020-04-13 | Kendall | Texas | 48259 | 11 | 0 |
58739 | 58739 | 2020-04-14 | Kendall | Texas | 48259 | 12 | 0 |
61457 | 61457 | 2020-04-15 | Kendall | Texas | 48259 | 14 | 0 |
64184 | 64184 | 2020-04-16 | Kendall | Texas | 48259 | 14 | 0 |
66931 | 66931 | 2020-04-17 | Kendall | Texas | 48259 | 14 | 0 |
69691 | 69691 | 2020-04-18 | Kendall | Texas | 48259 | 14 | 0 |
72460 | 72460 | 2020-04-19 | Kendall | Texas | 48259 | 14 | 0 |
75236 | 75236 | 2020-04-20 | Kendall | Texas | 48259 | 14 | 0 |
78018 | 78018 | 2020-04-21 | Kendall | Texas | 48259 | 14 | 0 |
80809 | 80809 | 2020-04-22 | Kendall | Texas | 48259 | 14 | 0 |
18135 | 18135 | 2020-03-29 | Kendall | Illinois | 17093 | 15 | 1 |
83610 | 83610 | 2020-04-23 | Kendall | Texas | 48259 | 15 | 0 |
86415 | 86415 | 2020-04-24 | Kendall | Texas | 48259 | 15 | 0 |
89230 | 89230 | 2020-04-25 | Kendall | Texas | 48259 | 16 | 0 |
92047 | 92047 | 2020-04-26 | Kendall | Texas | 48259 | 16 | 0 |
94876 | 94876 | 2020-04-27 | Kendall | Texas | 48259 | 16 | 0 |
97716 | 97716 | 2020-04-28 | Kendall | Texas | 48259 | 16 | 0 |
100566 | 100566 | 2020-04-29 | Kendall | Texas | 48259 | 16 | 0 |
103421 | 103421 | 2020-04-30 | Kendall | Texas | 48259 | 16 | 0 |
106285 | 106285 | 2020-05-01 | Kendall | Texas | 48259 | 16 | 0 |
109154 | 109154 | 2020-05-02 | Kendall | Texas | 48259 | 16 | 0 |
112028 | 112028 | 2020-05-03 | Kendall | Texas | 48259 | 16 | 0 |
114910 | 114910 | 2020-05-04 | Kendall | Texas | 48259 | 16 | 0 |
117869 | 117869 | 2020-05-05 | Kendall | Texas | 48259 | 17 | 0 |
120833 | 120833 | 2020-05-06 | Kendall | Texas | 48259 | 17 | 0 |
20137 | 20137 | 2020-03-30 | Kendall | Illinois | 17093 | 18 | 2 |
123812 | 123812 | 2020-05-07 | Kendall | Texas | 48259 | 18 | 0 |
126795 | 126795 | 2020-05-08 | Kendall | Texas | 48259 | 18 | 0 |
22229 | 22229 | 2020-03-31 | Kendall | Illinois | 17093 | 19 | 2 |
129784 | 129784 | 2020-05-09 | Kendall | Texas | 48259 | 19 | 0 |
132774 | 132774 | 2020-05-10 | Kendall | Texas | 48259 | 19 | 0 |
135765 | 135765 | 2020-05-11 | Kendall | Texas | 48259 | 19 | 0 |
138755 | 138755 | 2020-05-12 | Kendall | Texas | 48259 | 20 | 0 |
141751 | 141751 | 2020-05-13 | Kendall | Texas | 48259 | 20 | 0 |
144748 | 144748 | 2020-05-14 | Kendall | Texas | 48259 | 20 | 0 |
147752 | 147752 | 2020-05-15 | Kendall | Texas | 48259 | 20 | 0 |
150760 | 150760 | 2020-05-16 | Kendall | Texas | 48259 | 21 | 0 |
153771 | 153771 | 2020-05-17 | Kendall | Texas | 48259 | 21 | 0 |
156788 | 156788 | 2020-05-18 | Kendall | Texas | 48259 | 21 | 0 |
159810 | 159810 | 2020-05-19 | Kendall | Texas | 48259 | 23 | 0 |
162838 | 162838 | 2020-05-20 | Kendall | Texas | 48259 | 24 | 0 |
165867 | 165867 | 2020-05-21 | Kendall | Texas | 48259 | 24 | 0 |
168903 | 168903 | 2020-05-22 | Kendall | Texas | 48259 | 24 | 0 |
171943 | 171943 | 2020-05-23 | Kendall | Texas | 48259 | 24 | 0 |
174986 | 174986 | 2020-05-24 | Kendall | Texas | 48259 | 24 | 0 |
178030 | 178030 | 2020-05-25 | Kendall | Texas | 48259 | 24 | 0 |
181074 | 181074 | 2020-05-26 | Kendall | Texas | 48259 | 24 | 0 |
24397 | 24397 | 2020-04-01 | Kendall | Illinois | 17093 | 27 | 2 |
184124 | 184124 | 2020-05-27 | Kendall | Texas | 48259 | 28 | 0 |
187181 | 187181 | 2020-05-28 | Kendall | Texas | 48259 | 28 | 0 |
190245 | 190245 | 2020-05-29 | Kendall | Texas | 48259 | 28 | 0 |
193310 | 193310 | 2020-05-30 | Kendall | Texas | 48259 | 29 | 0 |
196380 | 196380 | 2020-05-31 | Kendall | Texas | 48259 | 29 | 0 |
199453 | 199453 | 2020-06-01 | Kendall | Texas | 48259 | 29 | 0 |
202529 | 202529 | 2020-06-02 | Kendall | Texas | 48259 | 30 | 0 |
205608 | 205608 | 2020-06-03 | Kendall | Texas | 48259 | 31 | 0 |
208690 | 208690 | 2020-06-04 | Kendall | Texas | 48259 | 31 | 0 |
211774 | 211774 | 2020-06-05 | Kendall | Texas | 48259 | 32 | 0 |
214861 | 214861 | 2020-06-06 | Kendall | Texas | 48259 | 33 | 0 |
217951 | 217951 | 2020-06-07 | Kendall | Texas | 48259 | 33 | 0 |
221043 | 221043 | 2020-06-08 | Kendall | Texas | 48259 | 33 | 0 |
224138 | 224138 | 2020-06-09 | Kendall | Texas | 48259 | 33 | 0 |
227238 | 227238 | 2020-06-10 | Kendall | Texas | 48259 | 35 | 0 |
230342 | 230342 | 2020-06-11 | Kendall | Texas | 48259 | 35 | 0 |
233446 | 233446 | 2020-06-12 | Kendall | Texas | 48259 | 35 | 0 |
236552 | 236552 | 2020-06-13 | Kendall | Texas | 48259 | 35 | 0 |
26630 | 26630 | 2020-04-02 | Kendall | Illinois | 17093 | 36 | 2 |
239660 | 239660 | 2020-06-14 | Kendall | Texas | 48259 | 36 | 0 |
242770 | 242770 | 2020-06-15 | Kendall | Texas | 48259 | 36 | 0 |
245882 | 245882 | 2020-06-16 | Kendall | Texas | 48259 | 36 | 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);