ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 42079 and state = "Pennsylvania" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2635 | 2635 | 2020-03-15 | Luzerne | Pennsylvania | 42079 | 1 | 0 |
3100 | 3100 | 2020-03-16 | Luzerne | Pennsylvania | 42079 | 1 | 0 |
3630 | 3630 | 2020-03-17 | Luzerne | Pennsylvania | 42079 | 1 | 0 |
4248 | 4248 | 2020-03-18 | Luzerne | Pennsylvania | 42079 | 1 | 0 |
4989 | 4989 | 2020-03-19 | Luzerne | Pennsylvania | 42079 | 1 | 0 |
5861 | 5861 | 2020-03-20 | Luzerne | Pennsylvania | 42079 | 2 | 0 |
6864 | 6864 | 2020-03-21 | Luzerne | Pennsylvania | 42079 | 6 | 0 |
7982 | 7982 | 2020-03-22 | Luzerne | Pennsylvania | 42079 | 7 | 0 |
9193 | 9193 | 2020-03-23 | Luzerne | Pennsylvania | 42079 | 10 | 0 |
10517 | 10517 | 2020-03-24 | Luzerne | Pennsylvania | 42079 | 21 | 0 |
11981 | 11981 | 2020-03-25 | Luzerne | Pennsylvania | 42079 | 27 | 1 |
13602 | 13602 | 2020-03-26 | Luzerne | Pennsylvania | 42079 | 36 | 1 |
15348 | 15348 | 2020-03-27 | Luzerne | Pennsylvania | 42079 | 55 | 2 |
17198 | 17198 | 2020-03-28 | Luzerne | Pennsylvania | 42079 | 65 | 2 |
19136 | 19136 | 2020-03-29 | Luzerne | Pennsylvania | 42079 | 94 | 2 |
21186 | 21186 | 2020-03-30 | Luzerne | Pennsylvania | 42079 | 150 | 3 |
23322 | 23322 | 2020-03-31 | Luzerne | Pennsylvania | 42079 | 212 | 4 |
25520 | 25520 | 2020-04-01 | Luzerne | Pennsylvania | 42079 | 282 | 4 |
27793 | 27793 | 2020-04-02 | Luzerne | Pennsylvania | 42079 | 384 | 5 |
30127 | 30127 | 2020-04-03 | Luzerne | Pennsylvania | 42079 | 484 | 5 |
32517 | 32517 | 2020-04-04 | Luzerne | Pennsylvania | 42079 | 648 | 5 |
34953 | 34953 | 2020-04-05 | Luzerne | Pennsylvania | 42079 | 741 | 5 |
37428 | 37428 | 2020-04-06 | Luzerne | Pennsylvania | 42079 | 849 | 5 |
39951 | 39951 | 2020-04-07 | Luzerne | Pennsylvania | 42079 | 982 | 8 |
42511 | 42511 | 2020-04-08 | Luzerne | Pennsylvania | 42079 | 1134 | 11 |
45097 | 45097 | 2020-04-09 | Luzerne | Pennsylvania | 42079 | 1241 | 12 |
47714 | 47714 | 2020-04-10 | Luzerne | Pennsylvania | 42079 | 1325 | 15 |
50371 | 50371 | 2020-04-11 | Luzerne | Pennsylvania | 42079 | 1372 | 17 |
53044 | 53044 | 2020-04-12 | Luzerne | Pennsylvania | 42079 | 1411 | 17 |
55729 | 55729 | 2020-04-13 | Luzerne | Pennsylvania | 42079 | 1446 | 21 |
58432 | 58432 | 2020-04-14 | Luzerne | Pennsylvania | 42079 | 1523 | 26 |
61147 | 61147 | 2020-04-15 | Luzerne | Pennsylvania | 42079 | 1567 | 27 |
63873 | 63873 | 2020-04-16 | Luzerne | Pennsylvania | 42079 | 1611 | 28 |
66619 | 66619 | 2020-04-17 | Luzerne | Pennsylvania | 42079 | 1668 | 31 |
69377 | 69377 | 2020-04-18 | Luzerne | Pennsylvania | 42079 | 1712 | 32 |
72144 | 72144 | 2020-04-19 | Luzerne | Pennsylvania | 42079 | 1741 | 34 |
74919 | 74919 | 2020-04-20 | Luzerne | Pennsylvania | 42079 | 1767 | 36 |
77701 | 77701 | 2020-04-21 | Luzerne | Pennsylvania | 42079 | 1800 | 50 |
80491 | 80491 | 2020-04-22 | Luzerne | Pennsylvania | 42079 | 1848 | 60 |
83290 | 83290 | 2020-04-23 | Luzerne | Pennsylvania | 42079 | 1880 | 58 |
86094 | 86094 | 2020-04-24 | Luzerne | Pennsylvania | 42079 | 1921 | 62 |
88908 | 88908 | 2020-04-25 | Luzerne | Pennsylvania | 42079 | 1962 | 66 |
91724 | 91724 | 2020-04-26 | Luzerne | Pennsylvania | 42079 | 2008 | 67 |
94551 | 94551 | 2020-04-27 | Luzerne | Pennsylvania | 42079 | 2035 | 71 |
97390 | 97390 | 2020-04-28 | Luzerne | Pennsylvania | 42079 | 2078 | 74 |
100239 | 100239 | 2020-04-29 | Luzerne | Pennsylvania | 42079 | 2111 | 82 |
103092 | 103092 | 2020-04-30 | Luzerne | Pennsylvania | 42079 | 2143 | 88 |
105955 | 105955 | 2020-05-01 | Luzerne | Pennsylvania | 42079 | 2173 | 92 |
108822 | 108822 | 2020-05-02 | Luzerne | Pennsylvania | 42079 | 2211 | 97 |
111696 | 111696 | 2020-05-03 | Luzerne | Pennsylvania | 42079 | 2240 | 97 |
114578 | 114578 | 2020-05-04 | Luzerne | Pennsylvania | 42079 | 2255 | 101 |
117459 | 117459 | 2020-05-05 | Luzerne | Pennsylvania | 42079 | 2280 | 104 |
120421 | 120421 | 2020-05-06 | Luzerne | Pennsylvania | 42079 | 2306 | 107 |
123398 | 123398 | 2020-05-07 | Luzerne | Pennsylvania | 42079 | 2332 | 114 |
126381 | 126381 | 2020-05-08 | Luzerne | Pennsylvania | 42079 | 2347 | 120 |
129370 | 129370 | 2020-05-09 | Luzerne | Pennsylvania | 42079 | 2356 | 111 |
132359 | 132359 | 2020-05-10 | Luzerne | Pennsylvania | 42079 | 2416 | 111 |
135350 | 135350 | 2020-05-11 | Luzerne | Pennsylvania | 42079 | 2426 | 112 |
138340 | 138340 | 2020-05-12 | Luzerne | Pennsylvania | 42079 | 2449 | 120 |
141336 | 141336 | 2020-05-13 | Luzerne | Pennsylvania | 42079 | 2467 | 123 |
144332 | 144332 | 2020-05-14 | Luzerne | Pennsylvania | 42079 | 2477 | 124 |
147333 | 147333 | 2020-05-15 | Luzerne | Pennsylvania | 42079 | 2491 | 127 |
150340 | 150340 | 2020-05-16 | Luzerne | Pennsylvania | 42079 | 2513 | 127 |
153351 | 153351 | 2020-05-17 | Luzerne | Pennsylvania | 42079 | 2526 | 127 |
156368 | 156368 | 2020-05-18 | Luzerne | Pennsylvania | 42079 | 2532 | 122 |
159389 | 159389 | 2020-05-19 | Luzerne | Pennsylvania | 42079 | 2554 | 124 |
162416 | 162416 | 2020-05-20 | Luzerne | Pennsylvania | 42079 | 2572 | 128 |
165445 | 165445 | 2020-05-21 | Luzerne | Pennsylvania | 42079 | 2594 | 130 |
168481 | 168481 | 2020-05-22 | Luzerne | Pennsylvania | 42079 | 2620 | 133 |
171520 | 171520 | 2020-05-23 | Luzerne | Pennsylvania | 42079 | 2631 | 135 |
174562 | 174562 | 2020-05-24 | Luzerne | Pennsylvania | 42079 | 2645 | 135 |
177606 | 177606 | 2020-05-25 | Luzerne | Pennsylvania | 42079 | 2651 | 135 |
180649 | 180649 | 2020-05-26 | Luzerne | Pennsylvania | 42079 | 2662 | 135 |
183699 | 183699 | 2020-05-27 | Luzerne | Pennsylvania | 42079 | 2677 | 138 |
186756 | 186756 | 2020-05-28 | Luzerne | Pennsylvania | 42079 | 2689 | 139 |
189817 | 189817 | 2020-05-29 | Luzerne | Pennsylvania | 42079 | 2711 | 144 |
192882 | 192882 | 2020-05-30 | Luzerne | Pennsylvania | 42079 | 2722 | 147 |
195951 | 195951 | 2020-05-31 | Luzerne | Pennsylvania | 42079 | 2736 | 149 |
199024 | 199024 | 2020-06-01 | Luzerne | Pennsylvania | 42079 | 2739 | 149 |
202099 | 202099 | 2020-06-02 | Luzerne | Pennsylvania | 42079 | 2750 | 153 |
205176 | 205176 | 2020-06-03 | Luzerne | Pennsylvania | 42079 | 2766 | 155 |
208257 | 208257 | 2020-06-04 | Luzerne | Pennsylvania | 42079 | 2773 | 156 |
211339 | 211339 | 2020-06-05 | Luzerne | Pennsylvania | 42079 | 2782 | 157 |
214425 | 214425 | 2020-06-06 | Luzerne | Pennsylvania | 42079 | 2791 | 157 |
217515 | 217515 | 2020-06-07 | Luzerne | Pennsylvania | 42079 | 2793 | 157 |
220607 | 220607 | 2020-06-08 | Luzerne | Pennsylvania | 42079 | 2793 | 158 |
223702 | 223702 | 2020-06-09 | Luzerne | Pennsylvania | 42079 | 2798 | 160 |
226802 | 226802 | 2020-06-10 | Luzerne | Pennsylvania | 42079 | 2810 | 161 |
229906 | 229906 | 2020-06-11 | Luzerne | Pennsylvania | 42079 | 2813 | 161 |
233011 | 233011 | 2020-06-12 | Luzerne | Pennsylvania | 42079 | 2823 | 162 |
236116 | 236116 | 2020-06-13 | Luzerne | Pennsylvania | 42079 | 2824 | 164 |
239224 | 239224 | 2020-06-14 | Luzerne | Pennsylvania | 42079 | 2830 | 164 |
242333 | 242333 | 2020-06-15 | Luzerne | Pennsylvania | 42079 | 2835 | 168 |
245445 | 245445 | 2020-06-16 | Luzerne | Pennsylvania | 42079 | 2840 | 169 |
248558 | 248558 | 2020-06-17 | Luzerne | Pennsylvania | 42079 | 2841 | 169 |
251673 | 251673 | 2020-06-18 | Luzerne | Pennsylvania | 42079 | 2845 | 170 |
254788 | 254788 | 2020-06-19 | Luzerne | Pennsylvania | 42079 | 2850 | 170 |
257914 | 257914 | 2020-06-20 | Luzerne | Pennsylvania | 42079 | 2861 | 170 |
261041 | 261041 | 2020-06-21 | Luzerne | Pennsylvania | 42079 | 2864 | 171 |
264169 | 264169 | 2020-06-22 | Luzerne | Pennsylvania | 42079 | 2870 | 171 |
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);