ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Beaver" and state = "Pennsylvania" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
3624 | 3624 | 2020-03-17 | Beaver | Pennsylvania | 42007 | 1 | 0 |
4240 | 4240 | 2020-03-18 | Beaver | Pennsylvania | 42007 | 2 | 0 |
4979 | 4979 | 2020-03-19 | Beaver | Pennsylvania | 42007 | 2 | 0 |
5848 | 5848 | 2020-03-20 | Beaver | Pennsylvania | 42007 | 3 | 0 |
6850 | 6850 | 2020-03-21 | Beaver | Pennsylvania | 42007 | 3 | 0 |
7965 | 7965 | 2020-03-22 | Beaver | Pennsylvania | 42007 | 3 | 0 |
9175 | 9175 | 2020-03-23 | Beaver | Pennsylvania | 42007 | 3 | 0 |
10495 | 10495 | 2020-03-24 | Beaver | Pennsylvania | 42007 | 3 | 0 |
11957 | 11957 | 2020-03-25 | Beaver | Pennsylvania | 42007 | 7 | 0 |
13575 | 13575 | 2020-03-26 | Beaver | Pennsylvania | 42007 | 13 | 0 |
15321 | 15321 | 2020-03-27 | Beaver | Pennsylvania | 42007 | 14 | 0 |
17168 | 17168 | 2020-03-28 | Beaver | Pennsylvania | 42007 | 22 | 0 |
19106 | 19106 | 2020-03-29 | Beaver | Pennsylvania | 42007 | 28 | 0 |
21156 | 21156 | 2020-03-30 | Beaver | Pennsylvania | 42007 | 44 | 0 |
23291 | 23291 | 2020-03-31 | Beaver | Pennsylvania | 42007 | 52 | 1 |
25489 | 25489 | 2020-04-01 | Beaver | Pennsylvania | 42007 | 54 | 2 |
27761 | 27761 | 2020-04-02 | Beaver | Pennsylvania | 42007 | 55 | 2 |
30094 | 30094 | 2020-04-03 | Beaver | Pennsylvania | 42007 | 65 | 2 |
32484 | 32484 | 2020-04-04 | Beaver | Pennsylvania | 42007 | 69 | 6 |
34919 | 34919 | 2020-04-05 | Beaver | Pennsylvania | 42007 | 84 | 6 |
37394 | 37394 | 2020-04-06 | Beaver | Pennsylvania | 42007 | 96 | 6 |
39915 | 39915 | 2020-04-07 | Beaver | Pennsylvania | 42007 | 116 | 9 |
42475 | 42475 | 2020-04-08 | Beaver | Pennsylvania | 42007 | 128 | 13 |
45061 | 45061 | 2020-04-09 | Beaver | Pennsylvania | 42007 | 129 | 13 |
47678 | 47678 | 2020-04-10 | Beaver | Pennsylvania | 42007 | 139 | 13 |
50335 | 50335 | 2020-04-11 | Beaver | Pennsylvania | 42007 | 143 | 13 |
53008 | 53008 | 2020-04-12 | Beaver | Pennsylvania | 42007 | 145 | 13 |
55693 | 55693 | 2020-04-13 | Beaver | Pennsylvania | 42007 | 153 | 13 |
58396 | 58396 | 2020-04-14 | Beaver | Pennsylvania | 42007 | 156 | 14 |
61111 | 61111 | 2020-04-15 | Beaver | Pennsylvania | 42007 | 158 | 14 |
63837 | 63837 | 2020-04-16 | Beaver | Pennsylvania | 42007 | 168 | 14 |
66583 | 66583 | 2020-04-17 | Beaver | Pennsylvania | 42007 | 178 | 15 |
69341 | 69341 | 2020-04-18 | Beaver | Pennsylvania | 42007 | 278 | 31 |
72108 | 72108 | 2020-04-19 | Beaver | Pennsylvania | 42007 | 288 | 32 |
74883 | 74883 | 2020-04-20 | Beaver | Pennsylvania | 42007 | 298 | 36 |
77665 | 77665 | 2020-04-21 | Beaver | Pennsylvania | 42007 | 303 | 43 |
80455 | 80455 | 2020-04-22 | Beaver | Pennsylvania | 42007 | 317 | 47 |
83254 | 83254 | 2020-04-23 | Beaver | Pennsylvania | 42007 | 319 | 46 |
86058 | 86058 | 2020-04-24 | Beaver | Pennsylvania | 42007 | 337 | 46 |
88872 | 88872 | 2020-04-25 | Beaver | Pennsylvania | 42007 | 359 | 46 |
91688 | 91688 | 2020-04-26 | Beaver | Pennsylvania | 42007 | 366 | 46 |
94515 | 94515 | 2020-04-27 | Beaver | Pennsylvania | 42007 | 387 | 46 |
97354 | 97354 | 2020-04-28 | Beaver | Pennsylvania | 42007 | 388 | 59 |
100203 | 100203 | 2020-04-29 | Beaver | Pennsylvania | 42007 | 392 | 65 |
103056 | 103056 | 2020-04-30 | Beaver | Pennsylvania | 42007 | 405 | 65 |
105919 | 105919 | 2020-05-01 | Beaver | Pennsylvania | 42007 | 426 | 67 |
108786 | 108786 | 2020-05-02 | Beaver | Pennsylvania | 42007 | 435 | 68 |
111660 | 111660 | 2020-05-03 | Beaver | Pennsylvania | 42007 | 435 | 68 |
114542 | 114542 | 2020-05-04 | Beaver | Pennsylvania | 42007 | 458 | 68 |
117423 | 117423 | 2020-05-05 | Beaver | Pennsylvania | 42007 | 466 | 73 |
120385 | 120385 | 2020-05-06 | Beaver | Pennsylvania | 42007 | 471 | 76 |
123362 | 123362 | 2020-05-07 | Beaver | Pennsylvania | 42007 | 472 | 78 |
126345 | 126345 | 2020-05-08 | Beaver | Pennsylvania | 42007 | 479 | 78 |
129334 | 129334 | 2020-05-09 | Beaver | Pennsylvania | 42007 | 482 | 78 |
132323 | 132323 | 2020-05-10 | Beaver | Pennsylvania | 42007 | 491 | 78 |
135314 | 135314 | 2020-05-11 | Beaver | Pennsylvania | 42007 | 491 | 78 |
138304 | 138304 | 2020-05-12 | Beaver | Pennsylvania | 42007 | 493 | 78 |
141300 | 141300 | 2020-05-13 | Beaver | Pennsylvania | 42007 | 509 | 78 |
144296 | 144296 | 2020-05-14 | Beaver | Pennsylvania | 42007 | 512 | 82 |
147297 | 147297 | 2020-05-15 | Beaver | Pennsylvania | 42007 | 516 | 83 |
150304 | 150304 | 2020-05-16 | Beaver | Pennsylvania | 42007 | 518 | 83 |
153315 | 153315 | 2020-05-17 | Beaver | Pennsylvania | 42007 | 517 | 83 |
156332 | 156332 | 2020-05-18 | Beaver | Pennsylvania | 42007 | 533 | 70 |
159353 | 159353 | 2020-05-19 | Beaver | Pennsylvania | 42007 | 534 | 70 |
162380 | 162380 | 2020-05-20 | Beaver | Pennsylvania | 42007 | 539 | 70 |
165409 | 165409 | 2020-05-21 | Beaver | Pennsylvania | 42007 | 539 | 71 |
168445 | 168445 | 2020-05-22 | Beaver | Pennsylvania | 42007 | 550 | 71 |
171484 | 171484 | 2020-05-23 | Beaver | Pennsylvania | 42007 | 552 | 72 |
174526 | 174526 | 2020-05-24 | Beaver | Pennsylvania | 42007 | 554 | 72 |
177570 | 177570 | 2020-05-25 | Beaver | Pennsylvania | 42007 | 568 | 72 |
180613 | 180613 | 2020-05-26 | Beaver | Pennsylvania | 42007 | 570 | 72 |
183663 | 183663 | 2020-05-27 | Beaver | Pennsylvania | 42007 | 570 | 72 |
186720 | 186720 | 2020-05-28 | Beaver | Pennsylvania | 42007 | 579 | 72 |
189781 | 189781 | 2020-05-29 | Beaver | Pennsylvania | 42007 | 582 | 73 |
192846 | 192846 | 2020-05-30 | Beaver | Pennsylvania | 42007 | 589 | 73 |
195915 | 195915 | 2020-05-31 | Beaver | Pennsylvania | 42007 | 590 | 73 |
198988 | 198988 | 2020-06-01 | Beaver | Pennsylvania | 42007 | 590 | 73 |
202063 | 202063 | 2020-06-02 | Beaver | Pennsylvania | 42007 | 591 | 74 |
205140 | 205140 | 2020-06-03 | Beaver | Pennsylvania | 42007 | 594 | 74 |
208221 | 208221 | 2020-06-04 | Beaver | Pennsylvania | 42007 | 599 | 74 |
211303 | 211303 | 2020-06-05 | Beaver | Pennsylvania | 42007 | 598 | 74 |
214389 | 214389 | 2020-06-06 | Beaver | Pennsylvania | 42007 | 598 | 74 |
217479 | 217479 | 2020-06-07 | Beaver | Pennsylvania | 42007 | 603 | 74 |
220571 | 220571 | 2020-06-08 | Beaver | Pennsylvania | 42007 | 603 | 74 |
223666 | 223666 | 2020-06-09 | Beaver | Pennsylvania | 42007 | 608 | 74 |
226766 | 226766 | 2020-06-10 | Beaver | Pennsylvania | 42007 | 610 | 74 |
229870 | 229870 | 2020-06-11 | Beaver | Pennsylvania | 42007 | 610 | 75 |
232975 | 232975 | 2020-06-12 | Beaver | Pennsylvania | 42007 | 611 | 75 |
236080 | 236080 | 2020-06-13 | Beaver | Pennsylvania | 42007 | 611 | 75 |
239188 | 239188 | 2020-06-14 | Beaver | Pennsylvania | 42007 | 611 | 75 |
242297 | 242297 | 2020-06-15 | Beaver | Pennsylvania | 42007 | 613 | 77 |
245409 | 245409 | 2020-06-16 | Beaver | Pennsylvania | 42007 | 613 | 77 |
248522 | 248522 | 2020-06-17 | Beaver | Pennsylvania | 42007 | 615 | 77 |
251637 | 251637 | 2020-06-18 | Beaver | Pennsylvania | 42007 | 616 | 77 |
254752 | 254752 | 2020-06-19 | Beaver | Pennsylvania | 42007 | 619 | 77 |
257878 | 257878 | 2020-06-20 | Beaver | Pennsylvania | 42007 | 621 | 77 |
261005 | 261005 | 2020-06-21 | Beaver | Pennsylvania | 42007 | 624 | 77 |
264133 | 264133 | 2020-06-22 | Beaver | Pennsylvania | 42007 | 625 | 77 |
267261 | 267261 | 2020-06-23 | Beaver | Pennsylvania | 42007 | 630 | 78 |
270395 | 270395 | 2020-06-24 | Beaver | Pennsylvania | 42007 | 634 | 78 |
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);