ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72091 and state = "Puerto Rico" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
117532 | 117532 | 2020-05-05 | Manati | Puerto Rico | 72091 | 13 | |
120494 | 120494 | 2020-05-06 | Manati | Puerto Rico | 72091 | 13 | |
123471 | 123471 | 2020-05-07 | Manati | Puerto Rico | 72091 | 13 | |
126454 | 126454 | 2020-05-08 | Manati | Puerto Rico | 72091 | 13 | |
129443 | 129443 | 2020-05-09 | Manati | Puerto Rico | 72091 | 14 | |
132432 | 132432 | 2020-05-10 | Manati | Puerto Rico | 72091 | 16 | |
135423 | 135423 | 2020-05-11 | Manati | Puerto Rico | 72091 | 16 | |
138413 | 138413 | 2020-05-12 | Manati | Puerto Rico | 72091 | 17 | |
141409 | 141409 | 2020-05-13 | Manati | Puerto Rico | 72091 | 18 | |
144405 | 144405 | 2020-05-14 | Manati | Puerto Rico | 72091 | 18 | |
147406 | 147406 | 2020-05-15 | Manati | Puerto Rico | 72091 | 20 | |
150413 | 150413 | 2020-05-16 | Manati | Puerto Rico | 72091 | 20 | |
153424 | 153424 | 2020-05-17 | Manati | Puerto Rico | 72091 | 20 | |
156441 | 156441 | 2020-05-18 | Manati | Puerto Rico | 72091 | 21 | |
159462 | 159462 | 2020-05-19 | Manati | Puerto Rico | 72091 | 21 | |
162489 | 162489 | 2020-05-20 | Manati | Puerto Rico | 72091 | 21 | |
165518 | 165518 | 2020-05-21 | Manati | Puerto Rico | 72091 | 22 | |
168554 | 168554 | 2020-05-22 | Manati | Puerto Rico | 72091 | 22 | |
171593 | 171593 | 2020-05-23 | Manati | Puerto Rico | 72091 | 23 | |
174635 | 174635 | 2020-05-24 | Manati | Puerto Rico | 72091 | 24 | |
177679 | 177679 | 2020-05-25 | Manati | Puerto Rico | 72091 | 25 | |
180722 | 180722 | 2020-05-26 | Manati | Puerto Rico | 72091 | 25 | |
183772 | 183772 | 2020-05-27 | Manati | Puerto Rico | 72091 | 26 | |
186829 | 186829 | 2020-05-28 | Manati | Puerto Rico | 72091 | 26 | |
189891 | 189891 | 2020-05-29 | Manati | Puerto Rico | 72091 | 26 | |
192956 | 192956 | 2020-05-30 | Manati | Puerto Rico | 72091 | 26 | |
196025 | 196025 | 2020-05-31 | Manati | Puerto Rico | 72091 | 26 | |
199098 | 199098 | 2020-06-01 | Manati | Puerto Rico | 72091 | 26 | |
202173 | 202173 | 2020-06-02 | Manati | Puerto Rico | 72091 | 26 | |
205250 | 205250 | 2020-06-03 | Manati | Puerto Rico | 72091 | 26 | |
208331 | 208331 | 2020-06-04 | Manati | Puerto Rico | 72091 | 34 | |
211413 | 211413 | 2020-06-05 | Manati | Puerto Rico | 72091 | 34 | |
214499 | 214499 | 2020-06-06 | Manati | Puerto Rico | 72091 | 35 | |
217589 | 217589 | 2020-06-07 | Manati | Puerto Rico | 72091 | 36 | |
220681 | 220681 | 2020-06-08 | Manati | Puerto Rico | 72091 | 36 | |
223776 | 223776 | 2020-06-09 | Manati | Puerto Rico | 72091 | 38 | |
226876 | 226876 | 2020-06-10 | Manati | Puerto Rico | 72091 | 38 | |
229980 | 229980 | 2020-06-11 | Manati | Puerto Rico | 72091 | 38 | |
233085 | 233085 | 2020-06-12 | Manati | Puerto Rico | 72091 | 38 | |
236190 | 236190 | 2020-06-13 | Manati | Puerto Rico | 72091 | 38 | |
239298 | 239298 | 2020-06-14 | Manati | Puerto Rico | 72091 | 38 | |
242407 | 242407 | 2020-06-15 | Manati | Puerto Rico | 72091 | 38 | |
245519 | 245519 | 2020-06-16 | Manati | Puerto Rico | 72091 | 38 | |
248632 | 248632 | 2020-06-17 | Manati | Puerto Rico | 72091 | 38 | |
251747 | 251747 | 2020-06-18 | Manati | Puerto Rico | 72091 | 38 | |
254862 | 254862 | 2020-06-19 | Manati | Puerto Rico | 72091 | 38 | |
257988 | 257988 | 2020-06-20 | Manati | Puerto Rico | 72091 | 38 | |
261115 | 261115 | 2020-06-21 | Manati | Puerto Rico | 72091 | 38 | |
264243 | 264243 | 2020-06-22 | Manati | Puerto Rico | 72091 | 38 | |
267371 | 267371 | 2020-06-23 | Manati | Puerto Rico | 72091 | 38 | |
270505 | 270505 | 2020-06-24 | Manati | Puerto Rico | 72091 | 38 | |
273644 | 273644 | 2020-06-25 | Manati | Puerto Rico | 72091 | 46 | |
276791 | 276791 | 2020-06-26 | Manati | Puerto Rico | 72091 | 46 | |
279939 | 279939 | 2020-06-27 | Manati | Puerto Rico | 72091 | 46 | |
283085 | 283085 | 2020-06-28 | Manati | Puerto Rico | 72091 | 49 | |
286230 | 286230 | 2020-06-29 | Manati | Puerto Rico | 72091 | 49 | |
289381 | 289381 | 2020-06-30 | Manati | Puerto Rico | 72091 | 49 | |
292533 | 292533 | 2020-07-01 | Manati | Puerto Rico | 72091 | 50 | |
295689 | 295689 | 2020-07-02 | Manati | Puerto Rico | 72091 | 52 | |
298848 | 298848 | 2020-07-03 | Manati | Puerto Rico | 72091 | 52 | |
302012 | 302012 | 2020-07-04 | Manati | Puerto Rico | 72091 | 54 | |
305175 | 305175 | 2020-07-05 | Manati | Puerto Rico | 72091 | 54 | |
308342 | 308342 | 2020-07-06 | Manati | Puerto Rico | 72091 | 60 | |
311511 | 311511 | 2020-07-07 | Manati | Puerto Rico | 72091 | 62 | |
314683 | 314683 | 2020-07-08 | Manati | Puerto Rico | 72091 | 63 | |
317856 | 317856 | 2020-07-09 | Manati | Puerto Rico | 72091 | 63 | |
321034 | 321034 | 2020-07-10 | Manati | Puerto Rico | 72091 | 64 | |
324214 | 324214 | 2020-07-11 | Manati | Puerto Rico | 72091 | 65 | |
327399 | 327399 | 2020-07-12 | Manati | Puerto Rico | 72091 | 67 | |
330585 | 330585 | 2020-07-13 | Manati | Puerto Rico | 72091 | 68 | |
333777 | 333777 | 2020-07-14 | Manati | Puerto Rico | 72091 | 68 | |
336971 | 336971 | 2020-07-15 | Manati | Puerto Rico | 72091 | 72 | |
340168 | 340168 | 2020-07-16 | Manati | Puerto Rico | 72091 | 73 | |
343366 | 343366 | 2020-07-17 | Manati | Puerto Rico | 72091 | 75 | |
346566 | 346566 | 2020-07-18 | Manati | Puerto Rico | 72091 | 75 | |
349766 | 349766 | 2020-07-19 | Manati | Puerto Rico | 72091 | 81 | |
352969 | 352969 | 2020-07-20 | Manati | Puerto Rico | 72091 | 84 | |
356172 | 356172 | 2020-07-21 | Manati | Puerto Rico | 72091 | 97 | |
359376 | 359376 | 2020-07-22 | Manati | Puerto Rico | 72091 | 101 | |
362582 | 362582 | 2020-07-23 | Manati | Puerto Rico | 72091 | 107 | |
365788 | 365788 | 2020-07-24 | Manati | Puerto Rico | 72091 | 114 | |
368997 | 368997 | 2020-07-25 | Manati | Puerto Rico | 72091 | 134 | |
372209 | 372209 | 2020-07-26 | Manati | Puerto Rico | 72091 | 150 | |
375422 | 375422 | 2020-07-27 | Manati | Puerto Rico | 72091 | 156 | |
378638 | 378638 | 2020-07-28 | Manati | Puerto Rico | 72091 | 164 | |
381855 | 381855 | 2020-07-29 | Manati | Puerto Rico | 72091 | 169 | |
385073 | 385073 | 2020-07-30 | Manati | Puerto Rico | 72091 | 178 | |
388290 | 388290 | 2020-07-31 | Manati | Puerto Rico | 72091 | 179 | |
391507 | 391507 | 2020-08-01 | Manati | Puerto Rico | 72091 | 192 | |
394723 | 394723 | 2020-08-02 | Manati | Puerto Rico | 72091 | 192 | |
397940 | 397940 | 2020-08-03 | Manati | Puerto Rico | 72091 | 197 | |
401155 | 401155 | 2020-08-04 | Manati | Puerto Rico | 72091 | 201 | |
404373 | 404373 | 2020-08-05 | Manati | Puerto Rico | 72091 | 205 | |
407592 | 407592 | 2020-08-06 | Manati | Puerto Rico | 72091 | 206 | |
410812 | 410812 | 2020-08-07 | Manati | Puerto Rico | 72091 | 213 | |
414032 | 414032 | 2020-08-08 | Manati | Puerto Rico | 72091 | 226 | |
417253 | 417253 | 2020-08-09 | Manati | Puerto Rico | 72091 | 243 | |
420473 | 420473 | 2020-08-10 | Manati | Puerto Rico | 72091 | 249 | |
423696 | 423696 | 2020-08-11 | Manati | Puerto Rico | 72091 | 256 | |
426919 | 426919 | 2020-08-12 | Manati | Puerto Rico | 72091 | 274 |
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);