ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Ceiba" and state = "Puerto Rico" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
117505 | 117505 | 2020-05-05 | Ceiba | Puerto Rico | 72037 | 8 | |
120467 | 120467 | 2020-05-06 | Ceiba | Puerto Rico | 72037 | 8 | |
123444 | 123444 | 2020-05-07 | Ceiba | Puerto Rico | 72037 | 8 | |
126427 | 126427 | 2020-05-08 | Ceiba | Puerto Rico | 72037 | 8 | |
129416 | 129416 | 2020-05-09 | Ceiba | Puerto Rico | 72037 | 8 | |
132405 | 132405 | 2020-05-10 | Ceiba | Puerto Rico | 72037 | 9 | |
135396 | 135396 | 2020-05-11 | Ceiba | Puerto Rico | 72037 | 9 | |
138386 | 138386 | 2020-05-12 | Ceiba | Puerto Rico | 72037 | 9 | |
141382 | 141382 | 2020-05-13 | Ceiba | Puerto Rico | 72037 | 9 | |
144378 | 144378 | 2020-05-14 | Ceiba | Puerto Rico | 72037 | 9 | |
147379 | 147379 | 2020-05-15 | Ceiba | Puerto Rico | 72037 | 9 | |
150386 | 150386 | 2020-05-16 | Ceiba | Puerto Rico | 72037 | 9 | |
153397 | 153397 | 2020-05-17 | Ceiba | Puerto Rico | 72037 | 9 | |
156414 | 156414 | 2020-05-18 | Ceiba | Puerto Rico | 72037 | 9 | |
159435 | 159435 | 2020-05-19 | Ceiba | Puerto Rico | 72037 | 9 | |
162462 | 162462 | 2020-05-20 | Ceiba | Puerto Rico | 72037 | 9 | |
165491 | 165491 | 2020-05-21 | Ceiba | Puerto Rico | 72037 | 10 | |
168527 | 168527 | 2020-05-22 | Ceiba | Puerto Rico | 72037 | 10 | |
171566 | 171566 | 2020-05-23 | Ceiba | Puerto Rico | 72037 | 10 | |
174608 | 174608 | 2020-05-24 | Ceiba | Puerto Rico | 72037 | 11 | |
186802 | 186802 | 2020-05-28 | Ceiba | Puerto Rico | 72037 | 12 | |
177652 | 177652 | 2020-05-25 | Ceiba | Puerto Rico | 72037 | 13 | |
180695 | 180695 | 2020-05-26 | Ceiba | Puerto Rico | 72037 | 13 | |
183745 | 183745 | 2020-05-27 | Ceiba | Puerto Rico | 72037 | 13 | |
189863 | 189863 | 2020-05-29 | Ceiba | Puerto Rico | 72037 | 14 | |
192928 | 192928 | 2020-05-30 | Ceiba | Puerto Rico | 72037 | 14 | |
195997 | 195997 | 2020-05-31 | Ceiba | Puerto Rico | 72037 | 14 | |
199070 | 199070 | 2020-06-01 | Ceiba | Puerto Rico | 72037 | 15 | |
202145 | 202145 | 2020-06-02 | Ceiba | Puerto Rico | 72037 | 15 | |
205222 | 205222 | 2020-06-03 | Ceiba | Puerto Rico | 72037 | 15 | |
208303 | 208303 | 2020-06-04 | Ceiba | Puerto Rico | 72037 | 20 | |
211385 | 211385 | 2020-06-05 | Ceiba | Puerto Rico | 72037 | 20 | |
214471 | 214471 | 2020-06-06 | Ceiba | Puerto Rico | 72037 | 24 | |
217561 | 217561 | 2020-06-07 | Ceiba | Puerto Rico | 72037 | 24 | |
220653 | 220653 | 2020-06-08 | Ceiba | Puerto Rico | 72037 | 24 | |
223748 | 223748 | 2020-06-09 | Ceiba | Puerto Rico | 72037 | 25 | |
226848 | 226848 | 2020-06-10 | Ceiba | Puerto Rico | 72037 | 25 | |
229952 | 229952 | 2020-06-11 | Ceiba | Puerto Rico | 72037 | 25 | |
233057 | 233057 | 2020-06-12 | Ceiba | Puerto Rico | 72037 | 25 | |
236162 | 236162 | 2020-06-13 | Ceiba | Puerto Rico | 72037 | 25 | |
239270 | 239270 | 2020-06-14 | Ceiba | Puerto Rico | 72037 | 25 | |
242379 | 242379 | 2020-06-15 | Ceiba | Puerto Rico | 72037 | 25 | |
245491 | 245491 | 2020-06-16 | Ceiba | Puerto Rico | 72037 | 25 | |
248604 | 248604 | 2020-06-17 | Ceiba | Puerto Rico | 72037 | 25 | |
257960 | 257960 | 2020-06-20 | Ceiba | Puerto Rico | 72037 | 25 | |
261087 | 261087 | 2020-06-21 | Ceiba | Puerto Rico | 72037 | 25 | |
264215 | 264215 | 2020-06-22 | Ceiba | Puerto Rico | 72037 | 25 | |
267343 | 267343 | 2020-06-23 | Ceiba | Puerto Rico | 72037 | 25 | |
270477 | 270477 | 2020-06-24 | Ceiba | Puerto Rico | 72037 | 25 | |
251719 | 251719 | 2020-06-18 | Ceiba | Puerto Rico | 72037 | 26 | |
254834 | 254834 | 2020-06-19 | Ceiba | Puerto Rico | 72037 | 26 | |
273616 | 273616 | 2020-06-25 | Ceiba | Puerto Rico | 72037 | 26 | |
276763 | 276763 | 2020-06-26 | Ceiba | Puerto Rico | 72037 | 26 | |
279911 | 279911 | 2020-06-27 | Ceiba | Puerto Rico | 72037 | 26 | |
283057 | 283057 | 2020-06-28 | Ceiba | Puerto Rico | 72037 | 26 | |
286202 | 286202 | 2020-06-29 | Ceiba | Puerto Rico | 72037 | 26 | |
289353 | 289353 | 2020-06-30 | Ceiba | Puerto Rico | 72037 | 26 | |
292505 | 292505 | 2020-07-01 | Ceiba | Puerto Rico | 72037 | 26 | |
295661 | 295661 | 2020-07-02 | Ceiba | Puerto Rico | 72037 | 26 | |
298820 | 298820 | 2020-07-03 | Ceiba | Puerto Rico | 72037 | 26 | |
301984 | 301984 | 2020-07-04 | Ceiba | Puerto Rico | 72037 | 26 | |
305147 | 305147 | 2020-07-05 | Ceiba | Puerto Rico | 72037 | 26 | |
308314 | 308314 | 2020-07-06 | Ceiba | Puerto Rico | 72037 | 29 | |
311483 | 311483 | 2020-07-07 | Ceiba | Puerto Rico | 72037 | 29 | |
314655 | 314655 | 2020-07-08 | Ceiba | Puerto Rico | 72037 | 29 | |
317828 | 317828 | 2020-07-09 | Ceiba | Puerto Rico | 72037 | 29 | |
321006 | 321006 | 2020-07-10 | Ceiba | Puerto Rico | 72037 | 34 | |
324186 | 324186 | 2020-07-11 | Ceiba | Puerto Rico | 72037 | 34 | |
327371 | 327371 | 2020-07-12 | Ceiba | Puerto Rico | 72037 | 35 | |
330557 | 330557 | 2020-07-13 | Ceiba | Puerto Rico | 72037 | 35 | |
333749 | 333749 | 2020-07-14 | Ceiba | Puerto Rico | 72037 | 37 | |
336943 | 336943 | 2020-07-15 | Ceiba | Puerto Rico | 72037 | 37 | |
340140 | 340140 | 2020-07-16 | Ceiba | Puerto Rico | 72037 | 38 | |
343338 | 343338 | 2020-07-17 | Ceiba | Puerto Rico | 72037 | 39 | |
346538 | 346538 | 2020-07-18 | Ceiba | Puerto Rico | 72037 | 40 | |
349738 | 349738 | 2020-07-19 | Ceiba | Puerto Rico | 72037 | 40 | |
352941 | 352941 | 2020-07-20 | Ceiba | Puerto Rico | 72037 | 40 | |
356144 | 356144 | 2020-07-21 | Ceiba | Puerto Rico | 72037 | 41 | |
359348 | 359348 | 2020-07-22 | Ceiba | Puerto Rico | 72037 | 43 | |
362554 | 362554 | 2020-07-23 | Ceiba | Puerto Rico | 72037 | 45 | |
365760 | 365760 | 2020-07-24 | Ceiba | Puerto Rico | 72037 | 46 | |
368969 | 368969 | 2020-07-25 | Ceiba | Puerto Rico | 72037 | 48 | |
372181 | 372181 | 2020-07-26 | Ceiba | Puerto Rico | 72037 | 49 | |
375394 | 375394 | 2020-07-27 | Ceiba | Puerto Rico | 72037 | 50 | |
378610 | 378610 | 2020-07-28 | Ceiba | Puerto Rico | 72037 | 50 | |
381827 | 381827 | 2020-07-29 | Ceiba | Puerto Rico | 72037 | 51 | |
385045 | 385045 | 2020-07-30 | Ceiba | Puerto Rico | 72037 | 53 | |
388262 | 388262 | 2020-07-31 | Ceiba | Puerto Rico | 72037 | 55 | |
391479 | 391479 | 2020-08-01 | Ceiba | Puerto Rico | 72037 | 57 | |
394695 | 394695 | 2020-08-02 | Ceiba | Puerto Rico | 72037 | 58 | |
397912 | 397912 | 2020-08-03 | Ceiba | Puerto Rico | 72037 | 63 | |
401127 | 401127 | 2020-08-04 | Ceiba | Puerto Rico | 72037 | 63 | |
404345 | 404345 | 2020-08-05 | Ceiba | Puerto Rico | 72037 | 63 | |
407564 | 407564 | 2020-08-06 | Ceiba | Puerto Rico | 72037 | 64 | |
410784 | 410784 | 2020-08-07 | Ceiba | Puerto Rico | 72037 | 66 | |
414004 | 414004 | 2020-08-08 | Ceiba | Puerto Rico | 72037 | 67 | |
417225 | 417225 | 2020-08-09 | Ceiba | Puerto Rico | 72037 | 68 | |
420445 | 420445 | 2020-08-10 | Ceiba | Puerto Rico | 72037 | 70 | |
423668 | 423668 | 2020-08-11 | Ceiba | Puerto Rico | 72037 | 72 | |
426891 | 426891 | 2020-08-12 | Ceiba | Puerto Rico | 72037 | 72 |
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);