ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 17099 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3931 | 3931 | 2020-03-18 | LaSalle | Illinois | 17099 | 1 | 0 |
4607 | 4607 | 2020-03-19 | LaSalle | Illinois | 17099 | 1 | 0 |
5412 | 5412 | 2020-03-20 | LaSalle | Illinois | 17099 | 1 | 0 |
6347 | 6347 | 2020-03-21 | LaSalle | Illinois | 17099 | 1 | 0 |
7398 | 7398 | 2020-03-22 | LaSalle | Illinois | 17099 | 1 | 0 |
8553 | 8553 | 2020-03-23 | LaSalle | Illinois | 17099 | 2 | 0 |
9817 | 9817 | 2020-03-24 | LaSalle | Illinois | 17099 | 3 | 0 |
11208 | 11208 | 2020-03-25 | LaSalle | Illinois | 17099 | 3 | 0 |
12764 | 12764 | 2020-03-26 | LaSalle | Illinois | 17099 | 3 | 0 |
14442 | 14442 | 2020-03-27 | LaSalle | Illinois | 17099 | 3 | 0 |
16237 | 16237 | 2020-03-28 | LaSalle | Illinois | 17099 | 4 | 1 |
18137 | 18137 | 2020-03-29 | LaSalle | Illinois | 17099 | 4 | 2 |
20139 | 20139 | 2020-03-30 | LaSalle | Illinois | 17099 | 5 | 2 |
22231 | 22231 | 2020-03-31 | LaSalle | Illinois | 17099 | 6 | 1 |
24399 | 24399 | 2020-04-01 | LaSalle | Illinois | 17099 | 6 | 1 |
26632 | 26632 | 2020-04-02 | LaSalle | Illinois | 17099 | 6 | 1 |
28942 | 28942 | 2020-04-03 | LaSalle | Illinois | 17099 | 6 | 1 |
31305 | 31305 | 2020-04-04 | LaSalle | Illinois | 17099 | 7 | 1 |
33715 | 33715 | 2020-04-05 | LaSalle | Illinois | 17099 | 8 | 1 |
36167 | 36167 | 2020-04-06 | LaSalle | Illinois | 17099 | 11 | 1 |
38662 | 38662 | 2020-04-07 | LaSalle | Illinois | 17099 | 15 | 1 |
41207 | 41207 | 2020-04-08 | LaSalle | Illinois | 17099 | 17 | 1 |
43781 | 43781 | 2020-04-09 | LaSalle | Illinois | 17099 | 17 | 1 |
46385 | 46385 | 2020-04-10 | LaSalle | Illinois | 17099 | 19 | 1 |
49016 | 49016 | 2020-04-11 | LaSalle | Illinois | 17099 | 18 | 1 |
51678 | 51678 | 2020-04-12 | LaSalle | Illinois | 17099 | 20 | 1 |
54359 | 54359 | 2020-04-13 | LaSalle | Illinois | 17099 | 21 | 1 |
57052 | 57052 | 2020-04-14 | LaSalle | Illinois | 17099 | 23 | 1 |
59759 | 59759 | 2020-04-15 | LaSalle | Illinois | 17099 | 24 | 1 |
62480 | 62480 | 2020-04-16 | LaSalle | Illinois | 17099 | 25 | 1 |
65213 | 65213 | 2020-04-17 | LaSalle | Illinois | 17099 | 27 | 1 |
67962 | 67962 | 2020-04-18 | LaSalle | Illinois | 17099 | 27 | 1 |
70724 | 70724 | 2020-04-19 | LaSalle | Illinois | 17099 | 28 | 1 |
73494 | 73494 | 2020-04-20 | LaSalle | Illinois | 17099 | 30 | 1 |
76271 | 76271 | 2020-04-21 | LaSalle | Illinois | 17099 | 33 | 1 |
79055 | 79055 | 2020-04-22 | LaSalle | Illinois | 17099 | 38 | 1 |
81848 | 81848 | 2020-04-23 | LaSalle | Illinois | 17099 | 39 | 1 |
84648 | 84648 | 2020-04-24 | LaSalle | Illinois | 17099 | 42 | 1 |
87458 | 87458 | 2020-04-25 | LaSalle | Illinois | 17099 | 43 | 1 |
90274 | 90274 | 2020-04-26 | LaSalle | Illinois | 17099 | 44 | 1 |
93093 | 93093 | 2020-04-27 | LaSalle | Illinois | 17099 | 46 | 1 |
95925 | 95925 | 2020-04-28 | LaSalle | Illinois | 17099 | 49 | 1 |
98769 | 98769 | 2020-04-29 | LaSalle | Illinois | 17099 | 49 | 1 |
101620 | 101620 | 2020-04-30 | LaSalle | Illinois | 17099 | 53 | 1 |
104476 | 104476 | 2020-05-01 | LaSalle | Illinois | 17099 | 54 | 1 |
107341 | 107341 | 2020-05-02 | LaSalle | Illinois | 17099 | 65 | 1 |
110211 | 110211 | 2020-05-03 | LaSalle | Illinois | 17099 | 67 | 1 |
113086 | 113086 | 2020-05-04 | LaSalle | Illinois | 17099 | 70 | 1 |
115969 | 115969 | 2020-05-05 | LaSalle | Illinois | 17099 | 69 | 1 |
118929 | 118929 | 2020-05-06 | LaSalle | Illinois | 17099 | 84 | 2 |
121899 | 121899 | 2020-05-07 | LaSalle | Illinois | 17099 | 91 | 2 |
124878 | 124878 | 2020-05-08 | LaSalle | Illinois | 17099 | 93 | 3 |
127865 | 127865 | 2020-05-09 | LaSalle | Illinois | 17099 | 102 | 5 |
130856 | 130856 | 2020-05-10 | LaSalle | Illinois | 17099 | 105 | 5 |
133847 | 133847 | 2020-05-11 | LaSalle | Illinois | 17099 | 105 | 5 |
136836 | 136836 | 2020-05-12 | LaSalle | Illinois | 17099 | 106 | 5 |
139828 | 139828 | 2020-05-13 | LaSalle | Illinois | 17099 | 111 | 5 |
142824 | 142824 | 2020-05-14 | LaSalle | Illinois | 17099 | 113 | 5 |
145824 | 145824 | 2020-05-15 | LaSalle | Illinois | 17099 | 117 | 7 |
148827 | 148827 | 2020-05-16 | LaSalle | Illinois | 17099 | 121 | 8 |
151836 | 151836 | 2020-05-17 | LaSalle | Illinois | 17099 | 120 | 8 |
154848 | 154848 | 2020-05-18 | LaSalle | Illinois | 17099 | 121 | 8 |
157864 | 157864 | 2020-05-19 | LaSalle | Illinois | 17099 | 121 | 8 |
160890 | 160890 | 2020-05-20 | LaSalle | Illinois | 17099 | 130 | 8 |
163918 | 163918 | 2020-05-21 | LaSalle | Illinois | 17099 | 129 | 8 |
166951 | 166951 | 2020-05-22 | LaSalle | Illinois | 17099 | 130 | 10 |
169988 | 169988 | 2020-05-23 | LaSalle | Illinois | 17099 | 134 | 10 |
173029 | 173029 | 2020-05-24 | LaSalle | Illinois | 17099 | 139 | 10 |
176073 | 176073 | 2020-05-25 | LaSalle | Illinois | 17099 | 140 | 12 |
179117 | 179117 | 2020-05-26 | LaSalle | Illinois | 17099 | 140 | 13 |
182161 | 182161 | 2020-05-27 | LaSalle | Illinois | 17099 | 140 | 13 |
185215 | 185215 | 2020-05-28 | LaSalle | Illinois | 17099 | 141 | 13 |
188273 | 188273 | 2020-05-29 | LaSalle | Illinois | 17099 | 147 | 13 |
191338 | 191338 | 2020-05-30 | LaSalle | Illinois | 17099 | 150 | 13 |
194405 | 194405 | 2020-05-31 | LaSalle | Illinois | 17099 | 153 | 13 |
197475 | 197475 | 2020-06-01 | LaSalle | Illinois | 17099 | 153 | 13 |
200548 | 200548 | 2020-06-02 | LaSalle | Illinois | 17099 | 154 | 14 |
203624 | 203624 | 2020-06-03 | LaSalle | Illinois | 17099 | 157 | 14 |
206704 | 206704 | 2020-06-04 | LaSalle | Illinois | 17099 | 159 | 16 |
209785 | 209785 | 2020-06-05 | LaSalle | Illinois | 17099 | 160 | 16 |
212870 | 212870 | 2020-06-06 | LaSalle | Illinois | 17099 | 160 | 16 |
215957 | 215957 | 2020-06-07 | LaSalle | Illinois | 17099 | 164 | 16 |
219048 | 219048 | 2020-06-08 | LaSalle | Illinois | 17099 | 166 | 16 |
222143 | 222143 | 2020-06-09 | LaSalle | Illinois | 17099 | 168 | 16 |
225238 | 225238 | 2020-06-10 | LaSalle | Illinois | 17099 | 172 | 16 |
228340 | 228340 | 2020-06-11 | LaSalle | Illinois | 17099 | 175 | 16 |
231443 | 231443 | 2020-06-12 | LaSalle | Illinois | 17099 | 177 | 16 |
234549 | 234549 | 2020-06-13 | LaSalle | Illinois | 17099 | 177 | 16 |
237656 | 237656 | 2020-06-14 | LaSalle | Illinois | 17099 | 178 | 16 |
240764 | 240764 | 2020-06-15 | LaSalle | Illinois | 17099 | 181 | 16 |
243875 | 243875 | 2020-06-16 | LaSalle | Illinois | 17099 | 183 | 16 |
246988 | 246988 | 2020-06-17 | LaSalle | Illinois | 17099 | 183 | 16 |
250100 | 250100 | 2020-06-18 | LaSalle | Illinois | 17099 | 189 | 16 |
253215 | 253215 | 2020-06-19 | LaSalle | Illinois | 17099 | 188 | 16 |
256335 | 256335 | 2020-06-20 | LaSalle | Illinois | 17099 | 188 | 16 |
259461 | 259461 | 2020-06-21 | LaSalle | Illinois | 17099 | 190 | 16 |
262588 | 262588 | 2020-06-22 | LaSalle | Illinois | 17099 | 190 | 16 |
265716 | 265716 | 2020-06-23 | LaSalle | Illinois | 17099 | 191 | 16 |
268846 | 268846 | 2020-06-24 | LaSalle | Illinois | 17099 | 195 | 16 |
271983 | 271983 | 2020-06-25 | LaSalle | Illinois | 17099 | 199 | 17 |
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);