ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72009 and state = "Puerto Rico" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
117491 | 117491 | 2020-05-05 | Aibonito | Puerto Rico | 72009 | 13 | |
120453 | 120453 | 2020-05-06 | Aibonito | Puerto Rico | 72009 | 13 | |
123430 | 123430 | 2020-05-07 | Aibonito | Puerto Rico | 72009 | 14 | |
126413 | 126413 | 2020-05-08 | Aibonito | Puerto Rico | 72009 | 14 | |
129402 | 129402 | 2020-05-09 | Aibonito | Puerto Rico | 72009 | 14 | |
132391 | 132391 | 2020-05-10 | Aibonito | Puerto Rico | 72009 | 14 | |
135382 | 135382 | 2020-05-11 | Aibonito | Puerto Rico | 72009 | 14 | |
138372 | 138372 | 2020-05-12 | Aibonito | Puerto Rico | 72009 | 15 | |
141368 | 141368 | 2020-05-13 | Aibonito | Puerto Rico | 72009 | 15 | |
144364 | 144364 | 2020-05-14 | Aibonito | Puerto Rico | 72009 | 16 | |
147365 | 147365 | 2020-05-15 | Aibonito | Puerto Rico | 72009 | 17 | |
150372 | 150372 | 2020-05-16 | Aibonito | Puerto Rico | 72009 | 17 | |
153383 | 153383 | 2020-05-17 | Aibonito | Puerto Rico | 72009 | 17 | |
156400 | 156400 | 2020-05-18 | Aibonito | Puerto Rico | 72009 | 17 | |
159421 | 159421 | 2020-05-19 | Aibonito | Puerto Rico | 72009 | 17 | |
162448 | 162448 | 2020-05-20 | Aibonito | Puerto Rico | 72009 | 18 | |
165477 | 165477 | 2020-05-21 | Aibonito | Puerto Rico | 72009 | 18 | |
168513 | 168513 | 2020-05-22 | Aibonito | Puerto Rico | 72009 | 18 | |
171552 | 171552 | 2020-05-23 | Aibonito | Puerto Rico | 72009 | 19 | |
174594 | 174594 | 2020-05-24 | Aibonito | Puerto Rico | 72009 | 19 | |
177638 | 177638 | 2020-05-25 | Aibonito | Puerto Rico | 72009 | 19 | |
180681 | 180681 | 2020-05-26 | Aibonito | Puerto Rico | 72009 | 20 | |
183731 | 183731 | 2020-05-27 | Aibonito | Puerto Rico | 72009 | 20 | |
186788 | 186788 | 2020-05-28 | Aibonito | Puerto Rico | 72009 | 20 | |
189849 | 189849 | 2020-05-29 | Aibonito | Puerto Rico | 72009 | 23 | |
192914 | 192914 | 2020-05-30 | Aibonito | Puerto Rico | 72009 | 23 | |
195983 | 195983 | 2020-05-31 | Aibonito | Puerto Rico | 72009 | 24 | |
199056 | 199056 | 2020-06-01 | Aibonito | Puerto Rico | 72009 | 24 | |
202131 | 202131 | 2020-06-02 | Aibonito | Puerto Rico | 72009 | 25 | |
205208 | 205208 | 2020-06-03 | Aibonito | Puerto Rico | 72009 | 29 | |
208289 | 208289 | 2020-06-04 | Aibonito | Puerto Rico | 72009 | 31 | |
211371 | 211371 | 2020-06-05 | Aibonito | Puerto Rico | 72009 | 32 | |
214457 | 214457 | 2020-06-06 | Aibonito | Puerto Rico | 72009 | 33 | |
217547 | 217547 | 2020-06-07 | Aibonito | Puerto Rico | 72009 | 33 | |
220639 | 220639 | 2020-06-08 | Aibonito | Puerto Rico | 72009 | 33 | |
223734 | 223734 | 2020-06-09 | Aibonito | Puerto Rico | 72009 | 33 | |
226834 | 226834 | 2020-06-10 | Aibonito | Puerto Rico | 72009 | 35 | |
229938 | 229938 | 2020-06-11 | Aibonito | Puerto Rico | 72009 | 35 | |
233043 | 233043 | 2020-06-12 | Aibonito | Puerto Rico | 72009 | 36 | |
236148 | 236148 | 2020-06-13 | Aibonito | Puerto Rico | 72009 | 36 | |
239256 | 239256 | 2020-06-14 | Aibonito | Puerto Rico | 72009 | 36 | |
242365 | 242365 | 2020-06-15 | Aibonito | Puerto Rico | 72009 | 37 | |
245477 | 245477 | 2020-06-16 | Aibonito | Puerto Rico | 72009 | 37 | |
248590 | 248590 | 2020-06-17 | Aibonito | Puerto Rico | 72009 | 38 | |
251705 | 251705 | 2020-06-18 | Aibonito | Puerto Rico | 72009 | 38 | |
254820 | 254820 | 2020-06-19 | Aibonito | Puerto Rico | 72009 | 37 | |
257946 | 257946 | 2020-06-20 | Aibonito | Puerto Rico | 72009 | 39 | |
261073 | 261073 | 2020-06-21 | Aibonito | Puerto Rico | 72009 | 39 | |
264201 | 264201 | 2020-06-22 | Aibonito | Puerto Rico | 72009 | 39 | |
267329 | 267329 | 2020-06-23 | Aibonito | Puerto Rico | 72009 | 41 | |
270463 | 270463 | 2020-06-24 | Aibonito | Puerto Rico | 72009 | 41 | |
273602 | 273602 | 2020-06-25 | Aibonito | Puerto Rico | 72009 | 41 | |
276749 | 276749 | 2020-06-26 | Aibonito | Puerto Rico | 72009 | 41 | |
279897 | 279897 | 2020-06-27 | Aibonito | Puerto Rico | 72009 | 41 | |
283043 | 283043 | 2020-06-28 | Aibonito | Puerto Rico | 72009 | 41 | |
286188 | 286188 | 2020-06-29 | Aibonito | Puerto Rico | 72009 | 42 | |
289339 | 289339 | 2020-06-30 | Aibonito | Puerto Rico | 72009 | 42 | |
292491 | 292491 | 2020-07-01 | Aibonito | Puerto Rico | 72009 | 42 | |
295647 | 295647 | 2020-07-02 | Aibonito | Puerto Rico | 72009 | 42 | |
298806 | 298806 | 2020-07-03 | Aibonito | Puerto Rico | 72009 | 42 | |
301970 | 301970 | 2020-07-04 | Aibonito | Puerto Rico | 72009 | 44 | |
305133 | 305133 | 2020-07-05 | Aibonito | Puerto Rico | 72009 | 45 | |
308300 | 308300 | 2020-07-06 | Aibonito | Puerto Rico | 72009 | 47 | |
311469 | 311469 | 2020-07-07 | Aibonito | Puerto Rico | 72009 | 48 | |
314641 | 314641 | 2020-07-08 | Aibonito | Puerto Rico | 72009 | 48 | |
317814 | 317814 | 2020-07-09 | Aibonito | Puerto Rico | 72009 | 49 | |
320992 | 320992 | 2020-07-10 | Aibonito | Puerto Rico | 72009 | 50 | |
324172 | 324172 | 2020-07-11 | Aibonito | Puerto Rico | 72009 | 51 | |
327357 | 327357 | 2020-07-12 | Aibonito | Puerto Rico | 72009 | 52 | |
330543 | 330543 | 2020-07-13 | Aibonito | Puerto Rico | 72009 | 53 | |
333735 | 333735 | 2020-07-14 | Aibonito | Puerto Rico | 72009 | 53 | |
336929 | 336929 | 2020-07-15 | Aibonito | Puerto Rico | 72009 | 53 | |
340126 | 340126 | 2020-07-16 | Aibonito | Puerto Rico | 72009 | 53 | |
343324 | 343324 | 2020-07-17 | Aibonito | Puerto Rico | 72009 | 55 | |
346524 | 346524 | 2020-07-18 | Aibonito | Puerto Rico | 72009 | 55 | |
349724 | 349724 | 2020-07-19 | Aibonito | Puerto Rico | 72009 | 56 | |
352927 | 352927 | 2020-07-20 | Aibonito | Puerto Rico | 72009 | 60 | |
356130 | 356130 | 2020-07-21 | Aibonito | Puerto Rico | 72009 | 62 | |
359334 | 359334 | 2020-07-22 | Aibonito | Puerto Rico | 72009 | 62 | |
362540 | 362540 | 2020-07-23 | Aibonito | Puerto Rico | 72009 | 64 | |
365746 | 365746 | 2020-07-24 | Aibonito | Puerto Rico | 72009 | 64 | |
368955 | 368955 | 2020-07-25 | Aibonito | Puerto Rico | 72009 | 67 | |
372167 | 372167 | 2020-07-26 | Aibonito | Puerto Rico | 72009 | 70 | |
375380 | 375380 | 2020-07-27 | Aibonito | Puerto Rico | 72009 | 70 | |
378596 | 378596 | 2020-07-28 | Aibonito | Puerto Rico | 72009 | 71 | |
381813 | 381813 | 2020-07-29 | Aibonito | Puerto Rico | 72009 | 71 | |
385031 | 385031 | 2020-07-30 | Aibonito | Puerto Rico | 72009 | 73 | |
388248 | 388248 | 2020-07-31 | Aibonito | Puerto Rico | 72009 | 73 | |
391465 | 391465 | 2020-08-01 | Aibonito | Puerto Rico | 72009 | 76 | |
394681 | 394681 | 2020-08-02 | Aibonito | Puerto Rico | 72009 | 77 | |
397898 | 397898 | 2020-08-03 | Aibonito | Puerto Rico | 72009 | 79 | |
401113 | 401113 | 2020-08-04 | Aibonito | Puerto Rico | 72009 | 79 | |
404331 | 404331 | 2020-08-05 | Aibonito | Puerto Rico | 72009 | 81 | |
407550 | 407550 | 2020-08-06 | Aibonito | Puerto Rico | 72009 | 82 | |
410770 | 410770 | 2020-08-07 | Aibonito | Puerto Rico | 72009 | 83 | |
413990 | 413990 | 2020-08-08 | Aibonito | Puerto Rico | 72009 | 84 | |
417211 | 417211 | 2020-08-09 | Aibonito | Puerto Rico | 72009 | 89 | |
420431 | 420431 | 2020-08-10 | Aibonito | Puerto Rico | 72009 | 89 | |
423654 | 423654 | 2020-08-11 | Aibonito | Puerto Rico | 72009 | 91 | |
426877 | 426877 | 2020-08-12 | Aibonito | Puerto Rico | 72009 | 93 |
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);