ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Wyoming" and state = "Pennsylvania" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
32543 | 32543 | 2020-04-04 | Wyoming | Pennsylvania | 42131 | 5 | 0 |
34979 | 34979 | 2020-04-05 | Wyoming | Pennsylvania | 42131 | 5 | 0 |
37454 | 37454 | 2020-04-06 | Wyoming | Pennsylvania | 42131 | 5 | 0 |
39977 | 39977 | 2020-04-07 | Wyoming | Pennsylvania | 42131 | 5 | 0 |
42537 | 42537 | 2020-04-08 | Wyoming | Pennsylvania | 42131 | 5 | 0 |
45123 | 45123 | 2020-04-09 | Wyoming | Pennsylvania | 42131 | 6 | 0 |
47740 | 47740 | 2020-04-10 | Wyoming | Pennsylvania | 42131 | 6 | 0 |
50397 | 50397 | 2020-04-11 | Wyoming | Pennsylvania | 42131 | 8 | 0 |
53070 | 53070 | 2020-04-12 | Wyoming | Pennsylvania | 42131 | 9 | 0 |
55755 | 55755 | 2020-04-13 | Wyoming | Pennsylvania | 42131 | 12 | 0 |
58458 | 58458 | 2020-04-14 | Wyoming | Pennsylvania | 42131 | 11 | 0 |
61173 | 61173 | 2020-04-15 | Wyoming | Pennsylvania | 42131 | 13 | 0 |
63899 | 63899 | 2020-04-16 | Wyoming | Pennsylvania | 42131 | 14 | 1 |
66645 | 66645 | 2020-04-17 | Wyoming | Pennsylvania | 42131 | 16 | 1 |
69403 | 69403 | 2020-04-18 | Wyoming | Pennsylvania | 42131 | 16 | 1 |
72170 | 72170 | 2020-04-19 | Wyoming | Pennsylvania | 42131 | 17 | 1 |
74945 | 74945 | 2020-04-20 | Wyoming | Pennsylvania | 42131 | 17 | 1 |
77727 | 77727 | 2020-04-21 | Wyoming | Pennsylvania | 42131 | 17 | 1 |
80517 | 80517 | 2020-04-22 | Wyoming | Pennsylvania | 42131 | 17 | 1 |
83316 | 83316 | 2020-04-23 | Wyoming | Pennsylvania | 42131 | 17 | 1 |
86120 | 86120 | 2020-04-24 | Wyoming | Pennsylvania | 42131 | 17 | 2 |
88934 | 88934 | 2020-04-25 | Wyoming | Pennsylvania | 42131 | 17 | 2 |
91750 | 91750 | 2020-04-26 | Wyoming | Pennsylvania | 42131 | 17 | 2 |
94577 | 94577 | 2020-04-27 | Wyoming | Pennsylvania | 42131 | 18 | 2 |
97416 | 97416 | 2020-04-28 | Wyoming | Pennsylvania | 42131 | 18 | 2 |
100265 | 100265 | 2020-04-29 | Wyoming | Pennsylvania | 42131 | 19 | 2 |
103118 | 103118 | 2020-04-30 | Wyoming | Pennsylvania | 42131 | 20 | 2 |
105981 | 105981 | 2020-05-01 | Wyoming | Pennsylvania | 42131 | 21 | 2 |
108848 | 108848 | 2020-05-02 | Wyoming | Pennsylvania | 42131 | 25 | 2 |
111722 | 111722 | 2020-05-03 | Wyoming | Pennsylvania | 42131 | 25 | 2 |
114604 | 114604 | 2020-05-04 | Wyoming | Pennsylvania | 42131 | 27 | 2 |
117485 | 117485 | 2020-05-05 | Wyoming | Pennsylvania | 42131 | 27 | 2 |
120447 | 120447 | 2020-05-06 | Wyoming | Pennsylvania | 42131 | 27 | 2 |
123424 | 123424 | 2020-05-07 | Wyoming | Pennsylvania | 42131 | 27 | 2 |
126407 | 126407 | 2020-05-08 | Wyoming | Pennsylvania | 42131 | 28 | 2 |
129396 | 129396 | 2020-05-09 | Wyoming | Pennsylvania | 42131 | 30 | 2 |
132385 | 132385 | 2020-05-10 | Wyoming | Pennsylvania | 42131 | 30 | 2 |
135376 | 135376 | 2020-05-11 | Wyoming | Pennsylvania | 42131 | 30 | 3 |
138366 | 138366 | 2020-05-12 | Wyoming | Pennsylvania | 42131 | 31 | 3 |
141362 | 141362 | 2020-05-13 | Wyoming | Pennsylvania | 42131 | 31 | 4 |
144358 | 144358 | 2020-05-14 | Wyoming | Pennsylvania | 42131 | 31 | 4 |
147359 | 147359 | 2020-05-15 | Wyoming | Pennsylvania | 42131 | 28 | 3 |
150366 | 150366 | 2020-05-16 | Wyoming | Pennsylvania | 42131 | 29 | 4 |
153377 | 153377 | 2020-05-17 | Wyoming | Pennsylvania | 42131 | 29 | 4 |
156394 | 156394 | 2020-05-18 | Wyoming | Pennsylvania | 42131 | 30 | 4 |
159415 | 159415 | 2020-05-19 | Wyoming | Pennsylvania | 42131 | 30 | 5 |
162442 | 162442 | 2020-05-20 | Wyoming | Pennsylvania | 42131 | 30 | 6 |
165471 | 165471 | 2020-05-21 | Wyoming | Pennsylvania | 42131 | 32 | 7 |
168507 | 168507 | 2020-05-22 | Wyoming | Pennsylvania | 42131 | 33 | 7 |
171546 | 171546 | 2020-05-23 | Wyoming | Pennsylvania | 42131 | 33 | 7 |
174588 | 174588 | 2020-05-24 | Wyoming | Pennsylvania | 42131 | 33 | 7 |
177632 | 177632 | 2020-05-25 | Wyoming | Pennsylvania | 42131 | 33 | 7 |
180675 | 180675 | 2020-05-26 | Wyoming | Pennsylvania | 42131 | 33 | 7 |
183725 | 183725 | 2020-05-27 | Wyoming | Pennsylvania | 42131 | 33 | 7 |
186782 | 186782 | 2020-05-28 | Wyoming | Pennsylvania | 42131 | 34 | 7 |
189843 | 189843 | 2020-05-29 | Wyoming | Pennsylvania | 42131 | 34 | 7 |
192908 | 192908 | 2020-05-30 | Wyoming | Pennsylvania | 42131 | 34 | 7 |
195977 | 195977 | 2020-05-31 | Wyoming | Pennsylvania | 42131 | 34 | 7 |
199050 | 199050 | 2020-06-01 | Wyoming | Pennsylvania | 42131 | 34 | 7 |
202125 | 202125 | 2020-06-02 | Wyoming | Pennsylvania | 42131 | 34 | 7 |
205202 | 205202 | 2020-06-03 | Wyoming | Pennsylvania | 42131 | 34 | 7 |
208283 | 208283 | 2020-06-04 | Wyoming | Pennsylvania | 42131 | 34 | 7 |
211365 | 211365 | 2020-06-05 | Wyoming | Pennsylvania | 42131 | 34 | 7 |
214451 | 214451 | 2020-06-06 | Wyoming | Pennsylvania | 42131 | 34 | 7 |
217541 | 217541 | 2020-06-07 | Wyoming | Pennsylvania | 42131 | 34 | 7 |
220633 | 220633 | 2020-06-08 | Wyoming | Pennsylvania | 42131 | 35 | 7 |
223728 | 223728 | 2020-06-09 | Wyoming | Pennsylvania | 42131 | 36 | 7 |
226828 | 226828 | 2020-06-10 | Wyoming | Pennsylvania | 42131 | 36 | 7 |
229932 | 229932 | 2020-06-11 | Wyoming | Pennsylvania | 42131 | 36 | 7 |
233037 | 233037 | 2020-06-12 | Wyoming | Pennsylvania | 42131 | 36 | 7 |
236142 | 236142 | 2020-06-13 | Wyoming | Pennsylvania | 42131 | 36 | 7 |
239250 | 239250 | 2020-06-14 | Wyoming | Pennsylvania | 42131 | 36 | 7 |
242359 | 242359 | 2020-06-15 | Wyoming | Pennsylvania | 42131 | 36 | 7 |
245471 | 245471 | 2020-06-16 | Wyoming | Pennsylvania | 42131 | 36 | 7 |
248584 | 248584 | 2020-06-17 | Wyoming | Pennsylvania | 42131 | 36 | 7 |
251699 | 251699 | 2020-06-18 | Wyoming | Pennsylvania | 42131 | 36 | 7 |
254814 | 254814 | 2020-06-19 | Wyoming | Pennsylvania | 42131 | 36 | 7 |
257940 | 257940 | 2020-06-20 | Wyoming | Pennsylvania | 42131 | 36 | 7 |
261067 | 261067 | 2020-06-21 | Wyoming | Pennsylvania | 42131 | 37 | 7 |
264195 | 264195 | 2020-06-22 | Wyoming | Pennsylvania | 42131 | 37 | 7 |
267323 | 267323 | 2020-06-23 | Wyoming | Pennsylvania | 42131 | 37 | 7 |
270457 | 270457 | 2020-06-24 | Wyoming | Pennsylvania | 42131 | 37 | 7 |
273596 | 273596 | 2020-06-25 | Wyoming | Pennsylvania | 42131 | 37 | 7 |
276743 | 276743 | 2020-06-26 | Wyoming | Pennsylvania | 42131 | 37 | 7 |
279891 | 279891 | 2020-06-27 | Wyoming | Pennsylvania | 42131 | 37 | 7 |
283037 | 283037 | 2020-06-28 | Wyoming | Pennsylvania | 42131 | 37 | 7 |
286182 | 286182 | 2020-06-29 | Wyoming | Pennsylvania | 42131 | 37 | 7 |
289333 | 289333 | 2020-06-30 | Wyoming | Pennsylvania | 42131 | 38 | 7 |
292485 | 292485 | 2020-07-01 | Wyoming | Pennsylvania | 42131 | 38 | 7 |
295641 | 295641 | 2020-07-02 | Wyoming | Pennsylvania | 42131 | 38 | 7 |
298800 | 298800 | 2020-07-03 | Wyoming | Pennsylvania | 42131 | 39 | 7 |
301964 | 301964 | 2020-07-04 | Wyoming | Pennsylvania | 42131 | 39 | 7 |
305127 | 305127 | 2020-07-05 | Wyoming | Pennsylvania | 42131 | 39 | 7 |
308294 | 308294 | 2020-07-06 | Wyoming | Pennsylvania | 42131 | 40 | 7 |
311463 | 311463 | 2020-07-07 | Wyoming | Pennsylvania | 42131 | 40 | 7 |
314635 | 314635 | 2020-07-08 | Wyoming | Pennsylvania | 42131 | 40 | 7 |
317808 | 317808 | 2020-07-09 | Wyoming | Pennsylvania | 42131 | 41 | 7 |
320986 | 320986 | 2020-07-10 | Wyoming | Pennsylvania | 42131 | 42 | 7 |
324166 | 324166 | 2020-07-11 | Wyoming | Pennsylvania | 42131 | 44 | 7 |
327351 | 327351 | 2020-07-12 | Wyoming | Pennsylvania | 42131 | 45 | 7 |
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);