ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Luzerne" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388216 | 388216 | 2020-07-31 | Luzerne | Pennsylvania | 42079 | 3252 | 183 |
384999 | 384999 | 2020-07-30 | Luzerne | Pennsylvania | 42079 | 3239 | 183 |
381781 | 381781 | 2020-07-29 | Luzerne | Pennsylvania | 42079 | 3225 | 183 |
378564 | 378564 | 2020-07-28 | Luzerne | Pennsylvania | 42079 | 3191 | 183 |
375348 | 375348 | 2020-07-27 | Luzerne | Pennsylvania | 42079 | 3156 | 183 |
372135 | 372135 | 2020-07-26 | Luzerne | Pennsylvania | 42079 | 3144 | 183 |
368923 | 368923 | 2020-07-25 | Luzerne | Pennsylvania | 42079 | 3130 | 183 |
365714 | 365714 | 2020-07-24 | Luzerne | Pennsylvania | 42079 | 3107 | 183 |
362508 | 362508 | 2020-07-23 | Luzerne | Pennsylvania | 42079 | 3091 | 183 |
359302 | 359302 | 2020-07-22 | Luzerne | Pennsylvania | 42079 | 3085 | 183 |
356098 | 356098 | 2020-07-21 | Luzerne | Pennsylvania | 42079 | 3083 | 182 |
352895 | 352895 | 2020-07-20 | Luzerne | Pennsylvania | 42079 | 3071 | 181 |
349692 | 349692 | 2020-07-19 | Luzerne | Pennsylvania | 42079 | 3068 | 181 |
346492 | 346492 | 2020-07-18 | Luzerne | Pennsylvania | 42079 | 3062 | 181 |
343292 | 343292 | 2020-07-17 | Luzerne | Pennsylvania | 42079 | 3047 | 181 |
340094 | 340094 | 2020-07-16 | Luzerne | Pennsylvania | 42079 | 3042 | 181 |
336897 | 336897 | 2020-07-15 | Luzerne | Pennsylvania | 42079 | 3036 | 181 |
333703 | 333703 | 2020-07-14 | Luzerne | Pennsylvania | 42079 | 3025 | 181 |
330511 | 330511 | 2020-07-13 | Luzerne | Pennsylvania | 42079 | 3024 | 181 |
327325 | 327325 | 2020-07-12 | Luzerne | Pennsylvania | 42079 | 3017 | 181 |
324140 | 324140 | 2020-07-11 | Luzerne | Pennsylvania | 42079 | 3002 | 181 |
320960 | 320960 | 2020-07-10 | Luzerne | Pennsylvania | 42079 | 2992 | 181 |
317782 | 317782 | 2020-07-09 | Luzerne | Pennsylvania | 42079 | 2979 | 179 |
314609 | 314609 | 2020-07-08 | Luzerne | Pennsylvania | 42079 | 2967 | 179 |
311437 | 311437 | 2020-07-07 | Luzerne | Pennsylvania | 42079 | 2964 | 179 |
308268 | 308268 | 2020-07-06 | Luzerne | Pennsylvania | 42079 | 2958 | 178 |
305101 | 305101 | 2020-07-05 | Luzerne | Pennsylvania | 42079 | 2956 | 178 |
301938 | 301938 | 2020-07-04 | Luzerne | Pennsylvania | 42079 | 2950 | 178 |
298774 | 298774 | 2020-07-03 | Luzerne | Pennsylvania | 42079 | 2939 | 178 |
295615 | 295615 | 2020-07-02 | Luzerne | Pennsylvania | 42079 | 2927 | 177 |
292459 | 292459 | 2020-07-01 | Luzerne | Pennsylvania | 42079 | 2915 | 177 |
289307 | 289307 | 2020-06-30 | Luzerne | Pennsylvania | 42079 | 2910 | 177 |
286156 | 286156 | 2020-06-29 | Luzerne | Pennsylvania | 42079 | 2906 | 177 |
283011 | 283011 | 2020-06-28 | Luzerne | Pennsylvania | 42079 | 2903 | 176 |
279865 | 279865 | 2020-06-27 | Luzerne | Pennsylvania | 42079 | 2898 | 176 |
276717 | 276717 | 2020-06-26 | Luzerne | Pennsylvania | 42079 | 2891 | 176 |
273570 | 273570 | 2020-06-25 | Luzerne | Pennsylvania | 42079 | 2883 | 174 |
270431 | 270431 | 2020-06-24 | Luzerne | Pennsylvania | 42079 | 2874 | 173 |
267297 | 267297 | 2020-06-23 | Luzerne | Pennsylvania | 42079 | 2873 | 172 |
264169 | 264169 | 2020-06-22 | Luzerne | Pennsylvania | 42079 | 2870 | 171 |
261041 | 261041 | 2020-06-21 | Luzerne | Pennsylvania | 42079 | 2864 | 171 |
257914 | 257914 | 2020-06-20 | Luzerne | Pennsylvania | 42079 | 2861 | 170 |
254788 | 254788 | 2020-06-19 | Luzerne | Pennsylvania | 42079 | 2850 | 170 |
251673 | 251673 | 2020-06-18 | Luzerne | Pennsylvania | 42079 | 2845 | 170 |
248558 | 248558 | 2020-06-17 | Luzerne | Pennsylvania | 42079 | 2841 | 169 |
245445 | 245445 | 2020-06-16 | Luzerne | Pennsylvania | 42079 | 2840 | 169 |
242333 | 242333 | 2020-06-15 | Luzerne | Pennsylvania | 42079 | 2835 | 168 |
239224 | 239224 | 2020-06-14 | Luzerne | Pennsylvania | 42079 | 2830 | 164 |
236116 | 236116 | 2020-06-13 | Luzerne | Pennsylvania | 42079 | 2824 | 164 |
233011 | 233011 | 2020-06-12 | Luzerne | Pennsylvania | 42079 | 2823 | 162 |
229906 | 229906 | 2020-06-11 | Luzerne | Pennsylvania | 42079 | 2813 | 161 |
226802 | 226802 | 2020-06-10 | Luzerne | Pennsylvania | 42079 | 2810 | 161 |
223702 | 223702 | 2020-06-09 | Luzerne | Pennsylvania | 42079 | 2798 | 160 |
220607 | 220607 | 2020-06-08 | Luzerne | Pennsylvania | 42079 | 2793 | 158 |
217515 | 217515 | 2020-06-07 | Luzerne | Pennsylvania | 42079 | 2793 | 157 |
214425 | 214425 | 2020-06-06 | Luzerne | Pennsylvania | 42079 | 2791 | 157 |
211339 | 211339 | 2020-06-05 | Luzerne | Pennsylvania | 42079 | 2782 | 157 |
208257 | 208257 | 2020-06-04 | Luzerne | Pennsylvania | 42079 | 2773 | 156 |
205176 | 205176 | 2020-06-03 | Luzerne | Pennsylvania | 42079 | 2766 | 155 |
202099 | 202099 | 2020-06-02 | Luzerne | Pennsylvania | 42079 | 2750 | 153 |
199024 | 199024 | 2020-06-01 | Luzerne | Pennsylvania | 42079 | 2739 | 149 |
195951 | 195951 | 2020-05-31 | Luzerne | Pennsylvania | 42079 | 2736 | 149 |
192882 | 192882 | 2020-05-30 | Luzerne | Pennsylvania | 42079 | 2722 | 147 |
189817 | 189817 | 2020-05-29 | Luzerne | Pennsylvania | 42079 | 2711 | 144 |
186756 | 186756 | 2020-05-28 | Luzerne | Pennsylvania | 42079 | 2689 | 139 |
183699 | 183699 | 2020-05-27 | Luzerne | Pennsylvania | 42079 | 2677 | 138 |
180649 | 180649 | 2020-05-26 | Luzerne | Pennsylvania | 42079 | 2662 | 135 |
177606 | 177606 | 2020-05-25 | Luzerne | Pennsylvania | 42079 | 2651 | 135 |
174562 | 174562 | 2020-05-24 | Luzerne | Pennsylvania | 42079 | 2645 | 135 |
171520 | 171520 | 2020-05-23 | Luzerne | Pennsylvania | 42079 | 2631 | 135 |
168481 | 168481 | 2020-05-22 | Luzerne | Pennsylvania | 42079 | 2620 | 133 |
165445 | 165445 | 2020-05-21 | Luzerne | Pennsylvania | 42079 | 2594 | 130 |
162416 | 162416 | 2020-05-20 | Luzerne | Pennsylvania | 42079 | 2572 | 128 |
159389 | 159389 | 2020-05-19 | Luzerne | Pennsylvania | 42079 | 2554 | 124 |
156368 | 156368 | 2020-05-18 | Luzerne | Pennsylvania | 42079 | 2532 | 122 |
153351 | 153351 | 2020-05-17 | Luzerne | Pennsylvania | 42079 | 2526 | 127 |
150340 | 150340 | 2020-05-16 | Luzerne | Pennsylvania | 42079 | 2513 | 127 |
147333 | 147333 | 2020-05-15 | Luzerne | Pennsylvania | 42079 | 2491 | 127 |
144332 | 144332 | 2020-05-14 | Luzerne | Pennsylvania | 42079 | 2477 | 124 |
141336 | 141336 | 2020-05-13 | Luzerne | Pennsylvania | 42079 | 2467 | 123 |
138340 | 138340 | 2020-05-12 | Luzerne | Pennsylvania | 42079 | 2449 | 120 |
135350 | 135350 | 2020-05-11 | Luzerne | Pennsylvania | 42079 | 2426 | 112 |
132359 | 132359 | 2020-05-10 | Luzerne | Pennsylvania | 42079 | 2416 | 111 |
129370 | 129370 | 2020-05-09 | Luzerne | Pennsylvania | 42079 | 2356 | 111 |
126381 | 126381 | 2020-05-08 | Luzerne | Pennsylvania | 42079 | 2347 | 120 |
123398 | 123398 | 2020-05-07 | Luzerne | Pennsylvania | 42079 | 2332 | 114 |
120421 | 120421 | 2020-05-06 | Luzerne | Pennsylvania | 42079 | 2306 | 107 |
117459 | 117459 | 2020-05-05 | Luzerne | Pennsylvania | 42079 | 2280 | 104 |
114578 | 114578 | 2020-05-04 | Luzerne | Pennsylvania | 42079 | 2255 | 101 |
111696 | 111696 | 2020-05-03 | Luzerne | Pennsylvania | 42079 | 2240 | 97 |
108822 | 108822 | 2020-05-02 | Luzerne | Pennsylvania | 42079 | 2211 | 97 |
105955 | 105955 | 2020-05-01 | Luzerne | Pennsylvania | 42079 | 2173 | 92 |
103092 | 103092 | 2020-04-30 | Luzerne | Pennsylvania | 42079 | 2143 | 88 |
100239 | 100239 | 2020-04-29 | Luzerne | Pennsylvania | 42079 | 2111 | 82 |
97390 | 97390 | 2020-04-28 | Luzerne | Pennsylvania | 42079 | 2078 | 74 |
94551 | 94551 | 2020-04-27 | Luzerne | Pennsylvania | 42079 | 2035 | 71 |
91724 | 91724 | 2020-04-26 | Luzerne | Pennsylvania | 42079 | 2008 | 67 |
88908 | 88908 | 2020-04-25 | Luzerne | Pennsylvania | 42079 | 1962 | 66 |
86094 | 86094 | 2020-04-24 | Luzerne | Pennsylvania | 42079 | 1921 | 62 |
83290 | 83290 | 2020-04-23 | Luzerne | Pennsylvania | 42079 | 1880 | 58 |
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);