ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 18035 sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6366 | 6366 | 2020-03-21 | Delaware | Indiana | 18035 | 1 | 1 |
7420 | 7420 | 2020-03-22 | Delaware | Indiana | 18035 | 2 | 1 |
8577 | 8577 | 2020-03-23 | Delaware | Indiana | 18035 | 3 | 1 |
9844 | 9844 | 2020-03-24 | Delaware | Indiana | 18035 | 4 | 1 |
11238 | 11238 | 2020-03-25 | Delaware | Indiana | 18035 | 7 | 1 |
12794 | 12794 | 2020-03-26 | Delaware | Indiana | 18035 | 7 | 1 |
14474 | 14474 | 2020-03-27 | Delaware | Indiana | 18035 | 8 | 1 |
16272 | 16272 | 2020-03-28 | Delaware | Indiana | 18035 | 8 | 1 |
18174 | 18174 | 2020-03-29 | Delaware | Indiana | 18035 | 14 | 1 |
20180 | 20180 | 2020-03-30 | Delaware | Indiana | 18035 | 15 | 1 |
22274 | 22274 | 2020-03-31 | Delaware | Indiana | 18035 | 18 | 1 |
24444 | 24444 | 2020-04-01 | Delaware | Indiana | 18035 | 22 | 1 |
26683 | 26683 | 2020-04-02 | Delaware | Indiana | 18035 | 25 | 1 |
28993 | 28993 | 2020-04-03 | Delaware | Indiana | 18035 | 30 | 1 |
31359 | 31359 | 2020-04-04 | Delaware | Indiana | 18035 | 33 | 1 |
33770 | 33770 | 2020-04-05 | Delaware | Indiana | 18035 | 37 | 1 |
36223 | 36223 | 2020-04-06 | Delaware | Indiana | 18035 | 40 | 1 |
38721 | 38721 | 2020-04-07 | Delaware | Indiana | 18035 | 40 | 1 |
41267 | 41267 | 2020-04-08 | Delaware | Indiana | 18035 | 46 | 1 |
43843 | 43843 | 2020-04-09 | Delaware | Indiana | 18035 | 49 | 1 |
46447 | 46447 | 2020-04-10 | Delaware | Indiana | 18035 | 56 | 1 |
49081 | 49081 | 2020-04-11 | Delaware | Indiana | 18035 | 63 | 2 |
51744 | 51744 | 2020-04-12 | Delaware | Indiana | 18035 | 66 | 2 |
54425 | 54425 | 2020-04-13 | Delaware | Indiana | 18035 | 69 | 2 |
57118 | 57118 | 2020-04-14 | Delaware | Indiana | 18035 | 72 | 3 |
59826 | 59826 | 2020-04-15 | Delaware | Indiana | 18035 | 77 | 4 |
62547 | 62547 | 2020-04-16 | Delaware | Indiana | 18035 | 85 | 5 |
65281 | 65281 | 2020-04-17 | Delaware | Indiana | 18035 | 91 | 5 |
68030 | 68030 | 2020-04-18 | Delaware | Indiana | 18035 | 92 | 5 |
70792 | 70792 | 2020-04-19 | Delaware | Indiana | 18035 | 110 | 6 |
73563 | 73563 | 2020-04-20 | Delaware | Indiana | 18035 | 114 | 7 |
76340 | 76340 | 2020-04-21 | Delaware | Indiana | 18035 | 116 | 9 |
79124 | 79124 | 2020-04-22 | Delaware | Indiana | 18035 | 121 | 9 |
81917 | 81917 | 2020-04-23 | Delaware | Indiana | 18035 | 126 | 10 |
84717 | 84717 | 2020-04-24 | Delaware | Indiana | 18035 | 132 | 11 |
87527 | 87527 | 2020-04-25 | Delaware | Indiana | 18035 | 144 | 11 |
90343 | 90343 | 2020-04-26 | Delaware | Indiana | 18035 | 146 | 11 |
93162 | 93162 | 2020-04-27 | Delaware | Indiana | 18035 | 147 | 13 |
95994 | 95994 | 2020-04-28 | Delaware | Indiana | 18035 | 152 | 13 |
98838 | 98838 | 2020-04-29 | Delaware | Indiana | 18035 | 156 | 13 |
101689 | 101689 | 2020-04-30 | Delaware | Indiana | 18035 | 176 | 15 |
104545 | 104545 | 2020-05-01 | Delaware | Indiana | 18035 | 182 | 15 |
107410 | 107410 | 2020-05-02 | Delaware | Indiana | 18035 | 198 | 15 |
110280 | 110280 | 2020-05-03 | Delaware | Indiana | 18035 | 200 | 15 |
113155 | 113155 | 2020-05-04 | Delaware | Indiana | 18035 | 200 | 15 |
116038 | 116038 | 2020-05-05 | Delaware | Indiana | 18035 | 209 | 15 |
118998 | 118998 | 2020-05-06 | Delaware | Indiana | 18035 | 212 | 15 |
121968 | 121968 | 2020-05-07 | Delaware | Indiana | 18035 | 213 | 15 |
124948 | 124948 | 2020-05-08 | Delaware | Indiana | 18035 | 214 | 15 |
127935 | 127935 | 2020-05-09 | Delaware | Indiana | 18035 | 219 | 15 |
130926 | 130926 | 2020-05-10 | Delaware | Indiana | 18035 | 225 | 15 |
133916 | 133916 | 2020-05-11 | Delaware | Indiana | 18035 | 229 | 19 |
136905 | 136905 | 2020-05-12 | Delaware | Indiana | 18035 | 228 | 19 |
139897 | 139897 | 2020-05-13 | Delaware | Indiana | 18035 | 230 | 19 |
142893 | 142893 | 2020-05-14 | Delaware | Indiana | 18035 | 235 | 19 |
145893 | 145893 | 2020-05-15 | Delaware | Indiana | 18035 | 254 | 20 |
148897 | 148897 | 2020-05-16 | Delaware | Indiana | 18035 | 261 | 20 |
151906 | 151906 | 2020-05-17 | Delaware | Indiana | 18035 | 277 | 22 |
154918 | 154918 | 2020-05-18 | Delaware | Indiana | 18035 | 296 | 23 |
157934 | 157934 | 2020-05-19 | Delaware | Indiana | 18035 | 297 | 23 |
160960 | 160960 | 2020-05-20 | Delaware | Indiana | 18035 | 297 | 24 |
163988 | 163988 | 2020-05-21 | Delaware | Indiana | 18035 | 319 | 25 |
167021 | 167021 | 2020-05-22 | Delaware | Indiana | 18035 | 328 | 26 |
170058 | 170058 | 2020-05-23 | Delaware | Indiana | 18035 | 340 | 27 |
173099 | 173099 | 2020-05-24 | Delaware | Indiana | 18035 | 349 | 33 |
176143 | 176143 | 2020-05-25 | Delaware | Indiana | 18035 | 354 | 34 |
179187 | 179187 | 2020-05-26 | Delaware | Indiana | 18035 | 357 | 35 |
182231 | 182231 | 2020-05-27 | Delaware | Indiana | 18035 | 360 | 37 |
185285 | 185285 | 2020-05-28 | Delaware | Indiana | 18035 | 377 | 37 |
188343 | 188343 | 2020-05-29 | Delaware | Indiana | 18035 | 378 | 37 |
191408 | 191408 | 2020-05-30 | Delaware | Indiana | 18035 | 386 | 37 |
194475 | 194475 | 2020-05-31 | Delaware | Indiana | 18035 | 386 | 38 |
197545 | 197545 | 2020-06-01 | Delaware | Indiana | 18035 | 386 | 40 |
200618 | 200618 | 2020-06-02 | Delaware | Indiana | 18035 | 386 | 41 |
203694 | 203694 | 2020-06-03 | Delaware | Indiana | 18035 | 388 | 41 |
206774 | 206774 | 2020-06-04 | Delaware | Indiana | 18035 | 390 | 41 |
209855 | 209855 | 2020-06-05 | Delaware | Indiana | 18035 | 398 | 42 |
212940 | 212940 | 2020-06-06 | Delaware | Indiana | 18035 | 400 | 42 |
216027 | 216027 | 2020-06-07 | Delaware | Indiana | 18035 | 401 | 42 |
219119 | 219119 | 2020-06-08 | Delaware | Indiana | 18035 | 401 | 42 |
222214 | 222214 | 2020-06-09 | Delaware | Indiana | 18035 | 402 | 43 |
225309 | 225309 | 2020-06-10 | Delaware | Indiana | 18035 | 401 | 44 |
228411 | 228411 | 2020-06-11 | Delaware | Indiana | 18035 | 401 | 44 |
231514 | 231514 | 2020-06-12 | Delaware | Indiana | 18035 | 401 | 44 |
234620 | 234620 | 2020-06-13 | Delaware | Indiana | 18035 | 403 | 45 |
237727 | 237727 | 2020-06-14 | Delaware | Indiana | 18035 | 404 | 45 |
240835 | 240835 | 2020-06-15 | Delaware | Indiana | 18035 | 404 | 45 |
243946 | 243946 | 2020-06-16 | Delaware | Indiana | 18035 | 404 | 45 |
247059 | 247059 | 2020-06-17 | Delaware | Indiana | 18035 | 405 | 45 |
250171 | 250171 | 2020-06-18 | Delaware | Indiana | 18035 | 407 | 45 |
253286 | 253286 | 2020-06-19 | Delaware | Indiana | 18035 | 409 | 46 |
256406 | 256406 | 2020-06-20 | Delaware | Indiana | 18035 | 410 | 47 |
259532 | 259532 | 2020-06-21 | Delaware | Indiana | 18035 | 409 | 47 |
262659 | 262659 | 2020-06-22 | Delaware | Indiana | 18035 | 409 | 48 |
265787 | 265787 | 2020-06-23 | Delaware | Indiana | 18035 | 412 | 48 |
268917 | 268917 | 2020-06-24 | Delaware | Indiana | 18035 | 414 | 48 |
272054 | 272054 | 2020-06-25 | Delaware | Indiana | 18035 | 415 | 48 |
275196 | 275196 | 2020-06-26 | Delaware | Indiana | 18035 | 416 | 48 |
278344 | 278344 | 2020-06-27 | Delaware | Indiana | 18035 | 421 | 49 |
281492 | 281492 | 2020-06-28 | Delaware | Indiana | 18035 | 424 | 49 |
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);