ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 10005 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3296 | 3296 | 2020-03-17 | Sussex | Delaware | 10005 | 1 | 0 |
3853 | 3853 | 2020-03-18 | Sussex | Delaware | 10005 | 3 | 0 |
4518 | 4518 | 2020-03-19 | Sussex | Delaware | 10005 | 3 | 0 |
5297 | 5297 | 2020-03-20 | Sussex | Delaware | 10005 | 7 | 0 |
6224 | 6224 | 2020-03-21 | Sussex | Delaware | 10005 | 8 | 0 |
7260 | 7260 | 2020-03-22 | Sussex | Delaware | 10005 | 12 | 0 |
8406 | 8406 | 2020-03-23 | Sussex | Delaware | 10005 | 20 | 0 |
9651 | 9651 | 2020-03-24 | Sussex | Delaware | 10005 | 23 | 0 |
11025 | 11025 | 2020-03-25 | Sussex | Delaware | 10005 | 26 | 0 |
12573 | 12573 | 2020-03-26 | Sussex | Delaware | 10005 | 33 | 1 |
14242 | 14242 | 2020-03-27 | Sussex | Delaware | 10005 | 38 | 1 |
16026 | 16026 | 2020-03-28 | Sussex | Delaware | 10005 | 59 | 1 |
17918 | 17918 | 2020-03-29 | Sussex | Delaware | 10005 | 66 | 1 |
19898 | 19898 | 2020-03-30 | Sussex | Delaware | 10005 | 81 | 2 |
21975 | 21975 | 2020-03-31 | Sussex | Delaware | 10005 | 88 | 2 |
24134 | 24134 | 2020-04-01 | Sussex | Delaware | 10005 | 101 | 3 |
26364 | 26364 | 2020-04-02 | Sussex | Delaware | 10005 | 105 | 3 |
28666 | 28666 | 2020-04-03 | Sussex | Delaware | 10005 | 117 | 3 |
31024 | 31024 | 2020-04-04 | Sussex | Delaware | 10005 | 125 | 3 |
33430 | 33430 | 2020-04-05 | Sussex | Delaware | 10005 | 151 | 3 |
35875 | 35875 | 2020-04-06 | Sussex | Delaware | 10005 | 159 | 3 |
38365 | 38365 | 2020-04-07 | Sussex | Delaware | 10005 | 210 | 4 |
40908 | 40908 | 2020-04-08 | Sussex | Delaware | 10005 | 279 | 5 |
43482 | 43482 | 2020-04-09 | Sussex | Delaware | 10005 | 294 | 7 |
46082 | 46082 | 2020-04-10 | Sussex | Delaware | 10005 | 336 | 10 |
48712 | 48712 | 2020-04-11 | Sussex | Delaware | 10005 | 404 | 10 |
51374 | 51374 | 2020-04-12 | Sussex | Delaware | 10005 | 464 | 12 |
54053 | 54053 | 2020-04-13 | Sussex | Delaware | 10005 | 551 | 15 |
56745 | 56745 | 2020-04-14 | Sussex | Delaware | 10005 | 639 | 16 |
59453 | 59453 | 2020-04-15 | Sussex | Delaware | 10005 | 678 | 17 |
62172 | 62172 | 2020-04-16 | Sussex | Delaware | 10005 | 698 | 18 |
64905 | 64905 | 2020-04-17 | Sussex | Delaware | 10005 | 811 | 22 |
67653 | 67653 | 2020-04-18 | Sussex | Delaware | 10005 | 886 | 25 |
70415 | 70415 | 2020-04-19 | Sussex | Delaware | 10005 | 886 | 25 |
73184 | 73184 | 2020-04-20 | Sussex | Delaware | 10005 | 1055 | 26 |
75960 | 75960 | 2020-04-21 | Sussex | Delaware | 10005 | 1139 | 32 |
78744 | 78744 | 2020-04-22 | Sussex | Delaware | 10005 | 1317 | 36 |
81538 | 81538 | 2020-04-23 | Sussex | Delaware | 10005 | 1377 | 37 |
84338 | 84338 | 2020-04-24 | Sussex | Delaware | 10005 | 1394 | 40 |
87146 | 87146 | 2020-04-25 | Sussex | Delaware | 10005 | 1490 | 42 |
89963 | 89963 | 2020-04-26 | Sussex | Delaware | 10005 | 1801 | 43 |
92781 | 92781 | 2020-04-27 | Sussex | Delaware | 10005 | 1870 | 45 |
95613 | 95613 | 2020-04-28 | Sussex | Delaware | 10005 | 2114 | 51 |
98458 | 98458 | 2020-04-29 | Sussex | Delaware | 10005 | 2169 | 54 |
101308 | 101308 | 2020-04-30 | Sussex | Delaware | 10005 | 2216 | 58 |
104163 | 104163 | 2020-05-01 | Sussex | Delaware | 10005 | 2292 | 62 |
107028 | 107028 | 2020-05-02 | Sussex | Delaware | 10005 | 2359 | 63 |
109897 | 109897 | 2020-05-03 | Sussex | Delaware | 10005 | 2461 | 68 |
112772 | 112772 | 2020-05-04 | Sussex | Delaware | 10005 | 2497 | 70 |
115655 | 115655 | 2020-05-05 | Sussex | Delaware | 10005 | 2520 | 72 |
118615 | 118615 | 2020-05-06 | Sussex | Delaware | 10005 | 2764 | 75 |
121584 | 121584 | 2020-05-07 | Sussex | Delaware | 10005 | 2834 | 79 |
124564 | 124564 | 2020-05-08 | Sussex | Delaware | 10005 | 2936 | 86 |
127550 | 127550 | 2020-05-09 | Sussex | Delaware | 10005 | 2990 | 90 |
130541 | 130541 | 2020-05-10 | Sussex | Delaware | 10005 | 3059 | 91 |
133532 | 133532 | 2020-05-11 | Sussex | Delaware | 10005 | 3091 | 91 |
136521 | 136521 | 2020-05-12 | Sussex | Delaware | 10005 | 3205 | 93 |
139512 | 139512 | 2020-05-13 | Sussex | Delaware | 10005 | 3336 | 99 |
142508 | 142508 | 2020-05-14 | Sussex | Delaware | 10005 | 3503 | 105 |
145508 | 145508 | 2020-05-15 | Sussex | Delaware | 10005 | 3565 | 108 |
148511 | 148511 | 2020-05-16 | Sussex | Delaware | 10005 | 3658 | 112 |
151520 | 151520 | 2020-05-17 | Sussex | Delaware | 10005 | 3739 | 113 |
154532 | 154532 | 2020-05-18 | Sussex | Delaware | 10005 | 3861 | 114 |
157548 | 157548 | 2020-05-19 | Sussex | Delaware | 10005 | 3904 | 115 |
160574 | 160574 | 2020-05-20 | Sussex | Delaware | 10005 | 3960 | 116 |
163602 | 163602 | 2020-05-21 | Sussex | Delaware | 10005 | 4006 | 117 |
166635 | 166635 | 2020-05-22 | Sussex | Delaware | 10005 | 4048 | 119 |
169672 | 169672 | 2020-05-23 | Sussex | Delaware | 10005 | 4084 | 120 |
172713 | 172713 | 2020-05-24 | Sussex | Delaware | 10005 | 4103 | 121 |
175756 | 175756 | 2020-05-25 | Sussex | Delaware | 10005 | 4118 | 126 |
178800 | 178800 | 2020-05-26 | Sussex | Delaware | 10005 | 4132 | 128 |
181844 | 181844 | 2020-05-27 | Sussex | Delaware | 10005 | 4140 | 128 |
184898 | 184898 | 2020-05-28 | Sussex | Delaware | 10005 | 4151 | 129 |
187954 | 187954 | 2020-05-29 | Sussex | Delaware | 10005 | 4155 | 131 |
191019 | 191019 | 2020-05-30 | Sussex | Delaware | 10005 | 4215 | 132 |
194086 | 194086 | 2020-05-31 | Sussex | Delaware | 10005 | 4253 | 133 |
197156 | 197156 | 2020-06-01 | Sussex | Delaware | 10005 | 4272 | 133 |
200229 | 200229 | 2020-06-02 | Sussex | Delaware | 10005 | 4299 | 135 |
203305 | 203305 | 2020-06-03 | Sussex | Delaware | 10005 | 4305 | 136 |
206385 | 206385 | 2020-06-04 | Sussex | Delaware | 10005 | 4314 | 143 |
209466 | 209466 | 2020-06-05 | Sussex | Delaware | 10005 | 4322 | 144 |
212551 | 212551 | 2020-06-06 | Sussex | Delaware | 10005 | 4342 | 144 |
215638 | 215638 | 2020-06-07 | Sussex | Delaware | 10005 | 4346 | 146 |
218729 | 218729 | 2020-06-08 | Sussex | Delaware | 10005 | 4353 | 146 |
221824 | 221824 | 2020-06-09 | Sussex | Delaware | 10005 | 4361 | 149 |
224919 | 224919 | 2020-06-10 | Sussex | Delaware | 10005 | 4373 | 149 |
228021 | 228021 | 2020-06-11 | Sussex | Delaware | 10005 | 4379 | 149 |
231124 | 231124 | 2020-06-12 | Sussex | Delaware | 10005 | 4389 | 149 |
234230 | 234230 | 2020-06-13 | Sussex | Delaware | 10005 | 4401 | 150 |
237337 | 237337 | 2020-06-14 | Sussex | Delaware | 10005 | 4406 | 150 |
240445 | 240445 | 2020-06-15 | Sussex | Delaware | 10005 | 4416 | 150 |
243556 | 243556 | 2020-06-16 | Sussex | Delaware | 10005 | 4428 | 150 |
246669 | 246669 | 2020-06-17 | Sussex | Delaware | 10005 | 4429 | 151 |
249781 | 249781 | 2020-06-18 | Sussex | Delaware | 10005 | 4431 | 152 |
252896 | 252896 | 2020-06-19 | Sussex | Delaware | 10005 | 4470 | 153 |
256015 | 256015 | 2020-06-20 | Sussex | Delaware | 10005 | 4487 | 153 |
259142 | 259142 | 2020-06-21 | Sussex | Delaware | 10005 | 4495 | 154 |
262269 | 262269 | 2020-06-22 | Sussex | Delaware | 10005 | 4501 | 154 |
265397 | 265397 | 2020-06-23 | Sussex | Delaware | 10005 | 4509 | 176 |
268527 | 268527 | 2020-06-24 | Sussex | Delaware | 10005 | 4522 | 176 |
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);