ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72029 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 |
---|---|---|---|---|---|---|---|
117501 | 117501 | 2020-05-05 | Canovanas | Puerto Rico | 72029 | 32 | |
120463 | 120463 | 2020-05-06 | Canovanas | Puerto Rico | 72029 | 32 | |
123440 | 123440 | 2020-05-07 | Canovanas | Puerto Rico | 72029 | 33 | |
126423 | 126423 | 2020-05-08 | Canovanas | Puerto Rico | 72029 | 33 | |
129412 | 129412 | 2020-05-09 | Canovanas | Puerto Rico | 72029 | 34 | |
132401 | 132401 | 2020-05-10 | Canovanas | Puerto Rico | 72029 | 35 | |
135392 | 135392 | 2020-05-11 | Canovanas | Puerto Rico | 72029 | 35 | |
138382 | 138382 | 2020-05-12 | Canovanas | Puerto Rico | 72029 | 35 | |
141378 | 141378 | 2020-05-13 | Canovanas | Puerto Rico | 72029 | 38 | |
144374 | 144374 | 2020-05-14 | Canovanas | Puerto Rico | 72029 | 38 | |
147375 | 147375 | 2020-05-15 | Canovanas | Puerto Rico | 72029 | 45 | |
153393 | 153393 | 2020-05-17 | Canovanas | Puerto Rico | 72029 | 45 | |
150382 | 150382 | 2020-05-16 | Canovanas | Puerto Rico | 72029 | 46 | |
156410 | 156410 | 2020-05-18 | Canovanas | Puerto Rico | 72029 | 47 | |
159431 | 159431 | 2020-05-19 | Canovanas | Puerto Rico | 72029 | 51 | |
162458 | 162458 | 2020-05-20 | Canovanas | Puerto Rico | 72029 | 52 | |
165487 | 165487 | 2020-05-21 | Canovanas | Puerto Rico | 72029 | 52 | |
168523 | 168523 | 2020-05-22 | Canovanas | Puerto Rico | 72029 | 54 | |
171562 | 171562 | 2020-05-23 | Canovanas | Puerto Rico | 72029 | 56 | |
174604 | 174604 | 2020-05-24 | Canovanas | Puerto Rico | 72029 | 57 | |
177648 | 177648 | 2020-05-25 | Canovanas | Puerto Rico | 72029 | 62 | |
180691 | 180691 | 2020-05-26 | Canovanas | Puerto Rico | 72029 | 63 | |
183741 | 183741 | 2020-05-27 | Canovanas | Puerto Rico | 72029 | 63 | |
186798 | 186798 | 2020-05-28 | Canovanas | Puerto Rico | 72029 | 63 | |
189859 | 189859 | 2020-05-29 | Canovanas | Puerto Rico | 72029 | 67 | |
192924 | 192924 | 2020-05-30 | Canovanas | Puerto Rico | 72029 | 69 | |
195993 | 195993 | 2020-05-31 | Canovanas | Puerto Rico | 72029 | 72 | |
199066 | 199066 | 2020-06-01 | Canovanas | Puerto Rico | 72029 | 72 | |
202141 | 202141 | 2020-06-02 | Canovanas | Puerto Rico | 72029 | 74 | |
205218 | 205218 | 2020-06-03 | Canovanas | Puerto Rico | 72029 | 75 | |
208299 | 208299 | 2020-06-04 | Canovanas | Puerto Rico | 72029 | 88 | |
211381 | 211381 | 2020-06-05 | Canovanas | Puerto Rico | 72029 | 88 | |
214467 | 214467 | 2020-06-06 | Canovanas | Puerto Rico | 72029 | 95 | |
217557 | 217557 | 2020-06-07 | Canovanas | Puerto Rico | 72029 | 97 | |
220649 | 220649 | 2020-06-08 | Canovanas | Puerto Rico | 72029 | 97 | |
223744 | 223744 | 2020-06-09 | Canovanas | Puerto Rico | 72029 | 99 | |
226844 | 226844 | 2020-06-10 | Canovanas | Puerto Rico | 72029 | 105 | |
229948 | 229948 | 2020-06-11 | Canovanas | Puerto Rico | 72029 | 105 | |
233053 | 233053 | 2020-06-12 | Canovanas | Puerto Rico | 72029 | 105 | |
236158 | 236158 | 2020-06-13 | Canovanas | Puerto Rico | 72029 | 105 | |
239266 | 239266 | 2020-06-14 | Canovanas | Puerto Rico | 72029 | 105 | |
242375 | 242375 | 2020-06-15 | Canovanas | Puerto Rico | 72029 | 105 | |
245487 | 245487 | 2020-06-16 | Canovanas | Puerto Rico | 72029 | 105 | |
248600 | 248600 | 2020-06-17 | Canovanas | Puerto Rico | 72029 | 105 | |
251715 | 251715 | 2020-06-18 | Canovanas | Puerto Rico | 72029 | 105 | |
254830 | 254830 | 2020-06-19 | Canovanas | Puerto Rico | 72029 | 105 | |
257956 | 257956 | 2020-06-20 | Canovanas | Puerto Rico | 72029 | 105 | |
261083 | 261083 | 2020-06-21 | Canovanas | Puerto Rico | 72029 | 105 | |
264211 | 264211 | 2020-06-22 | Canovanas | Puerto Rico | 72029 | 105 | |
267339 | 267339 | 2020-06-23 | Canovanas | Puerto Rico | 72029 | 105 | |
270473 | 270473 | 2020-06-24 | Canovanas | Puerto Rico | 72029 | 105 | |
273612 | 273612 | 2020-06-25 | Canovanas | Puerto Rico | 72029 | 131 | |
276759 | 276759 | 2020-06-26 | Canovanas | Puerto Rico | 72029 | 131 | |
279907 | 279907 | 2020-06-27 | Canovanas | Puerto Rico | 72029 | 131 | |
283053 | 283053 | 2020-06-28 | Canovanas | Puerto Rico | 72029 | 136 | |
286198 | 286198 | 2020-06-29 | Canovanas | Puerto Rico | 72029 | 138 | |
289349 | 289349 | 2020-06-30 | Canovanas | Puerto Rico | 72029 | 144 | |
292501 | 292501 | 2020-07-01 | Canovanas | Puerto Rico | 72029 | 144 | |
295657 | 295657 | 2020-07-02 | Canovanas | Puerto Rico | 72029 | 144 | |
298816 | 298816 | 2020-07-03 | Canovanas | Puerto Rico | 72029 | 147 | |
301980 | 301980 | 2020-07-04 | Canovanas | Puerto Rico | 72029 | 148 | |
305143 | 305143 | 2020-07-05 | Canovanas | Puerto Rico | 72029 | 149 | |
308310 | 308310 | 2020-07-06 | Canovanas | Puerto Rico | 72029 | 154 | |
311479 | 311479 | 2020-07-07 | Canovanas | Puerto Rico | 72029 | 157 | |
314651 | 314651 | 2020-07-08 | Canovanas | Puerto Rico | 72029 | 160 | |
317824 | 317824 | 2020-07-09 | Canovanas | Puerto Rico | 72029 | 163 | |
321002 | 321002 | 2020-07-10 | Canovanas | Puerto Rico | 72029 | 169 | |
324182 | 324182 | 2020-07-11 | Canovanas | Puerto Rico | 72029 | 172 | |
327367 | 327367 | 2020-07-12 | Canovanas | Puerto Rico | 72029 | 178 | |
330553 | 330553 | 2020-07-13 | Canovanas | Puerto Rico | 72029 | 184 | |
333745 | 333745 | 2020-07-14 | Canovanas | Puerto Rico | 72029 | 185 | |
336939 | 336939 | 2020-07-15 | Canovanas | Puerto Rico | 72029 | 188 | |
340136 | 340136 | 2020-07-16 | Canovanas | Puerto Rico | 72029 | 191 | |
343334 | 343334 | 2020-07-17 | Canovanas | Puerto Rico | 72029 | 199 | |
346534 | 346534 | 2020-07-18 | Canovanas | Puerto Rico | 72029 | 205 | |
349734 | 349734 | 2020-07-19 | Canovanas | Puerto Rico | 72029 | 213 | |
352937 | 352937 | 2020-07-20 | Canovanas | Puerto Rico | 72029 | 219 | |
356140 | 356140 | 2020-07-21 | Canovanas | Puerto Rico | 72029 | 225 | |
359344 | 359344 | 2020-07-22 | Canovanas | Puerto Rico | 72029 | 228 | |
362550 | 362550 | 2020-07-23 | Canovanas | Puerto Rico | 72029 | 236 | |
365756 | 365756 | 2020-07-24 | Canovanas | Puerto Rico | 72029 | 242 | |
368965 | 368965 | 2020-07-25 | Canovanas | Puerto Rico | 72029 | 247 | |
372177 | 372177 | 2020-07-26 | Canovanas | Puerto Rico | 72029 | 258 | |
375390 | 375390 | 2020-07-27 | Canovanas | Puerto Rico | 72029 | 263 | |
378606 | 378606 | 2020-07-28 | Canovanas | Puerto Rico | 72029 | 269 | |
381823 | 381823 | 2020-07-29 | Canovanas | Puerto Rico | 72029 | 269 | |
385041 | 385041 | 2020-07-30 | Canovanas | Puerto Rico | 72029 | 280 | |
388258 | 388258 | 2020-07-31 | Canovanas | Puerto Rico | 72029 | 282 | |
391475 | 391475 | 2020-08-01 | Canovanas | Puerto Rico | 72029 | 298 | |
394691 | 394691 | 2020-08-02 | Canovanas | Puerto Rico | 72029 | 302 | |
397908 | 397908 | 2020-08-03 | Canovanas | Puerto Rico | 72029 | 315 | |
401123 | 401123 | 2020-08-04 | Canovanas | Puerto Rico | 72029 | 323 | |
404341 | 404341 | 2020-08-05 | Canovanas | Puerto Rico | 72029 | 331 | |
407560 | 407560 | 2020-08-06 | Canovanas | Puerto Rico | 72029 | 339 | |
410780 | 410780 | 2020-08-07 | Canovanas | Puerto Rico | 72029 | 352 | |
414000 | 414000 | 2020-08-08 | Canovanas | Puerto Rico | 72029 | 359 | |
417221 | 417221 | 2020-08-09 | Canovanas | Puerto Rico | 72029 | 373 | |
420441 | 420441 | 2020-08-10 | Canovanas | Puerto Rico | 72029 | 388 | |
423664 | 423664 | 2020-08-11 | Canovanas | Puerto Rico | 72029 | 404 | |
426887 | 426887 | 2020-08-12 | Canovanas | Puerto Rico | 72029 | 412 |
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);