ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72137 and state = "Puerto Rico" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
117554 | 117554 | 2020-05-05 | Toa Baja | Puerto Rico | 72137 | 49 | |
120516 | 120516 | 2020-05-06 | Toa Baja | Puerto Rico | 72137 | 50 | |
123493 | 123493 | 2020-05-07 | Toa Baja | Puerto Rico | 72137 | 51 | |
126476 | 126476 | 2020-05-08 | Toa Baja | Puerto Rico | 72137 | 54 | |
129465 | 129465 | 2020-05-09 | Toa Baja | Puerto Rico | 72137 | 54 | |
132454 | 132454 | 2020-05-10 | Toa Baja | Puerto Rico | 72137 | 54 | |
135445 | 135445 | 2020-05-11 | Toa Baja | Puerto Rico | 72137 | 59 | |
138435 | 138435 | 2020-05-12 | Toa Baja | Puerto Rico | 72137 | 61 | |
141431 | 141431 | 2020-05-13 | Toa Baja | Puerto Rico | 72137 | 61 | |
144427 | 144427 | 2020-05-14 | Toa Baja | Puerto Rico | 72137 | 65 | |
147428 | 147428 | 2020-05-15 | Toa Baja | Puerto Rico | 72137 | 67 | |
150436 | 150436 | 2020-05-16 | Toa Baja | Puerto Rico | 72137 | 67 | |
153447 | 153447 | 2020-05-17 | Toa Baja | Puerto Rico | 72137 | 68 | |
156464 | 156464 | 2020-05-18 | Toa Baja | Puerto Rico | 72137 | 69 | |
159485 | 159485 | 2020-05-19 | Toa Baja | Puerto Rico | 72137 | 73 | |
162512 | 162512 | 2020-05-20 | Toa Baja | Puerto Rico | 72137 | 75 | |
165541 | 165541 | 2020-05-21 | Toa Baja | Puerto Rico | 72137 | 75 | |
168577 | 168577 | 2020-05-22 | Toa Baja | Puerto Rico | 72137 | 76 | |
171616 | 171616 | 2020-05-23 | Toa Baja | Puerto Rico | 72137 | 77 | |
174658 | 174658 | 2020-05-24 | Toa Baja | Puerto Rico | 72137 | 81 | |
177702 | 177702 | 2020-05-25 | Toa Baja | Puerto Rico | 72137 | 88 | |
180745 | 180745 | 2020-05-26 | Toa Baja | Puerto Rico | 72137 | 89 | |
183795 | 183795 | 2020-05-27 | Toa Baja | Puerto Rico | 72137 | 91 | |
186852 | 186852 | 2020-05-28 | Toa Baja | Puerto Rico | 72137 | 95 | |
189914 | 189914 | 2020-05-29 | Toa Baja | Puerto Rico | 72137 | 98 | |
192979 | 192979 | 2020-05-30 | Toa Baja | Puerto Rico | 72137 | 99 | |
196048 | 196048 | 2020-05-31 | Toa Baja | Puerto Rico | 72137 | 100 | |
199121 | 199121 | 2020-06-01 | Toa Baja | Puerto Rico | 72137 | 105 | |
202196 | 202196 | 2020-06-02 | Toa Baja | Puerto Rico | 72137 | 105 | |
205273 | 205273 | 2020-06-03 | Toa Baja | Puerto Rico | 72137 | 113 | |
208354 | 208354 | 2020-06-04 | Toa Baja | Puerto Rico | 72137 | 118 | |
211436 | 211436 | 2020-06-05 | Toa Baja | Puerto Rico | 72137 | 126 | |
214522 | 214522 | 2020-06-06 | Toa Baja | Puerto Rico | 72137 | 140 | |
217612 | 217612 | 2020-06-07 | Toa Baja | Puerto Rico | 72137 | 144 | |
220704 | 220704 | 2020-06-08 | Toa Baja | Puerto Rico | 72137 | 146 | |
223799 | 223799 | 2020-06-09 | Toa Baja | Puerto Rico | 72137 | 147 | |
226899 | 226899 | 2020-06-10 | Toa Baja | Puerto Rico | 72137 | 149 | |
230003 | 230003 | 2020-06-11 | Toa Baja | Puerto Rico | 72137 | 147 | |
233108 | 233108 | 2020-06-12 | Toa Baja | Puerto Rico | 72137 | 151 | |
236213 | 236213 | 2020-06-13 | Toa Baja | Puerto Rico | 72137 | 154 | |
239321 | 239321 | 2020-06-14 | Toa Baja | Puerto Rico | 72137 | 154 | |
242430 | 242430 | 2020-06-15 | Toa Baja | Puerto Rico | 72137 | 159 | |
245542 | 245542 | 2020-06-16 | Toa Baja | Puerto Rico | 72137 | 160 | |
248655 | 248655 | 2020-06-17 | Toa Baja | Puerto Rico | 72137 | 159 | |
251770 | 251770 | 2020-06-18 | Toa Baja | Puerto Rico | 72137 | 162 | |
254885 | 254885 | 2020-06-19 | Toa Baja | Puerto Rico | 72137 | 167 | |
258011 | 258011 | 2020-06-20 | Toa Baja | Puerto Rico | 72137 | 169 | |
261138 | 261138 | 2020-06-21 | Toa Baja | Puerto Rico | 72137 | 170 | |
264266 | 264266 | 2020-06-22 | Toa Baja | Puerto Rico | 72137 | 171 | |
267394 | 267394 | 2020-06-23 | Toa Baja | Puerto Rico | 72137 | 171 | |
270528 | 270528 | 2020-06-24 | Toa Baja | Puerto Rico | 72137 | 176 | |
273667 | 273667 | 2020-06-25 | Toa Baja | Puerto Rico | 72137 | 176 | |
276814 | 276814 | 2020-06-26 | Toa Baja | Puerto Rico | 72137 | 177 | |
279962 | 279962 | 2020-06-27 | Toa Baja | Puerto Rico | 72137 | 180 | |
283108 | 283108 | 2020-06-28 | Toa Baja | Puerto Rico | 72137 | 182 | |
286253 | 286253 | 2020-06-29 | Toa Baja | Puerto Rico | 72137 | 185 | |
289404 | 289404 | 2020-06-30 | Toa Baja | Puerto Rico | 72137 | 191 | |
292556 | 292556 | 2020-07-01 | Toa Baja | Puerto Rico | 72137 | 192 | |
295712 | 295712 | 2020-07-02 | Toa Baja | Puerto Rico | 72137 | 195 | |
298871 | 298871 | 2020-07-03 | Toa Baja | Puerto Rico | 72137 | 196 | |
302035 | 302035 | 2020-07-04 | Toa Baja | Puerto Rico | 72137 | 200 | |
305198 | 305198 | 2020-07-05 | Toa Baja | Puerto Rico | 72137 | 200 | |
308365 | 308365 | 2020-07-06 | Toa Baja | Puerto Rico | 72137 | 210 | |
311534 | 311534 | 2020-07-07 | Toa Baja | Puerto Rico | 72137 | 213 | |
314706 | 314706 | 2020-07-08 | Toa Baja | Puerto Rico | 72137 | 213 | |
317879 | 317879 | 2020-07-09 | Toa Baja | Puerto Rico | 72137 | 214 | |
321057 | 321057 | 2020-07-10 | Toa Baja | Puerto Rico | 72137 | 224 | |
324237 | 324237 | 2020-07-11 | Toa Baja | Puerto Rico | 72137 | 225 | |
327422 | 327422 | 2020-07-12 | Toa Baja | Puerto Rico | 72137 | 232 | |
330608 | 330608 | 2020-07-13 | Toa Baja | Puerto Rico | 72137 | 239 | |
333800 | 333800 | 2020-07-14 | Toa Baja | Puerto Rico | 72137 | 240 | |
336994 | 336994 | 2020-07-15 | Toa Baja | Puerto Rico | 72137 | 245 | |
340191 | 340191 | 2020-07-16 | Toa Baja | Puerto Rico | 72137 | 247 | |
343389 | 343389 | 2020-07-17 | Toa Baja | Puerto Rico | 72137 | 251 | |
346589 | 346589 | 2020-07-18 | Toa Baja | Puerto Rico | 72137 | 254 | |
349789 | 349789 | 2020-07-19 | Toa Baja | Puerto Rico | 72137 | 266 | |
352992 | 352992 | 2020-07-20 | Toa Baja | Puerto Rico | 72137 | 276 | |
356195 | 356195 | 2020-07-21 | Toa Baja | Puerto Rico | 72137 | 287 | |
359399 | 359399 | 2020-07-22 | Toa Baja | Puerto Rico | 72137 | 287 | |
362605 | 362605 | 2020-07-23 | Toa Baja | Puerto Rico | 72137 | 296 | |
365811 | 365811 | 2020-07-24 | Toa Baja | Puerto Rico | 72137 | 308 | |
369020 | 369020 | 2020-07-25 | Toa Baja | Puerto Rico | 72137 | 316 | |
372232 | 372232 | 2020-07-26 | Toa Baja | Puerto Rico | 72137 | 330 | |
375445 | 375445 | 2020-07-27 | Toa Baja | Puerto Rico | 72137 | 344 | |
378661 | 378661 | 2020-07-28 | Toa Baja | Puerto Rico | 72137 | 354 | |
381878 | 381878 | 2020-07-29 | Toa Baja | Puerto Rico | 72137 | 364 | |
385096 | 385096 | 2020-07-30 | Toa Baja | Puerto Rico | 72137 | 388 | |
388313 | 388313 | 2020-07-31 | Toa Baja | Puerto Rico | 72137 | 395 | |
391530 | 391530 | 2020-08-01 | Toa Baja | Puerto Rico | 72137 | 419 | |
394746 | 394746 | 2020-08-02 | Toa Baja | Puerto Rico | 72137 | 440 | |
397963 | 397963 | 2020-08-03 | Toa Baja | Puerto Rico | 72137 | 445 | |
401178 | 401178 | 2020-08-04 | Toa Baja | Puerto Rico | 72137 | 456 | |
404396 | 404396 | 2020-08-05 | Toa Baja | Puerto Rico | 72137 | 464 | |
407615 | 407615 | 2020-08-06 | Toa Baja | Puerto Rico | 72137 | 470 | |
410835 | 410835 | 2020-08-07 | Toa Baja | Puerto Rico | 72137 | 494 | |
414055 | 414055 | 2020-08-08 | Toa Baja | Puerto Rico | 72137 | 511 | |
417276 | 417276 | 2020-08-09 | Toa Baja | Puerto Rico | 72137 | 520 | |
420496 | 420496 | 2020-08-10 | Toa Baja | Puerto Rico | 72137 | 543 | |
423719 | 423719 | 2020-08-11 | Toa Baja | Puerto Rico | 72137 | 558 | |
426942 | 426942 | 2020-08-12 | Toa Baja | Puerto Rico | 72137 | 580 |
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);