ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Orange" and state = "New York" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1523 | 1523 | 2020-03-12 | Orange | New York | 36071 | 1 | 0 |
1816 | 1816 | 2020-03-13 | Orange | New York | 36071 | 3 | 0 |
2165 | 2165 | 2020-03-14 | Orange | New York | 36071 | 6 | 0 |
2576 | 2576 | 2020-03-15 | Orange | New York | 36071 | 6 | 0 |
3037 | 3037 | 2020-03-16 | Orange | New York | 36071 | 11 | 0 |
3553 | 3553 | 2020-03-17 | Orange | New York | 36071 | 15 | 0 |
4154 | 4154 | 2020-03-18 | Orange | New York | 36071 | 32 | 0 |
4883 | 4883 | 2020-03-19 | Orange | New York | 36071 | 51 | 0 |
5734 | 5734 | 2020-03-20 | Orange | New York | 36071 | 84 | 0 |
6728 | 6728 | 2020-03-21 | Orange | New York | 36071 | 163 | 0 |
7823 | 7823 | 2020-03-22 | Orange | New York | 36071 | 247 | 0 |
9021 | 9021 | 2020-03-23 | Orange | New York | 36071 | 389 | 0 |
10328 | 10328 | 2020-03-24 | Orange | New York | 36071 | 498 | 0 |
11764 | 11764 | 2020-03-25 | Orange | New York | 36071 | 638 | 0 |
13367 | 13367 | 2020-03-26 | Orange | New York | 36071 | 751 | 2 |
15101 | 15101 | 2020-03-27 | Orange | New York | 36071 | 910 | 3 |
16931 | 16931 | 2020-03-28 | Orange | New York | 36071 | 1101 | 3 |
18856 | 18856 | 2020-03-29 | Orange | New York | 36071 | 1247 | 3 |
20895 | 20895 | 2020-03-30 | Orange | New York | 36071 | 1435 | 3 |
23018 | 23018 | 2020-03-31 | Orange | New York | 36071 | 1560 | 3 |
25212 | 25212 | 2020-04-01 | Orange | New York | 36071 | 1756 | 25 |
27472 | 27472 | 2020-04-02 | Orange | New York | 36071 | 2048 | 30 |
29796 | 29796 | 2020-04-03 | Orange | New York | 36071 | 2397 | 30 |
32182 | 32182 | 2020-04-04 | Orange | New York | 36071 | 2741 | 51 |
34613 | 34613 | 2020-04-05 | Orange | New York | 36071 | 3102 | 51 |
37083 | 37083 | 2020-04-06 | Orange | New York | 36071 | 3397 | 47 |
39598 | 39598 | 2020-04-07 | Orange | New York | 36071 | 3599 | 76 |
42155 | 42155 | 2020-04-08 | Orange | New York | 36071 | 3865 | 68 |
44738 | 44738 | 2020-04-09 | Orange | New York | 36071 | 4090 | 79 |
47351 | 47351 | 2020-04-10 | Orange | New York | 36071 | 4532 | 91 |
50006 | 50006 | 2020-04-11 | Orange | New York | 36071 | 4847 | 99 |
52679 | 52679 | 2020-04-12 | Orange | New York | 36071 | 5027 | 112 |
55362 | 55362 | 2020-04-13 | Orange | New York | 36071 | 5182 | 122 |
58062 | 58062 | 2020-04-14 | Orange | New York | 36071 | 5578 | 129 |
60776 | 60776 | 2020-04-15 | Orange | New York | 36071 | 5716 | 135 |
63502 | 63502 | 2020-04-16 | Orange | New York | 36071 | 5888 | 144 |
66244 | 66244 | 2020-04-17 | Orange | New York | 36071 | 6084 | 144 |
69001 | 69001 | 2020-04-18 | Orange | New York | 36071 | 6281 | 144 |
71768 | 71768 | 2020-04-19 | Orange | New York | 36071 | 6394 | 165 |
74543 | 74543 | 2020-04-20 | Orange | New York | 36071 | 6497 | 169 |
77324 | 77324 | 2020-04-21 | Orange | New York | 36071 | 6576 | 181 |
80113 | 80113 | 2020-04-22 | Orange | New York | 36071 | 6705 | 183 |
82912 | 82912 | 2020-04-23 | Orange | New York | 36071 | 6816 | 190 |
85716 | 85716 | 2020-04-24 | Orange | New York | 36071 | 7170 | 194 |
88528 | 88528 | 2020-04-25 | Orange | New York | 36071 | 7988 | 200 |
91343 | 91343 | 2020-04-26 | Orange | New York | 36071 | 8121 | 203 |
94168 | 94168 | 2020-04-27 | Orange | New York | 36071 | 8253 | 213 |
97004 | 97004 | 2020-04-28 | Orange | New York | 36071 | 8389 | 223 |
99851 | 99851 | 2020-04-29 | Orange | New York | 36071 | 8503 | 232 |
102704 | 102704 | 2020-04-30 | Orange | New York | 36071 | 8665 | 237 |
105566 | 105566 | 2020-05-01 | Orange | New York | 36071 | 8766 | 243 |
108433 | 108433 | 2020-05-02 | Orange | New York | 36071 | 8925 | 247 |
111306 | 111306 | 2020-05-03 | Orange | New York | 36071 | 8982 | 250 |
114187 | 114187 | 2020-05-04 | Orange | New York | 36071 | 9030 | 254 |
117067 | 117067 | 2020-05-05 | Orange | New York | 36071 | 9159 | 256 |
120028 | 120028 | 2020-05-06 | Orange | New York | 36071 | 9215 | 298 |
123003 | 123003 | 2020-05-07 | Orange | New York | 36071 | 9343 | 302 |
125986 | 125986 | 2020-05-08 | Orange | New York | 36071 | 9417 | 307 |
128975 | 128975 | 2020-05-09 | Orange | New York | 36071 | 9501 | 311 |
131964 | 131964 | 2020-05-10 | Orange | New York | 36071 | 9558 | 315 |
134955 | 134955 | 2020-05-11 | Orange | New York | 36071 | 9599 | 318 |
137945 | 137945 | 2020-05-12 | Orange | New York | 36071 | 9647 | 324 |
140941 | 140941 | 2020-05-13 | Orange | New York | 36071 | 9708 | 331 |
143936 | 143936 | 2020-05-14 | Orange | New York | 36071 | 9786 | 333 |
146937 | 146937 | 2020-05-15 | Orange | New York | 36071 | 9840 | 335 |
149944 | 149944 | 2020-05-16 | Orange | New York | 36071 | 9894 | 342 |
152954 | 152954 | 2020-05-17 | Orange | New York | 36071 | 9958 | 347 |
155971 | 155971 | 2020-05-18 | Orange | New York | 36071 | 9980 | 350 |
158989 | 158989 | 2020-05-19 | Orange | New York | 36071 | 10003 | 352 |
162016 | 162016 | 2020-05-20 | Orange | New York | 36071 | 10058 | 358 |
165045 | 165045 | 2020-05-21 | Orange | New York | 36071 | 10107 | 359 |
168080 | 168080 | 2020-05-22 | Orange | New York | 36071 | 10157 | 359 |
171119 | 171119 | 2020-05-23 | Orange | New York | 36071 | 10212 | 359 |
174161 | 174161 | 2020-05-24 | Orange | New York | 36071 | 10240 | 361 |
177205 | 177205 | 2020-05-25 | Orange | New York | 36071 | 10259 | 364 |
180248 | 180248 | 2020-05-26 | Orange | New York | 36071 | 10292 | 369 |
183296 | 183296 | 2020-05-27 | Orange | New York | 36071 | 10307 | 370 |
186353 | 186353 | 2020-05-28 | Orange | New York | 36071 | 10340 | 374 |
189413 | 189413 | 2020-05-29 | Orange | New York | 36071 | 10376 | 374 |
192477 | 192477 | 2020-05-30 | Orange | New York | 36071 | 10404 | 374 |
195547 | 195547 | 2020-05-31 | Orange | New York | 36071 | 10421 | 375 |
198620 | 198620 | 2020-06-01 | Orange | New York | 36071 | 10437 | 376 |
201694 | 201694 | 2020-06-02 | Orange | New York | 36071 | 10464 | 378 |
204771 | 204771 | 2020-06-03 | Orange | New York | 36071 | 10475 | 379 |
207852 | 207852 | 2020-06-04 | Orange | New York | 36071 | 10486 | 381 |
210934 | 210934 | 2020-06-05 | Orange | New York | 36071 | 10499 | 383 |
214018 | 214018 | 2020-06-06 | Orange | New York | 36071 | 10523 | 384 |
217108 | 217108 | 2020-06-07 | Orange | New York | 36071 | 10529 | 386 |
220200 | 220200 | 2020-06-08 | Orange | New York | 36071 | 10538 | 386 |
223294 | 223294 | 2020-06-09 | Orange | New York | 36071 | 10548 | 387 |
226394 | 226394 | 2020-06-10 | Orange | New York | 36071 | 10556 | 388 |
229498 | 229498 | 2020-06-11 | Orange | New York | 36071 | 10565 | 389 |
232603 | 232603 | 2020-06-12 | Orange | New York | 36071 | 10573 | 391 |
235708 | 235708 | 2020-06-13 | Orange | New York | 36071 | 10578 | 391 |
238816 | 238816 | 2020-06-14 | Orange | New York | 36071 | 10586 | 391 |
241925 | 241925 | 2020-06-15 | Orange | New York | 36071 | 10588 | 391 |
245037 | 245037 | 2020-06-16 | Orange | New York | 36071 | 10595 | 392 |
248150 | 248150 | 2020-06-17 | Orange | New York | 36071 | 10614 | 392 |
251265 | 251265 | 2020-06-18 | Orange | New York | 36071 | 10619 | 394 |
254380 | 254380 | 2020-06-19 | Orange | New York | 36071 | 10635 | 395 |
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);