ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72013 and state = "Puerto Rico" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
117493 | 117493 | 2020-05-05 | Arecibo | Puerto Rico | 72013 | 43 | |
120455 | 120455 | 2020-05-06 | Arecibo | Puerto Rico | 72013 | 43 | |
123432 | 123432 | 2020-05-07 | Arecibo | Puerto Rico | 72013 | 43 | |
126415 | 126415 | 2020-05-08 | Arecibo | Puerto Rico | 72013 | 47 | |
129404 | 129404 | 2020-05-09 | Arecibo | Puerto Rico | 72013 | 48 | |
132393 | 132393 | 2020-05-10 | Arecibo | Puerto Rico | 72013 | 49 | |
135384 | 135384 | 2020-05-11 | Arecibo | Puerto Rico | 72013 | 49 | |
138374 | 138374 | 2020-05-12 | Arecibo | Puerto Rico | 72013 | 49 | |
141370 | 141370 | 2020-05-13 | Arecibo | Puerto Rico | 72013 | 49 | |
144366 | 144366 | 2020-05-14 | Arecibo | Puerto Rico | 72013 | 49 | |
147367 | 147367 | 2020-05-15 | Arecibo | Puerto Rico | 72013 | 50 | |
150374 | 150374 | 2020-05-16 | Arecibo | Puerto Rico | 72013 | 51 | |
153385 | 153385 | 2020-05-17 | Arecibo | Puerto Rico | 72013 | 51 | |
156402 | 156402 | 2020-05-18 | Arecibo | Puerto Rico | 72013 | 51 | |
159423 | 159423 | 2020-05-19 | Arecibo | Puerto Rico | 72013 | 51 | |
162450 | 162450 | 2020-05-20 | Arecibo | Puerto Rico | 72013 | 51 | |
165479 | 165479 | 2020-05-21 | Arecibo | Puerto Rico | 72013 | 51 | |
168515 | 168515 | 2020-05-22 | Arecibo | Puerto Rico | 72013 | 54 | |
171554 | 171554 | 2020-05-23 | Arecibo | Puerto Rico | 72013 | 55 | |
174596 | 174596 | 2020-05-24 | Arecibo | Puerto Rico | 72013 | 55 | |
177640 | 177640 | 2020-05-25 | Arecibo | Puerto Rico | 72013 | 56 | |
180683 | 180683 | 2020-05-26 | Arecibo | Puerto Rico | 72013 | 58 | |
183733 | 183733 | 2020-05-27 | Arecibo | Puerto Rico | 72013 | 59 | |
186790 | 186790 | 2020-05-28 | Arecibo | Puerto Rico | 72013 | 60 | |
189851 | 189851 | 2020-05-29 | Arecibo | Puerto Rico | 72013 | 60 | |
192916 | 192916 | 2020-05-30 | Arecibo | Puerto Rico | 72013 | 61 | |
195985 | 195985 | 2020-05-31 | Arecibo | Puerto Rico | 72013 | 64 | |
199058 | 199058 | 2020-06-01 | Arecibo | Puerto Rico | 72013 | 64 | |
202133 | 202133 | 2020-06-02 | Arecibo | Puerto Rico | 72013 | 64 | |
205210 | 205210 | 2020-06-03 | Arecibo | Puerto Rico | 72013 | 64 | |
208291 | 208291 | 2020-06-04 | Arecibo | Puerto Rico | 72013 | 77 | |
211373 | 211373 | 2020-06-05 | Arecibo | Puerto Rico | 72013 | 77 | |
214459 | 214459 | 2020-06-06 | Arecibo | Puerto Rico | 72013 | 80 | |
217549 | 217549 | 2020-06-07 | Arecibo | Puerto Rico | 72013 | 81 | |
220641 | 220641 | 2020-06-08 | Arecibo | Puerto Rico | 72013 | 84 | |
223736 | 223736 | 2020-06-09 | Arecibo | Puerto Rico | 72013 | 88 | |
226836 | 226836 | 2020-06-10 | Arecibo | Puerto Rico | 72013 | 93 | |
229940 | 229940 | 2020-06-11 | Arecibo | Puerto Rico | 72013 | 93 | |
233045 | 233045 | 2020-06-12 | Arecibo | Puerto Rico | 72013 | 95 | |
236150 | 236150 | 2020-06-13 | Arecibo | Puerto Rico | 72013 | 101 | |
239258 | 239258 | 2020-06-14 | Arecibo | Puerto Rico | 72013 | 100 | |
242367 | 242367 | 2020-06-15 | Arecibo | Puerto Rico | 72013 | 102 | |
245479 | 245479 | 2020-06-16 | Arecibo | Puerto Rico | 72013 | 103 | |
248592 | 248592 | 2020-06-17 | Arecibo | Puerto Rico | 72013 | 104 | |
251707 | 251707 | 2020-06-18 | Arecibo | Puerto Rico | 72013 | 105 | |
254822 | 254822 | 2020-06-19 | Arecibo | Puerto Rico | 72013 | 108 | |
257948 | 257948 | 2020-06-20 | Arecibo | Puerto Rico | 72013 | 112 | |
261075 | 261075 | 2020-06-21 | Arecibo | Puerto Rico | 72013 | 113 | |
264203 | 264203 | 2020-06-22 | Arecibo | Puerto Rico | 72013 | 113 | |
267331 | 267331 | 2020-06-23 | Arecibo | Puerto Rico | 72013 | 115 | |
270465 | 270465 | 2020-06-24 | Arecibo | Puerto Rico | 72013 | 117 | |
273604 | 273604 | 2020-06-25 | Arecibo | Puerto Rico | 72013 | 119 | |
276751 | 276751 | 2020-06-26 | Arecibo | Puerto Rico | 72013 | 119 | |
279899 | 279899 | 2020-06-27 | Arecibo | Puerto Rico | 72013 | 120 | |
283045 | 283045 | 2020-06-28 | Arecibo | Puerto Rico | 72013 | 122 | |
286190 | 286190 | 2020-06-29 | Arecibo | Puerto Rico | 72013 | 124 | |
289341 | 289341 | 2020-06-30 | Arecibo | Puerto Rico | 72013 | 127 | |
292493 | 292493 | 2020-07-01 | Arecibo | Puerto Rico | 72013 | 128 | |
295649 | 295649 | 2020-07-02 | Arecibo | Puerto Rico | 72013 | 128 | |
298808 | 298808 | 2020-07-03 | Arecibo | Puerto Rico | 72013 | 130 | |
301972 | 301972 | 2020-07-04 | Arecibo | Puerto Rico | 72013 | 132 | |
305135 | 305135 | 2020-07-05 | Arecibo | Puerto Rico | 72013 | 134 | |
308302 | 308302 | 2020-07-06 | Arecibo | Puerto Rico | 72013 | 140 | |
311471 | 311471 | 2020-07-07 | Arecibo | Puerto Rico | 72013 | 140 | |
314643 | 314643 | 2020-07-08 | Arecibo | Puerto Rico | 72013 | 142 | |
317816 | 317816 | 2020-07-09 | Arecibo | Puerto Rico | 72013 | 143 | |
320994 | 320994 | 2020-07-10 | Arecibo | Puerto Rico | 72013 | 147 | |
324174 | 324174 | 2020-07-11 | Arecibo | Puerto Rico | 72013 | 148 | |
327359 | 327359 | 2020-07-12 | Arecibo | Puerto Rico | 72013 | 151 | |
330545 | 330545 | 2020-07-13 | Arecibo | Puerto Rico | 72013 | 162 | |
333737 | 333737 | 2020-07-14 | Arecibo | Puerto Rico | 72013 | 162 | |
336931 | 336931 | 2020-07-15 | Arecibo | Puerto Rico | 72013 | 161 | |
340128 | 340128 | 2020-07-16 | Arecibo | Puerto Rico | 72013 | 167 | |
343326 | 343326 | 2020-07-17 | Arecibo | Puerto Rico | 72013 | 172 | |
346526 | 346526 | 2020-07-18 | Arecibo | Puerto Rico | 72013 | 174 | |
349726 | 349726 | 2020-07-19 | Arecibo | Puerto Rico | 72013 | 182 | |
352929 | 352929 | 2020-07-20 | Arecibo | Puerto Rico | 72013 | 186 | |
356132 | 356132 | 2020-07-21 | Arecibo | Puerto Rico | 72013 | 189 | |
359336 | 359336 | 2020-07-22 | Arecibo | Puerto Rico | 72013 | 193 | |
362542 | 362542 | 2020-07-23 | Arecibo | Puerto Rico | 72013 | 202 | |
365748 | 365748 | 2020-07-24 | Arecibo | Puerto Rico | 72013 | 208 | |
368957 | 368957 | 2020-07-25 | Arecibo | Puerto Rico | 72013 | 224 | |
372169 | 372169 | 2020-07-26 | Arecibo | Puerto Rico | 72013 | 227 | |
375382 | 375382 | 2020-07-27 | Arecibo | Puerto Rico | 72013 | 228 | |
378598 | 378598 | 2020-07-28 | Arecibo | Puerto Rico | 72013 | 229 | |
381815 | 381815 | 2020-07-29 | Arecibo | Puerto Rico | 72013 | 230 | |
385033 | 385033 | 2020-07-30 | Arecibo | Puerto Rico | 72013 | 237 | |
388250 | 388250 | 2020-07-31 | Arecibo | Puerto Rico | 72013 | 240 | |
391467 | 391467 | 2020-08-01 | Arecibo | Puerto Rico | 72013 | 254 | |
394683 | 394683 | 2020-08-02 | Arecibo | Puerto Rico | 72013 | 260 | |
397900 | 397900 | 2020-08-03 | Arecibo | Puerto Rico | 72013 | 262 | |
401115 | 401115 | 2020-08-04 | Arecibo | Puerto Rico | 72013 | 269 | |
404333 | 404333 | 2020-08-05 | Arecibo | Puerto Rico | 72013 | 277 | |
407552 | 407552 | 2020-08-06 | Arecibo | Puerto Rico | 72013 | 280 | |
410772 | 410772 | 2020-08-07 | Arecibo | Puerto Rico | 72013 | 287 | |
413992 | 413992 | 2020-08-08 | Arecibo | Puerto Rico | 72013 | 301 | |
417213 | 417213 | 2020-08-09 | Arecibo | Puerto Rico | 72013 | 312 | |
420433 | 420433 | 2020-08-10 | Arecibo | Puerto Rico | 72013 | 324 | |
423656 | 423656 | 2020-08-11 | Arecibo | Puerto Rico | 72013 | 336 | |
426879 | 426879 | 2020-08-12 | Arecibo | Puerto Rico | 72013 | 341 |
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);