ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Butler" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388186 | 388186 | 2020-07-31 | Butler | Pennsylvania | 42019 | 597 | 15 |
384969 | 384969 | 2020-07-30 | Butler | Pennsylvania | 42019 | 593 | 15 |
381751 | 381751 | 2020-07-29 | Butler | Pennsylvania | 42019 | 586 | 15 |
378534 | 378534 | 2020-07-28 | Butler | Pennsylvania | 42019 | 577 | 14 |
375318 | 375318 | 2020-07-27 | Butler | Pennsylvania | 42019 | 562 | 14 |
372105 | 372105 | 2020-07-26 | Butler | Pennsylvania | 42019 | 556 | 14 |
368893 | 368893 | 2020-07-25 | Butler | Pennsylvania | 42019 | 544 | 14 |
365684 | 365684 | 2020-07-24 | Butler | Pennsylvania | 42019 | 535 | 14 |
362478 | 362478 | 2020-07-23 | Butler | Pennsylvania | 42019 | 519 | 14 |
359272 | 359272 | 2020-07-22 | Butler | Pennsylvania | 42019 | 513 | 14 |
356068 | 356068 | 2020-07-21 | Butler | Pennsylvania | 42019 | 508 | 14 |
352865 | 352865 | 2020-07-20 | Butler | Pennsylvania | 42019 | 481 | 13 |
349662 | 349662 | 2020-07-19 | Butler | Pennsylvania | 42019 | 479 | 13 |
346462 | 346462 | 2020-07-18 | Butler | Pennsylvania | 42019 | 474 | 13 |
343262 | 343262 | 2020-07-17 | Butler | Pennsylvania | 42019 | 465 | 13 |
340064 | 340064 | 2020-07-16 | Butler | Pennsylvania | 42019 | 456 | 13 |
336867 | 336867 | 2020-07-15 | Butler | Pennsylvania | 42019 | 444 | 13 |
333673 | 333673 | 2020-07-14 | Butler | Pennsylvania | 42019 | 444 | 13 |
330481 | 330481 | 2020-07-13 | Butler | Pennsylvania | 42019 | 429 | 13 |
327295 | 327295 | 2020-07-12 | Butler | Pennsylvania | 42019 | 421 | 13 |
324110 | 324110 | 2020-07-11 | Butler | Pennsylvania | 42019 | 410 | 13 |
320930 | 320930 | 2020-07-10 | Butler | Pennsylvania | 42019 | 403 | 13 |
317752 | 317752 | 2020-07-09 | Butler | Pennsylvania | 42019 | 396 | 13 |
314579 | 314579 | 2020-07-08 | Butler | Pennsylvania | 42019 | 390 | 13 |
311407 | 311407 | 2020-07-07 | Butler | Pennsylvania | 42019 | 370 | 13 |
308238 | 308238 | 2020-07-06 | Butler | Pennsylvania | 42019 | 356 | 13 |
305071 | 305071 | 2020-07-05 | Butler | Pennsylvania | 42019 | 346 | 13 |
301908 | 301908 | 2020-07-04 | Butler | Pennsylvania | 42019 | 340 | 13 |
298744 | 298744 | 2020-07-03 | Butler | Pennsylvania | 42019 | 330 | 13 |
295585 | 295585 | 2020-07-02 | Butler | Pennsylvania | 42019 | 319 | 13 |
292429 | 292429 | 2020-07-01 | Butler | Pennsylvania | 42019 | 311 | 13 |
289277 | 289277 | 2020-06-30 | Butler | Pennsylvania | 42019 | 307 | 13 |
286126 | 286126 | 2020-06-29 | Butler | Pennsylvania | 42019 | 302 | 13 |
282981 | 282981 | 2020-06-28 | Butler | Pennsylvania | 42019 | 295 | 13 |
279835 | 279835 | 2020-06-27 | Butler | Pennsylvania | 42019 | 291 | 13 |
276687 | 276687 | 2020-06-26 | Butler | Pennsylvania | 42019 | 284 | 13 |
273540 | 273540 | 2020-06-25 | Butler | Pennsylvania | 42019 | 280 | 13 |
270401 | 270401 | 2020-06-24 | Butler | Pennsylvania | 42019 | 277 | 13 |
267267 | 267267 | 2020-06-23 | Butler | Pennsylvania | 42019 | 273 | 13 |
264139 | 264139 | 2020-06-22 | Butler | Pennsylvania | 42019 | 271 | 13 |
261011 | 261011 | 2020-06-21 | Butler | Pennsylvania | 42019 | 268 | 13 |
257884 | 257884 | 2020-06-20 | Butler | Pennsylvania | 42019 | 263 | 13 |
254758 | 254758 | 2020-06-19 | Butler | Pennsylvania | 42019 | 263 | 13 |
251643 | 251643 | 2020-06-18 | Butler | Pennsylvania | 42019 | 263 | 13 |
248528 | 248528 | 2020-06-17 | Butler | Pennsylvania | 42019 | 263 | 13 |
245415 | 245415 | 2020-06-16 | Butler | Pennsylvania | 42019 | 260 | 12 |
242303 | 242303 | 2020-06-15 | Butler | Pennsylvania | 42019 | 257 | 12 |
239194 | 239194 | 2020-06-14 | Butler | Pennsylvania | 42019 | 257 | 12 |
236086 | 236086 | 2020-06-13 | Butler | Pennsylvania | 42019 | 257 | 12 |
232981 | 232981 | 2020-06-12 | Butler | Pennsylvania | 42019 | 256 | 12 |
229876 | 229876 | 2020-06-11 | Butler | Pennsylvania | 42019 | 255 | 12 |
226772 | 226772 | 2020-06-10 | Butler | Pennsylvania | 42019 | 250 | 12 |
223672 | 223672 | 2020-06-09 | Butler | Pennsylvania | 42019 | 249 | 12 |
220577 | 220577 | 2020-06-08 | Butler | Pennsylvania | 42019 | 247 | 12 |
217485 | 217485 | 2020-06-07 | Butler | Pennsylvania | 42019 | 247 | 12 |
214395 | 214395 | 2020-06-06 | Butler | Pennsylvania | 42019 | 244 | 12 |
211309 | 211309 | 2020-06-05 | Butler | Pennsylvania | 42019 | 239 | 12 |
208227 | 208227 | 2020-06-04 | Butler | Pennsylvania | 42019 | 240 | 12 |
205146 | 205146 | 2020-06-03 | Butler | Pennsylvania | 42019 | 235 | 12 |
202069 | 202069 | 2020-06-02 | Butler | Pennsylvania | 42019 | 232 | 12 |
198994 | 198994 | 2020-06-01 | Butler | Pennsylvania | 42019 | 230 | 12 |
195921 | 195921 | 2020-05-31 | Butler | Pennsylvania | 42019 | 230 | 12 |
192852 | 192852 | 2020-05-30 | Butler | Pennsylvania | 42019 | 229 | 12 |
189787 | 189787 | 2020-05-29 | Butler | Pennsylvania | 42019 | 227 | 12 |
186726 | 186726 | 2020-05-28 | Butler | Pennsylvania | 42019 | 226 | 12 |
183669 | 183669 | 2020-05-27 | Butler | Pennsylvania | 42019 | 222 | 12 |
180619 | 180619 | 2020-05-26 | Butler | Pennsylvania | 42019 | 220 | 12 |
177576 | 177576 | 2020-05-25 | Butler | Pennsylvania | 42019 | 220 | 12 |
174532 | 174532 | 2020-05-24 | Butler | Pennsylvania | 42019 | 219 | 12 |
171490 | 171490 | 2020-05-23 | Butler | Pennsylvania | 42019 | 216 | 12 |
168451 | 168451 | 2020-05-22 | Butler | Pennsylvania | 42019 | 209 | 12 |
165415 | 165415 | 2020-05-21 | Butler | Pennsylvania | 42019 | 209 | 12 |
162386 | 162386 | 2020-05-20 | Butler | Pennsylvania | 42019 | 208 | 12 |
159359 | 159359 | 2020-05-19 | Butler | Pennsylvania | 42019 | 206 | 12 |
156338 | 156338 | 2020-05-18 | Butler | Pennsylvania | 42019 | 203 | 12 |
153321 | 153321 | 2020-05-17 | Butler | Pennsylvania | 42019 | 203 | 6 |
150310 | 150310 | 2020-05-16 | Butler | Pennsylvania | 42019 | 202 | 6 |
147303 | 147303 | 2020-05-15 | Butler | Pennsylvania | 42019 | 202 | 6 |
144302 | 144302 | 2020-05-14 | Butler | Pennsylvania | 42019 | 199 | 6 |
141306 | 141306 | 2020-05-13 | Butler | Pennsylvania | 42019 | 197 | 6 |
138310 | 138310 | 2020-05-12 | Butler | Pennsylvania | 42019 | 198 | 6 |
135320 | 135320 | 2020-05-11 | Butler | Pennsylvania | 42019 | 195 | 6 |
132329 | 132329 | 2020-05-10 | Butler | Pennsylvania | 42019 | 195 | 6 |
129340 | 129340 | 2020-05-09 | Butler | Pennsylvania | 42019 | 194 | 6 |
126351 | 126351 | 2020-05-08 | Butler | Pennsylvania | 42019 | 192 | 6 |
123368 | 123368 | 2020-05-07 | Butler | Pennsylvania | 42019 | 190 | 6 |
120391 | 120391 | 2020-05-06 | Butler | Pennsylvania | 42019 | 185 | 6 |
117429 | 117429 | 2020-05-05 | Butler | Pennsylvania | 42019 | 184 | 6 |
114548 | 114548 | 2020-05-04 | Butler | Pennsylvania | 42019 | 180 | 6 |
111666 | 111666 | 2020-05-03 | Butler | Pennsylvania | 42019 | 180 | 6 |
108792 | 108792 | 2020-05-02 | Butler | Pennsylvania | 42019 | 180 | 6 |
105925 | 105925 | 2020-05-01 | Butler | Pennsylvania | 42019 | 180 | 6 |
103062 | 103062 | 2020-04-30 | Butler | Pennsylvania | 42019 | 178 | 6 |
100209 | 100209 | 2020-04-29 | Butler | Pennsylvania | 42019 | 175 | 6 |
97360 | 97360 | 2020-04-28 | Butler | Pennsylvania | 42019 | 174 | 6 |
94521 | 94521 | 2020-04-27 | Butler | Pennsylvania | 42019 | 170 | 6 |
91694 | 91694 | 2020-04-26 | Butler | Pennsylvania | 42019 | 170 | 6 |
88878 | 88878 | 2020-04-25 | Butler | Pennsylvania | 42019 | 168 | 6 |
86064 | 86064 | 2020-04-24 | Butler | Pennsylvania | 42019 | 168 | 6 |
83260 | 83260 | 2020-04-23 | Butler | Pennsylvania | 42019 | 164 | 6 |
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);