ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72089 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 |
---|---|---|---|---|---|---|---|
117531 | 117531 | 2020-05-05 | Luquillo | Puerto Rico | 72089 | 6 | |
120493 | 120493 | 2020-05-06 | Luquillo | Puerto Rico | 72089 | 6 | |
123470 | 123470 | 2020-05-07 | Luquillo | Puerto Rico | 72089 | 6 | |
126453 | 126453 | 2020-05-08 | Luquillo | Puerto Rico | 72089 | 7 | |
129442 | 129442 | 2020-05-09 | Luquillo | Puerto Rico | 72089 | 7 | |
132431 | 132431 | 2020-05-10 | Luquillo | Puerto Rico | 72089 | 7 | |
135422 | 135422 | 2020-05-11 | Luquillo | Puerto Rico | 72089 | 8 | |
138412 | 138412 | 2020-05-12 | Luquillo | Puerto Rico | 72089 | 8 | |
141408 | 141408 | 2020-05-13 | Luquillo | Puerto Rico | 72089 | 8 | |
144404 | 144404 | 2020-05-14 | Luquillo | Puerto Rico | 72089 | 9 | |
147405 | 147405 | 2020-05-15 | Luquillo | Puerto Rico | 72089 | 11 | |
150412 | 150412 | 2020-05-16 | Luquillo | Puerto Rico | 72089 | 11 | |
153423 | 153423 | 2020-05-17 | Luquillo | Puerto Rico | 72089 | 11 | |
156440 | 156440 | 2020-05-18 | Luquillo | Puerto Rico | 72089 | 11 | |
159461 | 159461 | 2020-05-19 | Luquillo | Puerto Rico | 72089 | 12 | |
162488 | 162488 | 2020-05-20 | Luquillo | Puerto Rico | 72089 | 13 | |
165517 | 165517 | 2020-05-21 | Luquillo | Puerto Rico | 72089 | 14 | |
168553 | 168553 | 2020-05-22 | Luquillo | Puerto Rico | 72089 | 15 | |
171592 | 171592 | 2020-05-23 | Luquillo | Puerto Rico | 72089 | 16 | |
174634 | 174634 | 2020-05-24 | Luquillo | Puerto Rico | 72089 | 16 | |
177678 | 177678 | 2020-05-25 | Luquillo | Puerto Rico | 72089 | 18 | |
180721 | 180721 | 2020-05-26 | Luquillo | Puerto Rico | 72089 | 19 | |
183771 | 183771 | 2020-05-27 | Luquillo | Puerto Rico | 72089 | 19 | |
186828 | 186828 | 2020-05-28 | Luquillo | Puerto Rico | 72089 | 19 | |
192955 | 192955 | 2020-05-30 | Luquillo | Puerto Rico | 72089 | 19 | |
196024 | 196024 | 2020-05-31 | Luquillo | Puerto Rico | 72089 | 19 | |
199097 | 199097 | 2020-06-01 | Luquillo | Puerto Rico | 72089 | 19 | |
189890 | 189890 | 2020-05-29 | Luquillo | Puerto Rico | 72089 | 20 | |
202172 | 202172 | 2020-06-02 | Luquillo | Puerto Rico | 72089 | 20 | |
205249 | 205249 | 2020-06-03 | Luquillo | Puerto Rico | 72089 | 20 | |
208330 | 208330 | 2020-06-04 | Luquillo | Puerto Rico | 72089 | 21 | |
211412 | 211412 | 2020-06-05 | Luquillo | Puerto Rico | 72089 | 21 | |
214498 | 214498 | 2020-06-06 | Luquillo | Puerto Rico | 72089 | 25 | |
217588 | 217588 | 2020-06-07 | Luquillo | Puerto Rico | 72089 | 26 | |
220680 | 220680 | 2020-06-08 | Luquillo | Puerto Rico | 72089 | 26 | |
223775 | 223775 | 2020-06-09 | Luquillo | Puerto Rico | 72089 | 26 | |
226875 | 226875 | 2020-06-10 | Luquillo | Puerto Rico | 72089 | 26 | |
229979 | 229979 | 2020-06-11 | Luquillo | Puerto Rico | 72089 | 26 | |
239297 | 239297 | 2020-06-14 | Luquillo | Puerto Rico | 72089 | 29 | |
242406 | 242406 | 2020-06-15 | Luquillo | Puerto Rico | 72089 | 29 | |
233084 | 233084 | 2020-06-12 | Luquillo | Puerto Rico | 72089 | 30 | |
236189 | 236189 | 2020-06-13 | Luquillo | Puerto Rico | 72089 | 30 | |
245518 | 245518 | 2020-06-16 | Luquillo | Puerto Rico | 72089 | 30 | |
248631 | 248631 | 2020-06-17 | Luquillo | Puerto Rico | 72089 | 30 | |
251746 | 251746 | 2020-06-18 | Luquillo | Puerto Rico | 72089 | 30 | |
254861 | 254861 | 2020-06-19 | Luquillo | Puerto Rico | 72089 | 33 | |
257987 | 257987 | 2020-06-20 | Luquillo | Puerto Rico | 72089 | 37 | |
261114 | 261114 | 2020-06-21 | Luquillo | Puerto Rico | 72089 | 38 | |
264242 | 264242 | 2020-06-22 | Luquillo | Puerto Rico | 72089 | 38 | |
267370 | 267370 | 2020-06-23 | Luquillo | Puerto Rico | 72089 | 38 | |
270504 | 270504 | 2020-06-24 | Luquillo | Puerto Rico | 72089 | 39 | |
273643 | 273643 | 2020-06-25 | Luquillo | Puerto Rico | 72089 | 39 | |
276790 | 276790 | 2020-06-26 | Luquillo | Puerto Rico | 72089 | 39 | |
279938 | 279938 | 2020-06-27 | Luquillo | Puerto Rico | 72089 | 40 | |
283084 | 283084 | 2020-06-28 | Luquillo | Puerto Rico | 72089 | 40 | |
286229 | 286229 | 2020-06-29 | Luquillo | Puerto Rico | 72089 | 40 | |
289380 | 289380 | 2020-06-30 | Luquillo | Puerto Rico | 72089 | 41 | |
292532 | 292532 | 2020-07-01 | Luquillo | Puerto Rico | 72089 | 43 | |
295688 | 295688 | 2020-07-02 | Luquillo | Puerto Rico | 72089 | 44 | |
298847 | 298847 | 2020-07-03 | Luquillo | Puerto Rico | 72089 | 45 | |
302011 | 302011 | 2020-07-04 | Luquillo | Puerto Rico | 72089 | 47 | |
305174 | 305174 | 2020-07-05 | Luquillo | Puerto Rico | 72089 | 48 | |
308341 | 308341 | 2020-07-06 | Luquillo | Puerto Rico | 72089 | 55 | |
311510 | 311510 | 2020-07-07 | Luquillo | Puerto Rico | 72089 | 55 | |
314682 | 314682 | 2020-07-08 | Luquillo | Puerto Rico | 72089 | 55 | |
317855 | 317855 | 2020-07-09 | Luquillo | Puerto Rico | 72089 | 55 | |
321033 | 321033 | 2020-07-10 | Luquillo | Puerto Rico | 72089 | 55 | |
324213 | 324213 | 2020-07-11 | Luquillo | Puerto Rico | 72089 | 56 | |
327398 | 327398 | 2020-07-12 | Luquillo | Puerto Rico | 72089 | 58 | |
330584 | 330584 | 2020-07-13 | Luquillo | Puerto Rico | 72089 | 59 | |
333776 | 333776 | 2020-07-14 | Luquillo | Puerto Rico | 72089 | 59 | |
336970 | 336970 | 2020-07-15 | Luquillo | Puerto Rico | 72089 | 59 | |
340167 | 340167 | 2020-07-16 | Luquillo | Puerto Rico | 72089 | 62 | |
343365 | 343365 | 2020-07-17 | Luquillo | Puerto Rico | 72089 | 66 | |
346565 | 346565 | 2020-07-18 | Luquillo | Puerto Rico | 72089 | 67 | |
349765 | 349765 | 2020-07-19 | Luquillo | Puerto Rico | 72089 | 72 | |
352968 | 352968 | 2020-07-20 | Luquillo | Puerto Rico | 72089 | 72 | |
356171 | 356171 | 2020-07-21 | Luquillo | Puerto Rico | 72089 | 73 | |
359375 | 359375 | 2020-07-22 | Luquillo | Puerto Rico | 72089 | 73 | |
362581 | 362581 | 2020-07-23 | Luquillo | Puerto Rico | 72089 | 73 | |
365787 | 365787 | 2020-07-24 | Luquillo | Puerto Rico | 72089 | 77 | |
368996 | 368996 | 2020-07-25 | Luquillo | Puerto Rico | 72089 | 81 | |
372208 | 372208 | 2020-07-26 | Luquillo | Puerto Rico | 72089 | 82 | |
375421 | 375421 | 2020-07-27 | Luquillo | Puerto Rico | 72089 | 82 | |
378637 | 378637 | 2020-07-28 | Luquillo | Puerto Rico | 72089 | 85 | |
381854 | 381854 | 2020-07-29 | Luquillo | Puerto Rico | 72089 | 86 | |
385072 | 385072 | 2020-07-30 | Luquillo | Puerto Rico | 72089 | 86 | |
388289 | 388289 | 2020-07-31 | Luquillo | Puerto Rico | 72089 | 88 | |
391506 | 391506 | 2020-08-01 | Luquillo | Puerto Rico | 72089 | 90 | |
394722 | 394722 | 2020-08-02 | Luquillo | Puerto Rico | 72089 | 91 | |
397939 | 397939 | 2020-08-03 | Luquillo | Puerto Rico | 72089 | 91 | |
401154 | 401154 | 2020-08-04 | Luquillo | Puerto Rico | 72089 | 92 | |
404372 | 404372 | 2020-08-05 | Luquillo | Puerto Rico | 72089 | 93 | |
407591 | 407591 | 2020-08-06 | Luquillo | Puerto Rico | 72089 | 95 | |
410811 | 410811 | 2020-08-07 | Luquillo | Puerto Rico | 72089 | 100 | |
414031 | 414031 | 2020-08-08 | Luquillo | Puerto Rico | 72089 | 102 | |
417252 | 417252 | 2020-08-09 | Luquillo | Puerto Rico | 72089 | 106 | |
420472 | 420472 | 2020-08-10 | Luquillo | Puerto Rico | 72089 | 110 | |
423695 | 423695 | 2020-08-11 | Luquillo | Puerto Rico | 72089 | 118 | |
426918 | 426918 | 2020-08-12 | Luquillo | Puerto Rico | 72089 | 119 |
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);