ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 42019 and state = "Pennsylvania" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6853 | 6853 | 2020-03-21 | Butler | Pennsylvania | 42019 | 1 | 0 |
7968 | 7968 | 2020-03-22 | Butler | Pennsylvania | 42019 | 1 | 0 |
9178 | 9178 | 2020-03-23 | Butler | Pennsylvania | 42019 | 5 | 0 |
10499 | 10499 | 2020-03-24 | Butler | Pennsylvania | 42019 | 6 | 0 |
11961 | 11961 | 2020-03-25 | Butler | Pennsylvania | 42019 | 12 | 0 |
13580 | 13580 | 2020-03-26 | Butler | Pennsylvania | 42019 | 19 | 1 |
15326 | 15326 | 2020-03-27 | Butler | Pennsylvania | 42019 | 26 | 1 |
17173 | 17173 | 2020-03-28 | Butler | Pennsylvania | 42019 | 41 | 2 |
19111 | 19111 | 2020-03-29 | Butler | Pennsylvania | 42019 | 47 | 2 |
21161 | 21161 | 2020-03-30 | Butler | Pennsylvania | 42019 | 49 | 2 |
23297 | 23297 | 2020-03-31 | Butler | Pennsylvania | 42019 | 60 | 2 |
25495 | 25495 | 2020-04-01 | Butler | Pennsylvania | 42019 | 64 | 2 |
27767 | 27767 | 2020-04-02 | Butler | Pennsylvania | 42019 | 69 | 2 |
30100 | 30100 | 2020-04-03 | Butler | Pennsylvania | 42019 | 75 | 2 |
32490 | 32490 | 2020-04-04 | Butler | Pennsylvania | 42019 | 84 | 2 |
34925 | 34925 | 2020-04-05 | Butler | Pennsylvania | 42019 | 87 | 2 |
37400 | 37400 | 2020-04-06 | Butler | Pennsylvania | 42019 | 91 | 2 |
39921 | 39921 | 2020-04-07 | Butler | Pennsylvania | 42019 | 107 | 2 |
42481 | 42481 | 2020-04-08 | Butler | Pennsylvania | 42019 | 113 | 2 |
45067 | 45067 | 2020-04-09 | Butler | Pennsylvania | 42019 | 113 | 2 |
47684 | 47684 | 2020-04-10 | Butler | Pennsylvania | 42019 | 123 | 3 |
50341 | 50341 | 2020-04-11 | Butler | Pennsylvania | 42019 | 128 | 3 |
53014 | 53014 | 2020-04-12 | Butler | Pennsylvania | 42019 | 133 | 4 |
55699 | 55699 | 2020-04-13 | Butler | Pennsylvania | 42019 | 143 | 4 |
58402 | 58402 | 2020-04-14 | Butler | Pennsylvania | 42019 | 143 | 5 |
61117 | 61117 | 2020-04-15 | Butler | Pennsylvania | 42019 | 150 | 5 |
63843 | 63843 | 2020-04-16 | Butler | Pennsylvania | 42019 | 154 | 5 |
66589 | 66589 | 2020-04-17 | Butler | Pennsylvania | 42019 | 157 | 5 |
69347 | 69347 | 2020-04-18 | Butler | Pennsylvania | 42019 | 160 | 5 |
72114 | 72114 | 2020-04-19 | Butler | Pennsylvania | 42019 | 161 | 5 |
74889 | 74889 | 2020-04-20 | Butler | Pennsylvania | 42019 | 161 | 5 |
77671 | 77671 | 2020-04-21 | Butler | Pennsylvania | 42019 | 162 | 6 |
80461 | 80461 | 2020-04-22 | Butler | Pennsylvania | 42019 | 164 | 7 |
83260 | 83260 | 2020-04-23 | Butler | Pennsylvania | 42019 | 164 | 6 |
86064 | 86064 | 2020-04-24 | Butler | Pennsylvania | 42019 | 168 | 6 |
88878 | 88878 | 2020-04-25 | Butler | Pennsylvania | 42019 | 168 | 6 |
91694 | 91694 | 2020-04-26 | Butler | Pennsylvania | 42019 | 170 | 6 |
94521 | 94521 | 2020-04-27 | Butler | Pennsylvania | 42019 | 170 | 6 |
97360 | 97360 | 2020-04-28 | Butler | Pennsylvania | 42019 | 174 | 6 |
100209 | 100209 | 2020-04-29 | Butler | Pennsylvania | 42019 | 175 | 6 |
103062 | 103062 | 2020-04-30 | Butler | Pennsylvania | 42019 | 178 | 6 |
105925 | 105925 | 2020-05-01 | Butler | Pennsylvania | 42019 | 180 | 6 |
108792 | 108792 | 2020-05-02 | Butler | Pennsylvania | 42019 | 180 | 6 |
111666 | 111666 | 2020-05-03 | Butler | Pennsylvania | 42019 | 180 | 6 |
114548 | 114548 | 2020-05-04 | Butler | Pennsylvania | 42019 | 180 | 6 |
117429 | 117429 | 2020-05-05 | Butler | Pennsylvania | 42019 | 184 | 6 |
120391 | 120391 | 2020-05-06 | Butler | Pennsylvania | 42019 | 185 | 6 |
123368 | 123368 | 2020-05-07 | Butler | Pennsylvania | 42019 | 190 | 6 |
126351 | 126351 | 2020-05-08 | Butler | Pennsylvania | 42019 | 192 | 6 |
129340 | 129340 | 2020-05-09 | Butler | Pennsylvania | 42019 | 194 | 6 |
132329 | 132329 | 2020-05-10 | Butler | Pennsylvania | 42019 | 195 | 6 |
135320 | 135320 | 2020-05-11 | Butler | Pennsylvania | 42019 | 195 | 6 |
138310 | 138310 | 2020-05-12 | Butler | Pennsylvania | 42019 | 198 | 6 |
141306 | 141306 | 2020-05-13 | Butler | Pennsylvania | 42019 | 197 | 6 |
144302 | 144302 | 2020-05-14 | Butler | Pennsylvania | 42019 | 199 | 6 |
147303 | 147303 | 2020-05-15 | Butler | Pennsylvania | 42019 | 202 | 6 |
150310 | 150310 | 2020-05-16 | Butler | Pennsylvania | 42019 | 202 | 6 |
153321 | 153321 | 2020-05-17 | Butler | Pennsylvania | 42019 | 203 | 6 |
156338 | 156338 | 2020-05-18 | Butler | Pennsylvania | 42019 | 203 | 12 |
159359 | 159359 | 2020-05-19 | Butler | Pennsylvania | 42019 | 206 | 12 |
162386 | 162386 | 2020-05-20 | Butler | Pennsylvania | 42019 | 208 | 12 |
165415 | 165415 | 2020-05-21 | Butler | Pennsylvania | 42019 | 209 | 12 |
168451 | 168451 | 2020-05-22 | Butler | Pennsylvania | 42019 | 209 | 12 |
171490 | 171490 | 2020-05-23 | Butler | Pennsylvania | 42019 | 216 | 12 |
174532 | 174532 | 2020-05-24 | Butler | Pennsylvania | 42019 | 219 | 12 |
177576 | 177576 | 2020-05-25 | Butler | Pennsylvania | 42019 | 220 | 12 |
180619 | 180619 | 2020-05-26 | Butler | Pennsylvania | 42019 | 220 | 12 |
183669 | 183669 | 2020-05-27 | Butler | Pennsylvania | 42019 | 222 | 12 |
186726 | 186726 | 2020-05-28 | Butler | Pennsylvania | 42019 | 226 | 12 |
189787 | 189787 | 2020-05-29 | Butler | Pennsylvania | 42019 | 227 | 12 |
192852 | 192852 | 2020-05-30 | Butler | Pennsylvania | 42019 | 229 | 12 |
195921 | 195921 | 2020-05-31 | Butler | Pennsylvania | 42019 | 230 | 12 |
198994 | 198994 | 2020-06-01 | Butler | Pennsylvania | 42019 | 230 | 12 |
202069 | 202069 | 2020-06-02 | Butler | Pennsylvania | 42019 | 232 | 12 |
205146 | 205146 | 2020-06-03 | Butler | Pennsylvania | 42019 | 235 | 12 |
208227 | 208227 | 2020-06-04 | Butler | Pennsylvania | 42019 | 240 | 12 |
211309 | 211309 | 2020-06-05 | Butler | Pennsylvania | 42019 | 239 | 12 |
214395 | 214395 | 2020-06-06 | Butler | Pennsylvania | 42019 | 244 | 12 |
217485 | 217485 | 2020-06-07 | Butler | Pennsylvania | 42019 | 247 | 12 |
220577 | 220577 | 2020-06-08 | Butler | Pennsylvania | 42019 | 247 | 12 |
223672 | 223672 | 2020-06-09 | Butler | Pennsylvania | 42019 | 249 | 12 |
226772 | 226772 | 2020-06-10 | Butler | Pennsylvania | 42019 | 250 | 12 |
229876 | 229876 | 2020-06-11 | Butler | Pennsylvania | 42019 | 255 | 12 |
232981 | 232981 | 2020-06-12 | Butler | Pennsylvania | 42019 | 256 | 12 |
236086 | 236086 | 2020-06-13 | Butler | Pennsylvania | 42019 | 257 | 12 |
239194 | 239194 | 2020-06-14 | Butler | Pennsylvania | 42019 | 257 | 12 |
242303 | 242303 | 2020-06-15 | Butler | Pennsylvania | 42019 | 257 | 12 |
245415 | 245415 | 2020-06-16 | Butler | Pennsylvania | 42019 | 260 | 12 |
248528 | 248528 | 2020-06-17 | Butler | Pennsylvania | 42019 | 263 | 13 |
251643 | 251643 | 2020-06-18 | Butler | Pennsylvania | 42019 | 263 | 13 |
254758 | 254758 | 2020-06-19 | Butler | Pennsylvania | 42019 | 263 | 13 |
257884 | 257884 | 2020-06-20 | Butler | Pennsylvania | 42019 | 263 | 13 |
261011 | 261011 | 2020-06-21 | Butler | Pennsylvania | 42019 | 268 | 13 |
264139 | 264139 | 2020-06-22 | Butler | Pennsylvania | 42019 | 271 | 13 |
267267 | 267267 | 2020-06-23 | Butler | Pennsylvania | 42019 | 273 | 13 |
270401 | 270401 | 2020-06-24 | Butler | Pennsylvania | 42019 | 277 | 13 |
273540 | 273540 | 2020-06-25 | Butler | Pennsylvania | 42019 | 280 | 13 |
276687 | 276687 | 2020-06-26 | Butler | Pennsylvania | 42019 | 284 | 13 |
279835 | 279835 | 2020-06-27 | Butler | Pennsylvania | 42019 | 291 | 13 |
282981 | 282981 | 2020-06-28 | Butler | Pennsylvania | 42019 | 295 | 13 |
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);