ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Delaware" and state = "Pennsylvania" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635 | 635 | 2020-03-06 | Delaware | Pennsylvania | 42045 | 1 | 0 |
726 | 726 | 2020-03-07 | Delaware | Pennsylvania | 42045 | 1 | 0 |
835 | 835 | 2020-03-08 | Delaware | Pennsylvania | 42045 | 1 | 0 |
963 | 963 | 2020-03-09 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1115 | 1115 | 2020-03-10 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1309 | 1309 | 2020-03-11 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1553 | 1553 | 2020-03-12 | Delaware | Pennsylvania | 42045 | 1 | 0 |
1851 | 1851 | 2020-03-13 | Delaware | Pennsylvania | 42045 | 6 | 0 |
2213 | 2213 | 2020-03-14 | Delaware | Pennsylvania | 42045 | 6 | 0 |
2633 | 2633 | 2020-03-15 | Delaware | Pennsylvania | 42045 | 7 | 0 |
3098 | 3098 | 2020-03-16 | Delaware | Pennsylvania | 42045 | 7 | 0 |
3628 | 3628 | 2020-03-17 | Delaware | Pennsylvania | 42045 | 9 | 0 |
4245 | 4245 | 2020-03-18 | Delaware | Pennsylvania | 42045 | 14 | 0 |
4984 | 4984 | 2020-03-19 | Delaware | Pennsylvania | 42045 | 14 | 0 |
5854 | 5854 | 2020-03-20 | Delaware | Pennsylvania | 42045 | 23 | 0 |
6857 | 6857 | 2020-03-21 | Delaware | Pennsylvania | 42045 | 33 | 0 |
7974 | 7974 | 2020-03-22 | Delaware | Pennsylvania | 42045 | 43 | 0 |
9185 | 9185 | 2020-03-23 | Delaware | Pennsylvania | 42045 | 54 | 0 |
10508 | 10508 | 2020-03-24 | Delaware | Pennsylvania | 42045 | 84 | 0 |
11970 | 11970 | 2020-03-25 | Delaware | Pennsylvania | 42045 | 101 | 0 |
13590 | 13590 | 2020-03-26 | Delaware | Pennsylvania | 42045 | 156 | 1 |
15336 | 15336 | 2020-03-27 | Delaware | Pennsylvania | 42045 | 185 | 3 |
17185 | 17185 | 2020-03-28 | Delaware | Pennsylvania | 42045 | 226 | 4 |
19123 | 19123 | 2020-03-29 | Delaware | Pennsylvania | 42045 | 276 | 4 |
21173 | 21173 | 2020-03-30 | Delaware | Pennsylvania | 42045 | 303 | 4 |
23309 | 23309 | 2020-03-31 | Delaware | Pennsylvania | 42045 | 338 | 6 |
25507 | 25507 | 2020-04-01 | Delaware | Pennsylvania | 42045 | 390 | 7 |
27779 | 27779 | 2020-04-02 | Delaware | Pennsylvania | 42045 | 470 | 8 |
30113 | 30113 | 2020-04-03 | Delaware | Pennsylvania | 42045 | 542 | 10 |
32503 | 32503 | 2020-04-04 | Delaware | Pennsylvania | 42045 | 616 | 13 |
34938 | 34938 | 2020-04-05 | Delaware | Pennsylvania | 42045 | 708 | 14 |
37413 | 37413 | 2020-04-06 | Delaware | Pennsylvania | 42045 | 822 | 15 |
39934 | 39934 | 2020-04-07 | Delaware | Pennsylvania | 42045 | 898 | 20 |
42494 | 42494 | 2020-04-08 | Delaware | Pennsylvania | 42045 | 1034 | 23 |
45080 | 45080 | 2020-04-09 | Delaware | Pennsylvania | 42045 | 1222 | 26 |
47697 | 47697 | 2020-04-10 | Delaware | Pennsylvania | 42045 | 1377 | 30 |
50354 | 50354 | 2020-04-11 | Delaware | Pennsylvania | 42045 | 1510 | 39 |
53027 | 53027 | 2020-04-12 | Delaware | Pennsylvania | 42045 | 1594 | 39 |
55712 | 55712 | 2020-04-13 | Delaware | Pennsylvania | 42045 | 1712 | 40 |
58415 | 58415 | 2020-04-14 | Delaware | Pennsylvania | 42045 | 1851 | 46 |
61130 | 61130 | 2020-04-15 | Delaware | Pennsylvania | 42045 | 1935 | 60 |
63856 | 63856 | 2020-04-16 | Delaware | Pennsylvania | 42045 | 2055 | 71 |
66602 | 66602 | 2020-04-17 | Delaware | Pennsylvania | 42045 | 2281 | 74 |
69360 | 69360 | 2020-04-18 | Delaware | Pennsylvania | 42045 | 2372 | 78 |
72127 | 72127 | 2020-04-19 | Delaware | Pennsylvania | 42045 | 2460 | 91 |
74902 | 74902 | 2020-04-20 | Delaware | Pennsylvania | 42045 | 2545 | 100 |
77684 | 77684 | 2020-04-21 | Delaware | Pennsylvania | 42045 | 2698 | 118 |
80474 | 80474 | 2020-04-22 | Delaware | Pennsylvania | 42045 | 2798 | 124 |
83273 | 83273 | 2020-04-23 | Delaware | Pennsylvania | 42045 | 2963 | 124 |
86077 | 86077 | 2020-04-24 | Delaware | Pennsylvania | 42045 | 3106 | 131 |
88891 | 88891 | 2020-04-25 | Delaware | Pennsylvania | 42045 | 3213 | 142 |
91707 | 91707 | 2020-04-26 | Delaware | Pennsylvania | 42045 | 3333 | 143 |
94534 | 94534 | 2020-04-27 | Delaware | Pennsylvania | 42045 | 3405 | 145 |
97373 | 97373 | 2020-04-28 | Delaware | Pennsylvania | 42045 | 3514 | 164 |
100222 | 100222 | 2020-04-29 | Delaware | Pennsylvania | 42045 | 3672 | 224 |
103075 | 103075 | 2020-04-30 | Delaware | Pennsylvania | 42045 | 3747 | 235 |
105938 | 105938 | 2020-05-01 | Delaware | Pennsylvania | 42045 | 3895 | 240 |
108805 | 108805 | 2020-05-02 | Delaware | Pennsylvania | 42045 | 4053 | 255 |
111679 | 111679 | 2020-05-03 | Delaware | Pennsylvania | 42045 | 4173 | 255 |
114561 | 114561 | 2020-05-04 | Delaware | Pennsylvania | 42045 | 4256 | 258 |
117442 | 117442 | 2020-05-05 | Delaware | Pennsylvania | 42045 | 4326 | 320 |
120404 | 120404 | 2020-05-06 | Delaware | Pennsylvania | 42045 | 4430 | 326 |
123381 | 123381 | 2020-05-07 | Delaware | Pennsylvania | 42045 | 4554 | 376 |
126364 | 126364 | 2020-05-08 | Delaware | Pennsylvania | 42045 | 4739 | 382 |
129353 | 129353 | 2020-05-09 | Delaware | Pennsylvania | 42045 | 4894 | 394 |
132342 | 132342 | 2020-05-10 | Delaware | Pennsylvania | 42045 | 5032 | 395 |
135333 | 135333 | 2020-05-11 | Delaware | Pennsylvania | 42045 | 5101 | 399 |
138323 | 138323 | 2020-05-12 | Delaware | Pennsylvania | 42045 | 5136 | 405 |
141319 | 141319 | 2020-05-13 | Delaware | Pennsylvania | 42045 | 5208 | 419 |
144315 | 144315 | 2020-05-14 | Delaware | Pennsylvania | 42045 | 5305 | 448 |
147316 | 147316 | 2020-05-15 | Delaware | Pennsylvania | 42045 | 5409 | 466 |
150323 | 150323 | 2020-05-16 | Delaware | Pennsylvania | 42045 | 5555 | 478 |
153334 | 153334 | 2020-05-17 | Delaware | Pennsylvania | 42045 | 5619 | 478 |
156351 | 156351 | 2020-05-18 | Delaware | Pennsylvania | 42045 | 5689 | 478 |
159372 | 159372 | 2020-05-19 | Delaware | Pennsylvania | 42045 | 5807 | 491 |
162399 | 162399 | 2020-05-20 | Delaware | Pennsylvania | 42045 | 5844 | 491 |
165428 | 165428 | 2020-05-21 | Delaware | Pennsylvania | 42045 | 5969 | 491 |
168464 | 168464 | 2020-05-22 | Delaware | Pennsylvania | 42045 | 6112 | 518 |
171503 | 171503 | 2020-05-23 | Delaware | Pennsylvania | 42045 | 6168 | 521 |
174545 | 174545 | 2020-05-24 | Delaware | Pennsylvania | 42045 | 6234 | 521 |
177589 | 177589 | 2020-05-25 | Delaware | Pennsylvania | 42045 | 6234 | 524 |
180632 | 180632 | 2020-05-26 | Delaware | Pennsylvania | 42045 | 6295 | 524 |
183682 | 183682 | 2020-05-27 | Delaware | Pennsylvania | 42045 | 6341 | 536 |
186739 | 186739 | 2020-05-28 | Delaware | Pennsylvania | 42045 | 6389 | 544 |
189800 | 189800 | 2020-05-29 | Delaware | Pennsylvania | 42045 | 6428 | 550 |
192865 | 192865 | 2020-05-30 | Delaware | Pennsylvania | 42045 | 6473 | 558 |
195934 | 195934 | 2020-05-31 | Delaware | Pennsylvania | 42045 | 6510 | 558 |
199007 | 199007 | 2020-06-01 | Delaware | Pennsylvania | 42045 | 6529 | 559 |
202082 | 202082 | 2020-06-02 | Delaware | Pennsylvania | 42045 | 6545 | 567 |
205159 | 205159 | 2020-06-03 | Delaware | Pennsylvania | 42045 | 6600 | 576 |
208240 | 208240 | 2020-06-04 | Delaware | Pennsylvania | 42045 | 6639 | 614 |
211322 | 211322 | 2020-06-05 | Delaware | Pennsylvania | 42045 | 6661 | 645 |
214408 | 214408 | 2020-06-06 | Delaware | Pennsylvania | 42045 | 6661 | 651 |
217498 | 217498 | 2020-06-07 | Delaware | Pennsylvania | 42045 | 6743 | 651 |
220590 | 220590 | 2020-06-08 | Delaware | Pennsylvania | 42045 | 6754 | 651 |
223685 | 223685 | 2020-06-09 | Delaware | Pennsylvania | 42045 | 6789 | 652 |
226785 | 226785 | 2020-06-10 | Delaware | Pennsylvania | 42045 | 6811 | 662 |
229889 | 229889 | 2020-06-11 | Delaware | Pennsylvania | 42045 | 6863 | 662 |
232994 | 232994 | 2020-06-12 | Delaware | Pennsylvania | 42045 | 6894 | 664 |
236099 | 236099 | 2020-06-13 | Delaware | Pennsylvania | 42045 | 6894 | 664 |
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);