ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Kendall" and fips = 17093 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, 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 |
12763 | 12763 | 2020-03-26 | Kendall | Illinois | 17093 | 7 | 0 |
14441 | 14441 | 2020-03-27 | Kendall | Illinois | 17093 | 8 | 0 |
16236 | 16236 | 2020-03-28 | Kendall | Illinois | 17093 | 11 | 0 |
18135 | 18135 | 2020-03-29 | Kendall | Illinois | 17093 | 15 | 1 |
20137 | 20137 | 2020-03-30 | Kendall | Illinois | 17093 | 18 | 2 |
22229 | 22229 | 2020-03-31 | Kendall | Illinois | 17093 | 19 | 2 |
24397 | 24397 | 2020-04-01 | Kendall | Illinois | 17093 | 27 | 2 |
26630 | 26630 | 2020-04-02 | Kendall | Illinois | 17093 | 36 | 2 |
28940 | 28940 | 2020-04-03 | Kendall | Illinois | 17093 | 37 | 2 |
31303 | 31303 | 2020-04-04 | Kendall | Illinois | 17093 | 47 | 2 |
33713 | 33713 | 2020-04-05 | Kendall | Illinois | 17093 | 49 | 2 |
36165 | 36165 | 2020-04-06 | Kendall | Illinois | 17093 | 55 | 2 |
38660 | 38660 | 2020-04-07 | Kendall | Illinois | 17093 | 61 | 2 |
41205 | 41205 | 2020-04-08 | Kendall | Illinois | 17093 | 79 | 2 |
43779 | 43779 | 2020-04-09 | Kendall | Illinois | 17093 | 86 | 2 |
46383 | 46383 | 2020-04-10 | Kendall | Illinois | 17093 | 92 | 2 |
49014 | 49014 | 2020-04-11 | Kendall | Illinois | 17093 | 103 | 2 |
51676 | 51676 | 2020-04-12 | Kendall | Illinois | 17093 | 105 | 2 |
54357 | 54357 | 2020-04-13 | Kendall | Illinois | 17093 | 114 | 2 |
57050 | 57050 | 2020-04-14 | Kendall | Illinois | 17093 | 114 | 2 |
59757 | 59757 | 2020-04-15 | Kendall | Illinois | 17093 | 116 | 2 |
62478 | 62478 | 2020-04-16 | Kendall | Illinois | 17093 | 119 | 2 |
65211 | 65211 | 2020-04-17 | Kendall | Illinois | 17093 | 123 | 2 |
67960 | 67960 | 2020-04-18 | Kendall | Illinois | 17093 | 135 | 3 |
70722 | 70722 | 2020-04-19 | Kendall | Illinois | 17093 | 135 | 3 |
73492 | 73492 | 2020-04-20 | Kendall | Illinois | 17093 | 138 | 3 |
76269 | 76269 | 2020-04-21 | Kendall | Illinois | 17093 | 146 | 3 |
79053 | 79053 | 2020-04-22 | Kendall | Illinois | 17093 | 157 | 4 |
81846 | 81846 | 2020-04-23 | Kendall | Illinois | 17093 | 171 | 5 |
84646 | 84646 | 2020-04-24 | Kendall | Illinois | 17093 | 191 | 5 |
87456 | 87456 | 2020-04-25 | Kendall | Illinois | 17093 | 203 | 5 |
90272 | 90272 | 2020-04-26 | Kendall | Illinois | 17093 | 208 | 5 |
93091 | 93091 | 2020-04-27 | Kendall | Illinois | 17093 | 218 | 5 |
95923 | 95923 | 2020-04-28 | Kendall | Illinois | 17093 | 235 | 5 |
98767 | 98767 | 2020-04-29 | Kendall | Illinois | 17093 | 255 | 7 |
101618 | 101618 | 2020-04-30 | Kendall | Illinois | 17093 | 266 | 7 |
104474 | 104474 | 2020-05-01 | Kendall | Illinois | 17093 | 281 | 7 |
107339 | 107339 | 2020-05-02 | Kendall | Illinois | 17093 | 291 | 9 |
110209 | 110209 | 2020-05-03 | Kendall | Illinois | 17093 | 305 | 9 |
113084 | 113084 | 2020-05-04 | Kendall | Illinois | 17093 | 326 | 9 |
115967 | 115967 | 2020-05-05 | Kendall | Illinois | 17093 | 334 | 9 |
118927 | 118927 | 2020-05-06 | Kendall | Illinois | 17093 | 346 | 10 |
121897 | 121897 | 2020-05-07 | Kendall | Illinois | 17093 | 363 | 14 |
124876 | 124876 | 2020-05-08 | Kendall | Illinois | 17093 | 373 | 14 |
127863 | 127863 | 2020-05-09 | Kendall | Illinois | 17093 | 388 | 14 |
130854 | 130854 | 2020-05-10 | Kendall | Illinois | 17093 | 421 | 14 |
133845 | 133845 | 2020-05-11 | Kendall | Illinois | 17093 | 431 | 14 |
136834 | 136834 | 2020-05-12 | Kendall | Illinois | 17093 | 477 | 16 |
139826 | 139826 | 2020-05-13 | Kendall | Illinois | 17093 | 497 | 20 |
142822 | 142822 | 2020-05-14 | Kendall | Illinois | 17093 | 518 | 20 |
145822 | 145822 | 2020-05-15 | Kendall | Illinois | 17093 | 531 | 20 |
148825 | 148825 | 2020-05-16 | Kendall | Illinois | 17093 | 559 | 20 |
151834 | 151834 | 2020-05-17 | Kendall | Illinois | 17093 | 563 | 20 |
154846 | 154846 | 2020-05-18 | Kendall | Illinois | 17093 | 579 | 22 |
157862 | 157862 | 2020-05-19 | Kendall | Illinois | 17093 | 602 | 22 |
160888 | 160888 | 2020-05-20 | Kendall | Illinois | 17093 | 635 | 22 |
163916 | 163916 | 2020-05-21 | Kendall | Illinois | 17093 | 650 | 22 |
166949 | 166949 | 2020-05-22 | Kendall | Illinois | 17093 | 680 | 22 |
169986 | 169986 | 2020-05-23 | Kendall | Illinois | 17093 | 705 | 22 |
173027 | 173027 | 2020-05-24 | Kendall | Illinois | 17093 | 709 | 22 |
176071 | 176071 | 2020-05-25 | Kendall | Illinois | 17093 | 722 | 22 |
179115 | 179115 | 2020-05-26 | Kendall | Illinois | 17093 | 754 | 22 |
182159 | 182159 | 2020-05-27 | Kendall | Illinois | 17093 | 769 | 22 |
185213 | 185213 | 2020-05-28 | Kendall | Illinois | 17093 | 781 | 22 |
188271 | 188271 | 2020-05-29 | Kendall | Illinois | 17093 | 793 | 22 |
191336 | 191336 | 2020-05-30 | Kendall | Illinois | 17093 | 793 | 22 |
194403 | 194403 | 2020-05-31 | Kendall | Illinois | 17093 | 798 | 22 |
197473 | 197473 | 2020-06-01 | Kendall | Illinois | 17093 | 832 | 22 |
200546 | 200546 | 2020-06-02 | Kendall | Illinois | 17093 | 843 | 22 |
203622 | 203622 | 2020-06-03 | Kendall | Illinois | 17093 | 853 | 22 |
206702 | 206702 | 2020-06-04 | Kendall | Illinois | 17093 | 860 | 22 |
209783 | 209783 | 2020-06-05 | Kendall | Illinois | 17093 | 868 | 22 |
212868 | 212868 | 2020-06-06 | Kendall | Illinois | 17093 | 869 | 22 |
215955 | 215955 | 2020-06-07 | Kendall | Illinois | 17093 | 869 | 22 |
219046 | 219046 | 2020-06-08 | Kendall | Illinois | 17093 | 874 | 22 |
222141 | 222141 | 2020-06-09 | Kendall | Illinois | 17093 | 886 | 22 |
225236 | 225236 | 2020-06-10 | Kendall | Illinois | 17093 | 893 | 22 |
228338 | 228338 | 2020-06-11 | Kendall | Illinois | 17093 | 898 | 22 |
231441 | 231441 | 2020-06-12 | Kendall | Illinois | 17093 | 905 | 22 |
234547 | 234547 | 2020-06-13 | Kendall | Illinois | 17093 | 906 | 22 |
237654 | 237654 | 2020-06-14 | Kendall | Illinois | 17093 | 906 | 22 |
240762 | 240762 | 2020-06-15 | Kendall | Illinois | 17093 | 911 | 22 |
243873 | 243873 | 2020-06-16 | Kendall | Illinois | 17093 | 924 | 22 |
246986 | 246986 | 2020-06-17 | Kendall | Illinois | 17093 | 928 | 22 |
250098 | 250098 | 2020-06-18 | Kendall | Illinois | 17093 | 938 | 22 |
253213 | 253213 | 2020-06-19 | Kendall | Illinois | 17093 | 943 | 22 |
256333 | 256333 | 2020-06-20 | Kendall | Illinois | 17093 | 946 | 22 |
259459 | 259459 | 2020-06-21 | Kendall | Illinois | 17093 | 946 | 22 |
262586 | 262586 | 2020-06-22 | Kendall | Illinois | 17093 | 949 | 22 |
265714 | 265714 | 2020-06-23 | Kendall | Illinois | 17093 | 966 | 22 |
268844 | 268844 | 2020-06-24 | Kendall | Illinois | 17093 | 971 | 22 |
271981 | 271981 | 2020-06-25 | Kendall | Illinois | 17093 | 982 | 22 |
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);