ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Delaware" and state = "New York" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- …
state 1
- New York · 793 ✖
fips 1
- 36025 793
county 1
- Delaware · 793 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1517 | 1517 | 2020-03-12 | Delaware | New York | 36025 | 1 | 0 |
1810 | 1810 | 2020-03-13 | Delaware | New York | 36025 | 1 | 0 |
2159 | 2159 | 2020-03-14 | Delaware | New York | 36025 | 1 | 0 |
2567 | 2567 | 2020-03-15 | Delaware | New York | 36025 | 1 | 0 |
3026 | 3026 | 2020-03-16 | Delaware | New York | 36025 | 1 | 0 |
3542 | 3542 | 2020-03-17 | Delaware | New York | 36025 | 1 | 0 |
4139 | 4139 | 2020-03-18 | Delaware | New York | 36025 | 1 | 0 |
4868 | 4868 | 2020-03-19 | Delaware | New York | 36025 | 1 | 0 |
5715 | 5715 | 2020-03-20 | Delaware | New York | 36025 | 1 | 0 |
6709 | 6709 | 2020-03-21 | Delaware | New York | 36025 | 1 | 0 |
7803 | 7803 | 2020-03-22 | Delaware | New York | 36025 | 3 | 0 |
9001 | 9001 | 2020-03-23 | Delaware | New York | 36025 | 3 | 0 |
10308 | 10308 | 2020-03-24 | Delaware | New York | 36025 | 3 | 0 |
11743 | 11743 | 2020-03-25 | Delaware | New York | 36025 | 5 | 0 |
13346 | 13346 | 2020-03-26 | Delaware | New York | 36025 | 7 | 0 |
15080 | 15080 | 2020-03-27 | Delaware | New York | 36025 | 8 | 0 |
16910 | 16910 | 2020-03-28 | Delaware | New York | 36025 | 8 | 0 |
18834 | 18834 | 2020-03-29 | Delaware | New York | 36025 | 8 | 0 |
20873 | 20873 | 2020-03-30 | Delaware | New York | 36025 | 11 | 0 |
22996 | 22996 | 2020-03-31 | Delaware | New York | 36025 | 16 | 0 |
25190 | 25190 | 2020-04-01 | Delaware | New York | 36025 | 20 | 0 |
27450 | 27450 | 2020-04-02 | Delaware | New York | 36025 | 23 | 1 |
29774 | 29774 | 2020-04-03 | Delaware | New York | 36025 | 23 | 1 |
32160 | 32160 | 2020-04-04 | Delaware | New York | 36025 | 30 | 1 |
34591 | 34591 | 2020-04-05 | Delaware | New York | 36025 | 30 | 1 |
37061 | 37061 | 2020-04-06 | Delaware | New York | 36025 | 32 | 1 |
39576 | 39576 | 2020-04-07 | Delaware | New York | 36025 | 36 | 1 |
42133 | 42133 | 2020-04-08 | Delaware | New York | 36025 | 37 | 0 |
44716 | 44716 | 2020-04-09 | Delaware | New York | 36025 | 37 | 0 |
47329 | 47329 | 2020-04-10 | Delaware | New York | 36025 | 39 | 0 |
49984 | 49984 | 2020-04-11 | Delaware | New York | 36025 | 39 | 0 |
52657 | 52657 | 2020-04-12 | Delaware | New York | 36025 | 39 | 0 |
55340 | 55340 | 2020-04-13 | Delaware | New York | 36025 | 42 | 0 |
58040 | 58040 | 2020-04-14 | Delaware | New York | 36025 | 45 | 0 |
60754 | 60754 | 2020-04-15 | Delaware | New York | 36025 | 46 | 0 |
63480 | 63480 | 2020-04-16 | Delaware | New York | 36025 | 47 | 0 |
66222 | 66222 | 2020-04-17 | Delaware | New York | 36025 | 48 | 0 |
68979 | 68979 | 2020-04-18 | Delaware | New York | 36025 | 49 | 0 |
71746 | 71746 | 2020-04-19 | Delaware | New York | 36025 | 49 | 0 |
74521 | 74521 | 2020-04-20 | Delaware | New York | 36025 | 49 | 0 |
77302 | 77302 | 2020-04-21 | Delaware | New York | 36025 | 49 | 0 |
80091 | 80091 | 2020-04-22 | Delaware | New York | 36025 | 50 | 0 |
82890 | 82890 | 2020-04-23 | Delaware | New York | 36025 | 50 | 0 |
85694 | 85694 | 2020-04-24 | Delaware | New York | 36025 | 51 | 0 |
88506 | 88506 | 2020-04-25 | Delaware | New York | 36025 | 58 | 0 |
91321 | 91321 | 2020-04-26 | Delaware | New York | 36025 | 58 | 0 |
94146 | 94146 | 2020-04-27 | Delaware | New York | 36025 | 58 | 0 |
96982 | 96982 | 2020-04-28 | Delaware | New York | 36025 | 59 | 0 |
99829 | 99829 | 2020-04-29 | Delaware | New York | 36025 | 60 | 0 |
102682 | 102682 | 2020-04-30 | Delaware | New York | 36025 | 61 | 0 |
105544 | 105544 | 2020-05-01 | Delaware | New York | 36025 | 61 | 0 |
108411 | 108411 | 2020-05-02 | Delaware | New York | 36025 | 61 | 0 |
111284 | 111284 | 2020-05-03 | Delaware | New York | 36025 | 61 | 0 |
114165 | 114165 | 2020-05-04 | Delaware | New York | 36025 | 62 | 0 |
117045 | 117045 | 2020-05-05 | Delaware | New York | 36025 | 62 | 0 |
120006 | 120006 | 2020-05-06 | Delaware | New York | 36025 | 62 | 0 |
122981 | 122981 | 2020-05-07 | Delaware | New York | 36025 | 63 | 0 |
125964 | 125964 | 2020-05-08 | Delaware | New York | 36025 | 63 | 0 |
128953 | 128953 | 2020-05-09 | Delaware | New York | 36025 | 63 | 0 |
131942 | 131942 | 2020-05-10 | Delaware | New York | 36025 | 64 | 0 |
134933 | 134933 | 2020-05-11 | Delaware | New York | 36025 | 65 | 0 |
137923 | 137923 | 2020-05-12 | Delaware | New York | 36025 | 65 | 0 |
140919 | 140919 | 2020-05-13 | Delaware | New York | 36025 | 66 | 0 |
143914 | 143914 | 2020-05-14 | Delaware | New York | 36025 | 67 | 0 |
146915 | 146915 | 2020-05-15 | Delaware | New York | 36025 | 67 | 0 |
149922 | 149922 | 2020-05-16 | Delaware | New York | 36025 | 68 | 0 |
152932 | 152932 | 2020-05-17 | Delaware | New York | 36025 | 69 | 0 |
155949 | 155949 | 2020-05-18 | Delaware | New York | 36025 | 69 | 0 |
158967 | 158967 | 2020-05-19 | Delaware | New York | 36025 | 69 | 0 |
161994 | 161994 | 2020-05-20 | Delaware | New York | 36025 | 69 | 0 |
165023 | 165023 | 2020-05-21 | Delaware | New York | 36025 | 71 | 0 |
168058 | 168058 | 2020-05-22 | Delaware | New York | 36025 | 72 | 0 |
171097 | 171097 | 2020-05-23 | Delaware | New York | 36025 | 74 | 0 |
174139 | 174139 | 2020-05-24 | Delaware | New York | 36025 | 77 | 0 |
177183 | 177183 | 2020-05-25 | Delaware | New York | 36025 | 77 | 0 |
180226 | 180226 | 2020-05-26 | Delaware | New York | 36025 | 77 | 0 |
183274 | 183274 | 2020-05-27 | Delaware | New York | 36025 | 78 | 0 |
186331 | 186331 | 2020-05-28 | Delaware | New York | 36025 | 78 | 0 |
189391 | 189391 | 2020-05-29 | Delaware | New York | 36025 | 79 | 0 |
192455 | 192455 | 2020-05-30 | Delaware | New York | 36025 | 79 | 0 |
195525 | 195525 | 2020-05-31 | Delaware | New York | 36025 | 79 | 0 |
198598 | 198598 | 2020-06-01 | Delaware | New York | 36025 | 81 | 0 |
201672 | 201672 | 2020-06-02 | Delaware | New York | 36025 | 82 | 0 |
204749 | 204749 | 2020-06-03 | Delaware | New York | 36025 | 82 | 0 |
207830 | 207830 | 2020-06-04 | Delaware | New York | 36025 | 82 | 0 |
210912 | 210912 | 2020-06-05 | Delaware | New York | 36025 | 84 | 0 |
213996 | 213996 | 2020-06-06 | Delaware | New York | 36025 | 85 | 0 |
217086 | 217086 | 2020-06-07 | Delaware | New York | 36025 | 85 | 0 |
220178 | 220178 | 2020-06-08 | Delaware | New York | 36025 | 85 | 0 |
223272 | 223272 | 2020-06-09 | Delaware | New York | 36025 | 86 | 0 |
226372 | 226372 | 2020-06-10 | Delaware | New York | 36025 | 87 | 0 |
229476 | 229476 | 2020-06-11 | Delaware | New York | 36025 | 88 | 0 |
232581 | 232581 | 2020-06-12 | Delaware | New York | 36025 | 88 | 0 |
235686 | 235686 | 2020-06-13 | Delaware | New York | 36025 | 88 | 0 |
238794 | 238794 | 2020-06-14 | Delaware | New York | 36025 | 88 | 0 |
241903 | 241903 | 2020-06-15 | Delaware | New York | 36025 | 88 | 0 |
245015 | 245015 | 2020-06-16 | Delaware | New York | 36025 | 88 | 0 |
248128 | 248128 | 2020-06-17 | Delaware | New York | 36025 | 89 | 0 |
251243 | 251243 | 2020-06-18 | Delaware | New York | 36025 | 89 | 0 |
254358 | 254358 | 2020-06-19 | Delaware | New York | 36025 | 89 | 0 |
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);