ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Bedford" and state = "Pennsylvania" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
23292 | 23292 | 2020-03-31 | Bedford | Pennsylvania | 42009 | 2 | 0 |
25490 | 25490 | 2020-04-01 | Bedford | Pennsylvania | 42009 | 3 | 0 |
27762 | 27762 | 2020-04-02 | Bedford | Pennsylvania | 42009 | 3 | 0 |
30095 | 30095 | 2020-04-03 | Bedford | Pennsylvania | 42009 | 3 | 0 |
32485 | 32485 | 2020-04-04 | Bedford | Pennsylvania | 42009 | 4 | 0 |
34920 | 34920 | 2020-04-05 | Bedford | Pennsylvania | 42009 | 4 | 0 |
37395 | 37395 | 2020-04-06 | Bedford | Pennsylvania | 42009 | 4 | 0 |
39916 | 39916 | 2020-04-07 | Bedford | Pennsylvania | 42009 | 4 | 0 |
42476 | 42476 | 2020-04-08 | Bedford | Pennsylvania | 42009 | 4 | 0 |
45062 | 45062 | 2020-04-09 | Bedford | Pennsylvania | 42009 | 4 | 0 |
47679 | 47679 | 2020-04-10 | Bedford | Pennsylvania | 42009 | 3 | 0 |
50336 | 50336 | 2020-04-11 | Bedford | Pennsylvania | 42009 | 5 | 1 |
53009 | 53009 | 2020-04-12 | Bedford | Pennsylvania | 42009 | 5 | 1 |
55694 | 55694 | 2020-04-13 | Bedford | Pennsylvania | 42009 | 5 | 1 |
58397 | 58397 | 2020-04-14 | Bedford | Pennsylvania | 42009 | 5 | 1 |
61112 | 61112 | 2020-04-15 | Bedford | Pennsylvania | 42009 | 9 | 1 |
63838 | 63838 | 2020-04-16 | Bedford | Pennsylvania | 42009 | 11 | 1 |
66584 | 66584 | 2020-04-17 | Bedford | Pennsylvania | 42009 | 13 | 1 |
69342 | 69342 | 2020-04-18 | Bedford | Pennsylvania | 42009 | 14 | 1 |
72109 | 72109 | 2020-04-19 | Bedford | Pennsylvania | 42009 | 15 | 1 |
74884 | 74884 | 2020-04-20 | Bedford | Pennsylvania | 42009 | 15 | 1 |
77666 | 77666 | 2020-04-21 | Bedford | Pennsylvania | 42009 | 16 | 1 |
80456 | 80456 | 2020-04-22 | Bedford | Pennsylvania | 42009 | 16 | 1 |
83255 | 83255 | 2020-04-23 | Bedford | Pennsylvania | 42009 | 20 | 1 |
86059 | 86059 | 2020-04-24 | Bedford | Pennsylvania | 42009 | 21 | 1 |
88873 | 88873 | 2020-04-25 | Bedford | Pennsylvania | 42009 | 21 | 1 |
91689 | 91689 | 2020-04-26 | Bedford | Pennsylvania | 42009 | 21 | 1 |
94516 | 94516 | 2020-04-27 | Bedford | Pennsylvania | 42009 | 21 | 1 |
97355 | 97355 | 2020-04-28 | Bedford | Pennsylvania | 42009 | 22 | 1 |
100204 | 100204 | 2020-04-29 | Bedford | Pennsylvania | 42009 | 24 | 1 |
103057 | 103057 | 2020-04-30 | Bedford | Pennsylvania | 42009 | 24 | 1 |
105920 | 105920 | 2020-05-01 | Bedford | Pennsylvania | 42009 | 24 | 1 |
108787 | 108787 | 2020-05-02 | Bedford | Pennsylvania | 42009 | 24 | 1 |
111661 | 111661 | 2020-05-03 | Bedford | Pennsylvania | 42009 | 24 | 1 |
114543 | 114543 | 2020-05-04 | Bedford | Pennsylvania | 42009 | 24 | 1 |
117424 | 117424 | 2020-05-05 | Bedford | Pennsylvania | 42009 | 26 | 1 |
120386 | 120386 | 2020-05-06 | Bedford | Pennsylvania | 42009 | 27 | 1 |
123363 | 123363 | 2020-05-07 | Bedford | Pennsylvania | 42009 | 27 | 1 |
126346 | 126346 | 2020-05-08 | Bedford | Pennsylvania | 42009 | 28 | 1 |
129335 | 129335 | 2020-05-09 | Bedford | Pennsylvania | 42009 | 29 | 1 |
132324 | 132324 | 2020-05-10 | Bedford | Pennsylvania | 42009 | 29 | 1 |
135315 | 135315 | 2020-05-11 | Bedford | Pennsylvania | 42009 | 29 | 1 |
138305 | 138305 | 2020-05-12 | Bedford | Pennsylvania | 42009 | 29 | 1 |
141301 | 141301 | 2020-05-13 | Bedford | Pennsylvania | 42009 | 29 | 1 |
144297 | 144297 | 2020-05-14 | Bedford | Pennsylvania | 42009 | 30 | 1 |
147298 | 147298 | 2020-05-15 | Bedford | Pennsylvania | 42009 | 30 | 1 |
150305 | 150305 | 2020-05-16 | Bedford | Pennsylvania | 42009 | 32 | 1 |
153316 | 153316 | 2020-05-17 | Bedford | Pennsylvania | 42009 | 32 | 1 |
156333 | 156333 | 2020-05-18 | Bedford | Pennsylvania | 42009 | 32 | 1 |
159354 | 159354 | 2020-05-19 | Bedford | Pennsylvania | 42009 | 32 | 2 |
162381 | 162381 | 2020-05-20 | Bedford | Pennsylvania | 42009 | 32 | 2 |
165410 | 165410 | 2020-05-21 | Bedford | Pennsylvania | 42009 | 36 | 2 |
168446 | 168446 | 2020-05-22 | Bedford | Pennsylvania | 42009 | 36 | 2 |
171485 | 171485 | 2020-05-23 | Bedford | Pennsylvania | 42009 | 37 | 2 |
174527 | 174527 | 2020-05-24 | Bedford | Pennsylvania | 42009 | 37 | 2 |
177571 | 177571 | 2020-05-25 | Bedford | Pennsylvania | 42009 | 37 | 2 |
180614 | 180614 | 2020-05-26 | Bedford | Pennsylvania | 42009 | 37 | 2 |
183664 | 183664 | 2020-05-27 | Bedford | Pennsylvania | 42009 | 38 | 2 |
186721 | 186721 | 2020-05-28 | Bedford | Pennsylvania | 42009 | 38 | 2 |
189782 | 189782 | 2020-05-29 | Bedford | Pennsylvania | 42009 | 39 | 2 |
192847 | 192847 | 2020-05-30 | Bedford | Pennsylvania | 42009 | 39 | 2 |
195916 | 195916 | 2020-05-31 | Bedford | Pennsylvania | 42009 | 39 | 2 |
198989 | 198989 | 2020-06-01 | Bedford | Pennsylvania | 42009 | 40 | 2 |
202064 | 202064 | 2020-06-02 | Bedford | Pennsylvania | 42009 | 40 | 2 |
205141 | 205141 | 2020-06-03 | Bedford | Pennsylvania | 42009 | 41 | 2 |
208222 | 208222 | 2020-06-04 | Bedford | Pennsylvania | 42009 | 42 | 2 |
211304 | 211304 | 2020-06-05 | Bedford | Pennsylvania | 42009 | 43 | 2 |
214390 | 214390 | 2020-06-06 | Bedford | Pennsylvania | 42009 | 43 | 2 |
217480 | 217480 | 2020-06-07 | Bedford | Pennsylvania | 42009 | 44 | 2 |
220572 | 220572 | 2020-06-08 | Bedford | Pennsylvania | 42009 | 45 | 2 |
223667 | 223667 | 2020-06-09 | Bedford | Pennsylvania | 42009 | 45 | 2 |
226767 | 226767 | 2020-06-10 | Bedford | Pennsylvania | 42009 | 45 | 2 |
229871 | 229871 | 2020-06-11 | Bedford | Pennsylvania | 42009 | 46 | 2 |
232976 | 232976 | 2020-06-12 | Bedford | Pennsylvania | 42009 | 46 | 2 |
236081 | 236081 | 2020-06-13 | Bedford | Pennsylvania | 42009 | 46 | 2 |
239189 | 239189 | 2020-06-14 | Bedford | Pennsylvania | 42009 | 48 | 2 |
242298 | 242298 | 2020-06-15 | Bedford | Pennsylvania | 42009 | 52 | 2 |
245410 | 245410 | 2020-06-16 | Bedford | Pennsylvania | 42009 | 53 | 2 |
248523 | 248523 | 2020-06-17 | Bedford | Pennsylvania | 42009 | 59 | 2 |
251638 | 251638 | 2020-06-18 | Bedford | Pennsylvania | 42009 | 61 | 2 |
254753 | 254753 | 2020-06-19 | Bedford | Pennsylvania | 42009 | 63 | 2 |
257879 | 257879 | 2020-06-20 | Bedford | Pennsylvania | 42009 | 65 | 2 |
261006 | 261006 | 2020-06-21 | Bedford | Pennsylvania | 42009 | 66 | 2 |
264134 | 264134 | 2020-06-22 | Bedford | Pennsylvania | 42009 | 66 | 2 |
267262 | 267262 | 2020-06-23 | Bedford | Pennsylvania | 42009 | 69 | 2 |
270396 | 270396 | 2020-06-24 | Bedford | Pennsylvania | 42009 | 71 | 2 |
273535 | 273535 | 2020-06-25 | Bedford | Pennsylvania | 42009 | 72 | 3 |
276682 | 276682 | 2020-06-26 | Bedford | Pennsylvania | 42009 | 76 | 3 |
279830 | 279830 | 2020-06-27 | Bedford | Pennsylvania | 42009 | 77 | 3 |
282976 | 282976 | 2020-06-28 | Bedford | Pennsylvania | 42009 | 81 | 3 |
286121 | 286121 | 2020-06-29 | Bedford | Pennsylvania | 42009 | 81 | 3 |
289272 | 289272 | 2020-06-30 | Bedford | Pennsylvania | 42009 | 82 | 3 |
292424 | 292424 | 2020-07-01 | Bedford | Pennsylvania | 42009 | 87 | 3 |
295580 | 295580 | 2020-07-02 | Bedford | Pennsylvania | 42009 | 88 | 4 |
298739 | 298739 | 2020-07-03 | Bedford | Pennsylvania | 42009 | 89 | 4 |
301903 | 301903 | 2020-07-04 | Bedford | Pennsylvania | 42009 | 89 | 4 |
305066 | 305066 | 2020-07-05 | Bedford | Pennsylvania | 42009 | 89 | 4 |
308233 | 308233 | 2020-07-06 | Bedford | Pennsylvania | 42009 | 89 | 4 |
311402 | 311402 | 2020-07-07 | Bedford | Pennsylvania | 42009 | 90 | 4 |
314574 | 314574 | 2020-07-08 | Bedford | Pennsylvania | 42009 | 90 | 4 |
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);