ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "New Castle" 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 |
---|---|---|---|---|---|---|---|
1199 | 1199 | 2020-03-11 | New Castle | Delaware | 10003 | 1 | 0 |
1408 | 1408 | 2020-03-12 | New Castle | Delaware | 10003 | 4 | 0 |
1674 | 1674 | 2020-03-13 | New Castle | Delaware | 10003 | 4 | 0 |
1996 | 1996 | 2020-03-14 | New Castle | Delaware | 10003 | 4 | 0 |
2378 | 2378 | 2020-03-15 | New Castle | Delaware | 10003 | 7 | 0 |
2813 | 2813 | 2020-03-16 | New Castle | Delaware | 10003 | 8 | 0 |
3295 | 3295 | 2020-03-17 | New Castle | Delaware | 10003 | 15 | 0 |
3852 | 3852 | 2020-03-18 | New Castle | Delaware | 10003 | 20 | 0 |
4517 | 4517 | 2020-03-19 | New Castle | Delaware | 10003 | 23 | 0 |
5296 | 5296 | 2020-03-20 | New Castle | Delaware | 10003 | 28 | 0 |
6223 | 6223 | 2020-03-21 | New Castle | Delaware | 10003 | 32 | 0 |
7259 | 7259 | 2020-03-22 | New Castle | Delaware | 10003 | 39 | 0 |
8405 | 8405 | 2020-03-23 | New Castle | Delaware | 10003 | 58 | 0 |
9650 | 9650 | 2020-03-24 | New Castle | Delaware | 10003 | 71 | 0 |
11024 | 11024 | 2020-03-25 | New Castle | Delaware | 10003 | 79 | 0 |
12572 | 12572 | 2020-03-26 | New Castle | Delaware | 10003 | 91 | 0 |
14241 | 14241 | 2020-03-27 | New Castle | Delaware | 10003 | 106 | 1 |
16025 | 16025 | 2020-03-28 | New Castle | Delaware | 10003 | 130 | 2 |
17917 | 17917 | 2020-03-29 | New Castle | Delaware | 10003 | 141 | 3 |
19897 | 19897 | 2020-03-30 | New Castle | Delaware | 10003 | 156 | 3 |
21974 | 21974 | 2020-03-31 | New Castle | Delaware | 10003 | 197 | 6 |
24133 | 24133 | 2020-04-01 | New Castle | Delaware | 10003 | 226 | 6 |
26363 | 26363 | 2020-04-02 | New Castle | Delaware | 10003 | 245 | 7 |
28665 | 28665 | 2020-04-03 | New Castle | Delaware | 10003 | 279 | 9 |
31023 | 31023 | 2020-04-04 | New Castle | Delaware | 10003 | 400 | 9 |
33429 | 33429 | 2020-04-05 | New Castle | Delaware | 10003 | 436 | 9 |
35874 | 35874 | 2020-04-06 | New Castle | Delaware | 10003 | 496 | 9 |
38364 | 38364 | 2020-04-07 | New Castle | Delaware | 10003 | 571 | 9 |
40907 | 40907 | 2020-04-08 | New Castle | Delaware | 10003 | 636 | 11 |
43481 | 43481 | 2020-04-09 | New Castle | Delaware | 10003 | 701 | 13 |
46081 | 46081 | 2020-04-10 | New Castle | Delaware | 10003 | 751 | 19 |
48711 | 48711 | 2020-04-11 | New Castle | Delaware | 10003 | 807 | 19 |
51373 | 51373 | 2020-04-12 | New Castle | Delaware | 10003 | 880 | 19 |
54052 | 54052 | 2020-04-13 | New Castle | Delaware | 10003 | 919 | 20 |
56744 | 56744 | 2020-04-14 | New Castle | Delaware | 10003 | 947 | 20 |
59452 | 59452 | 2020-04-15 | New Castle | Delaware | 10003 | 974 | 21 |
62171 | 62171 | 2020-04-16 | New Castle | Delaware | 10003 | 1003 | 25 |
64904 | 64904 | 2020-04-17 | New Castle | Delaware | 10003 | 1100 | 30 |
67652 | 67652 | 2020-04-18 | New Castle | Delaware | 10003 | 1205 | 32 |
70414 | 70414 | 2020-04-19 | New Castle | Delaware | 10003 | 1205 | 32 |
73183 | 73183 | 2020-04-20 | New Castle | Delaware | 10003 | 1229 | 33 |
75959 | 75959 | 2020-04-21 | New Castle | Delaware | 10003 | 1303 | 36 |
78743 | 78743 | 2020-04-22 | New Castle | Delaware | 10003 | 1352 | 38 |
81537 | 81537 | 2020-04-23 | New Castle | Delaware | 10003 | 1389 | 40 |
84337 | 84337 | 2020-04-24 | New Castle | Delaware | 10003 | 1486 | 45 |
87145 | 87145 | 2020-04-25 | New Castle | Delaware | 10003 | 1504 | 52 |
89962 | 89962 | 2020-04-26 | New Castle | Delaware | 10003 | 1599 | 55 |
92780 | 92780 | 2020-04-27 | New Castle | Delaware | 10003 | 1629 | 57 |
95612 | 95612 | 2020-04-28 | New Castle | Delaware | 10003 | 1701 | 63 |
98457 | 98457 | 2020-04-29 | New Castle | Delaware | 10003 | 1717 | 65 |
101307 | 101307 | 2020-04-30 | New Castle | Delaware | 10003 | 1734 | 68 |
104162 | 104162 | 2020-05-01 | New Castle | Delaware | 10003 | 1829 | 70 |
107027 | 107027 | 2020-05-02 | New Castle | Delaware | 10003 | 1864 | 76 |
109896 | 109896 | 2020-05-03 | New Castle | Delaware | 10003 | 1903 | 79 |
112771 | 112771 | 2020-05-04 | New Castle | Delaware | 10003 | 1934 | 82 |
115654 | 115654 | 2020-05-05 | New Castle | Delaware | 10003 | 1979 | 83 |
118614 | 118614 | 2020-05-06 | New Castle | Delaware | 10003 | 2087 | 85 |
121583 | 121583 | 2020-05-07 | New Castle | Delaware | 10003 | 2130 | 89 |
124563 | 124563 | 2020-05-08 | New Castle | Delaware | 10003 | 2184 | 91 |
127549 | 127549 | 2020-05-09 | New Castle | Delaware | 10003 | 2275 | 93 |
130540 | 130540 | 2020-05-10 | New Castle | Delaware | 10003 | 2331 | 95 |
133531 | 133531 | 2020-05-11 | New Castle | Delaware | 10003 | 2390 | 95 |
136520 | 136520 | 2020-05-12 | New Castle | Delaware | 10003 | 2440 | 100 |
139511 | 139511 | 2020-05-13 | New Castle | Delaware | 10003 | 2496 | 102 |
142507 | 142507 | 2020-05-14 | New Castle | Delaware | 10003 | 2560 | 108 |
145507 | 145507 | 2020-05-15 | New Castle | Delaware | 10003 | 2619 | 114 |
148510 | 148510 | 2020-05-16 | New Castle | Delaware | 10003 | 2667 | 121 |
151519 | 151519 | 2020-05-17 | New Castle | Delaware | 10003 | 2682 | 124 |
154531 | 154531 | 2020-05-18 | New Castle | Delaware | 10003 | 2738 | 130 |
157547 | 157547 | 2020-05-19 | New Castle | Delaware | 10003 | 2845 | 135 |
160573 | 160573 | 2020-05-20 | New Castle | Delaware | 10003 | 2933 | 138 |
163601 | 163601 | 2020-05-21 | New Castle | Delaware | 10003 | 3053 | 144 |
166634 | 166634 | 2020-05-22 | New Castle | Delaware | 10003 | 3132 | 146 |
169671 | 169671 | 2020-05-23 | New Castle | Delaware | 10003 | 3238 | 147 |
172712 | 172712 | 2020-05-24 | New Castle | Delaware | 10003 | 3309 | 148 |
175755 | 175755 | 2020-05-25 | New Castle | Delaware | 10003 | 3436 | 149 |
178799 | 178799 | 2020-05-26 | New Castle | Delaware | 10003 | 3508 | 150 |
181843 | 181843 | 2020-05-27 | New Castle | Delaware | 10003 | 3528 | 155 |
184897 | 184897 | 2020-05-28 | New Castle | Delaware | 10003 | 3575 | 155 |
187953 | 187953 | 2020-05-29 | New Castle | Delaware | 10003 | 3629 | 163 |
191018 | 191018 | 2020-05-30 | New Castle | Delaware | 10003 | 3723 | 166 |
194085 | 194085 | 2020-05-31 | New Castle | Delaware | 10003 | 3758 | 170 |
197155 | 197155 | 2020-06-01 | New Castle | Delaware | 10003 | 3838 | 172 |
200228 | 200228 | 2020-06-02 | New Castle | Delaware | 10003 | 3883 | 172 |
203304 | 203304 | 2020-06-03 | New Castle | Delaware | 10003 | 3903 | 173 |
206384 | 206384 | 2020-06-04 | New Castle | Delaware | 10003 | 3925 | 173 |
209465 | 209465 | 2020-06-05 | New Castle | Delaware | 10003 | 3937 | 173 |
212550 | 212550 | 2020-06-06 | New Castle | Delaware | 10003 | 3995 | 174 |
215637 | 215637 | 2020-06-07 | New Castle | Delaware | 10003 | 4070 | 176 |
218728 | 218728 | 2020-06-08 | New Castle | Delaware | 10003 | 4095 | 176 |
221823 | 221823 | 2020-06-09 | New Castle | Delaware | 10003 | 4125 | 185 |
224918 | 224918 | 2020-06-10 | New Castle | Delaware | 10003 | 4139 | 186 |
228020 | 228020 | 2020-06-11 | New Castle | Delaware | 10003 | 4171 | 186 |
231123 | 231123 | 2020-06-12 | New Castle | Delaware | 10003 | 4224 | 186 |
234229 | 234229 | 2020-06-13 | New Castle | Delaware | 10003 | 4259 | 187 |
237336 | 237336 | 2020-06-14 | New Castle | Delaware | 10003 | 4287 | 189 |
240444 | 240444 | 2020-06-15 | New Castle | Delaware | 10003 | 4345 | 190 |
243555 | 243555 | 2020-06-16 | New Castle | Delaware | 10003 | 4386 | 190 |
246668 | 246668 | 2020-06-17 | New Castle | Delaware | 10003 | 4422 | 191 |
249780 | 249780 | 2020-06-18 | New Castle | Delaware | 10003 | 4470 | 195 |
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);