ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72041 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 |
---|---|---|---|---|---|---|---|
117507 | 117507 | 2020-05-05 | Cidra | Puerto Rico | 72041 | 26 | |
120469 | 120469 | 2020-05-06 | Cidra | Puerto Rico | 72041 | 26 | |
123446 | 123446 | 2020-05-07 | Cidra | Puerto Rico | 72041 | 28 | |
126429 | 126429 | 2020-05-08 | Cidra | Puerto Rico | 72041 | 30 | |
129418 | 129418 | 2020-05-09 | Cidra | Puerto Rico | 72041 | 31 | |
132407 | 132407 | 2020-05-10 | Cidra | Puerto Rico | 72041 | 31 | |
135398 | 135398 | 2020-05-11 | Cidra | Puerto Rico | 72041 | 31 | |
138388 | 138388 | 2020-05-12 | Cidra | Puerto Rico | 72041 | 31 | |
141384 | 141384 | 2020-05-13 | Cidra | Puerto Rico | 72041 | 32 | |
144380 | 144380 | 2020-05-14 | Cidra | Puerto Rico | 72041 | 34 | |
147381 | 147381 | 2020-05-15 | Cidra | Puerto Rico | 72041 | 35 | |
150388 | 150388 | 2020-05-16 | Cidra | Puerto Rico | 72041 | 35 | |
156416 | 156416 | 2020-05-18 | Cidra | Puerto Rico | 72041 | 35 | |
153399 | 153399 | 2020-05-17 | Cidra | Puerto Rico | 72041 | 36 | |
159437 | 159437 | 2020-05-19 | Cidra | Puerto Rico | 72041 | 36 | |
162464 | 162464 | 2020-05-20 | Cidra | Puerto Rico | 72041 | 36 | |
165493 | 165493 | 2020-05-21 | Cidra | Puerto Rico | 72041 | 36 | |
168529 | 168529 | 2020-05-22 | Cidra | Puerto Rico | 72041 | 36 | |
171568 | 171568 | 2020-05-23 | Cidra | Puerto Rico | 72041 | 36 | |
174610 | 174610 | 2020-05-24 | Cidra | Puerto Rico | 72041 | 36 | |
177654 | 177654 | 2020-05-25 | Cidra | Puerto Rico | 72041 | 36 | |
180697 | 180697 | 2020-05-26 | Cidra | Puerto Rico | 72041 | 39 | |
183747 | 183747 | 2020-05-27 | Cidra | Puerto Rico | 72041 | 39 | |
186804 | 186804 | 2020-05-28 | Cidra | Puerto Rico | 72041 | 39 | |
189865 | 189865 | 2020-05-29 | Cidra | Puerto Rico | 72041 | 43 | |
192930 | 192930 | 2020-05-30 | Cidra | Puerto Rico | 72041 | 45 | |
195999 | 195999 | 2020-05-31 | Cidra | Puerto Rico | 72041 | 46 | |
199072 | 199072 | 2020-06-01 | Cidra | Puerto Rico | 72041 | 46 | |
202147 | 202147 | 2020-06-02 | Cidra | Puerto Rico | 72041 | 46 | |
205224 | 205224 | 2020-06-03 | Cidra | Puerto Rico | 72041 | 46 | |
208305 | 208305 | 2020-06-04 | Cidra | Puerto Rico | 72041 | 49 | |
211387 | 211387 | 2020-06-05 | Cidra | Puerto Rico | 72041 | 49 | |
214473 | 214473 | 2020-06-06 | Cidra | Puerto Rico | 72041 | 51 | |
217563 | 217563 | 2020-06-07 | Cidra | Puerto Rico | 72041 | 51 | |
220655 | 220655 | 2020-06-08 | Cidra | Puerto Rico | 72041 | 52 | |
223750 | 223750 | 2020-06-09 | Cidra | Puerto Rico | 72041 | 52 | |
226850 | 226850 | 2020-06-10 | Cidra | Puerto Rico | 72041 | 57 | |
229954 | 229954 | 2020-06-11 | Cidra | Puerto Rico | 72041 | 57 | |
233059 | 233059 | 2020-06-12 | Cidra | Puerto Rico | 72041 | 58 | |
236164 | 236164 | 2020-06-13 | Cidra | Puerto Rico | 72041 | 58 | |
239272 | 239272 | 2020-06-14 | Cidra | Puerto Rico | 72041 | 58 | |
242381 | 242381 | 2020-06-15 | Cidra | Puerto Rico | 72041 | 58 | |
245493 | 245493 | 2020-06-16 | Cidra | Puerto Rico | 72041 | 58 | |
248606 | 248606 | 2020-06-17 | Cidra | Puerto Rico | 72041 | 58 | |
251721 | 251721 | 2020-06-18 | Cidra | Puerto Rico | 72041 | 59 | |
254836 | 254836 | 2020-06-19 | Cidra | Puerto Rico | 72041 | 60 | |
257962 | 257962 | 2020-06-20 | Cidra | Puerto Rico | 72041 | 63 | |
261089 | 261089 | 2020-06-21 | Cidra | Puerto Rico | 72041 | 65 | |
264217 | 264217 | 2020-06-22 | Cidra | Puerto Rico | 72041 | 66 | |
267345 | 267345 | 2020-06-23 | Cidra | Puerto Rico | 72041 | 68 | |
270479 | 270479 | 2020-06-24 | Cidra | Puerto Rico | 72041 | 71 | |
273618 | 273618 | 2020-06-25 | Cidra | Puerto Rico | 72041 | 71 | |
276765 | 276765 | 2020-06-26 | Cidra | Puerto Rico | 72041 | 73 | |
279913 | 279913 | 2020-06-27 | Cidra | Puerto Rico | 72041 | 74 | |
283059 | 283059 | 2020-06-28 | Cidra | Puerto Rico | 72041 | 74 | |
286204 | 286204 | 2020-06-29 | Cidra | Puerto Rico | 72041 | 74 | |
289355 | 289355 | 2020-06-30 | Cidra | Puerto Rico | 72041 | 75 | |
292507 | 292507 | 2020-07-01 | Cidra | Puerto Rico | 72041 | 75 | |
295663 | 295663 | 2020-07-02 | Cidra | Puerto Rico | 72041 | 75 | |
298822 | 298822 | 2020-07-03 | Cidra | Puerto Rico | 72041 | 76 | |
301986 | 301986 | 2020-07-04 | Cidra | Puerto Rico | 72041 | 77 | |
305149 | 305149 | 2020-07-05 | Cidra | Puerto Rico | 72041 | 78 | |
308316 | 308316 | 2020-07-06 | Cidra | Puerto Rico | 72041 | 78 | |
311485 | 311485 | 2020-07-07 | Cidra | Puerto Rico | 72041 | 80 | |
314657 | 314657 | 2020-07-08 | Cidra | Puerto Rico | 72041 | 80 | |
317830 | 317830 | 2020-07-09 | Cidra | Puerto Rico | 72041 | 80 | |
321008 | 321008 | 2020-07-10 | Cidra | Puerto Rico | 72041 | 83 | |
324188 | 324188 | 2020-07-11 | Cidra | Puerto Rico | 72041 | 85 | |
327373 | 327373 | 2020-07-12 | Cidra | Puerto Rico | 72041 | 86 | |
330559 | 330559 | 2020-07-13 | Cidra | Puerto Rico | 72041 | 88 | |
333751 | 333751 | 2020-07-14 | Cidra | Puerto Rico | 72041 | 88 | |
336945 | 336945 | 2020-07-15 | Cidra | Puerto Rico | 72041 | 89 | |
340142 | 340142 | 2020-07-16 | Cidra | Puerto Rico | 72041 | 90 | |
343340 | 343340 | 2020-07-17 | Cidra | Puerto Rico | 72041 | 94 | |
346540 | 346540 | 2020-07-18 | Cidra | Puerto Rico | 72041 | 96 | |
349740 | 349740 | 2020-07-19 | Cidra | Puerto Rico | 72041 | 99 | |
352943 | 352943 | 2020-07-20 | Cidra | Puerto Rico | 72041 | 100 | |
356146 | 356146 | 2020-07-21 | Cidra | Puerto Rico | 72041 | 102 | |
359350 | 359350 | 2020-07-22 | Cidra | Puerto Rico | 72041 | 103 | |
362556 | 362556 | 2020-07-23 | Cidra | Puerto Rico | 72041 | 107 | |
365762 | 365762 | 2020-07-24 | Cidra | Puerto Rico | 72041 | 108 | |
368971 | 368971 | 2020-07-25 | Cidra | Puerto Rico | 72041 | 119 | |
372183 | 372183 | 2020-07-26 | Cidra | Puerto Rico | 72041 | 123 | |
375396 | 375396 | 2020-07-27 | Cidra | Puerto Rico | 72041 | 125 | |
378612 | 378612 | 2020-07-28 | Cidra | Puerto Rico | 72041 | 127 | |
381829 | 381829 | 2020-07-29 | Cidra | Puerto Rico | 72041 | 129 | |
385047 | 385047 | 2020-07-30 | Cidra | Puerto Rico | 72041 | 132 | |
388264 | 388264 | 2020-07-31 | Cidra | Puerto Rico | 72041 | 134 | |
391481 | 391481 | 2020-08-01 | Cidra | Puerto Rico | 72041 | 142 | |
394697 | 394697 | 2020-08-02 | Cidra | Puerto Rico | 72041 | 147 | |
397914 | 397914 | 2020-08-03 | Cidra | Puerto Rico | 72041 | 149 | |
404347 | 404347 | 2020-08-05 | Cidra | Puerto Rico | 72041 | 150 | |
407566 | 407566 | 2020-08-06 | Cidra | Puerto Rico | 72041 | 150 | |
401129 | 401129 | 2020-08-04 | Cidra | Puerto Rico | 72041 | 151 | |
410786 | 410786 | 2020-08-07 | Cidra | Puerto Rico | 72041 | 160 | |
414006 | 414006 | 2020-08-08 | Cidra | Puerto Rico | 72041 | 163 | |
417227 | 417227 | 2020-08-09 | Cidra | Puerto Rico | 72041 | 169 | |
420447 | 420447 | 2020-08-10 | Cidra | Puerto Rico | 72041 | 171 | |
423670 | 423670 | 2020-08-11 | Cidra | Puerto Rico | 72041 | 177 | |
426893 | 426893 | 2020-08-12 | Cidra | Puerto Rico | 72041 | 181 |
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);