ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Loiza" and state = "Puerto Rico" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
117530 | 117530 | 2020-05-05 | Loiza | Puerto Rico | 72087 | 6 | |
120492 | 120492 | 2020-05-06 | Loiza | Puerto Rico | 72087 | 6 | |
123469 | 123469 | 2020-05-07 | Loiza | Puerto Rico | 72087 | 6 | |
126452 | 126452 | 2020-05-08 | Loiza | Puerto Rico | 72087 | 6 | |
129441 | 129441 | 2020-05-09 | Loiza | Puerto Rico | 72087 | 6 | |
132430 | 132430 | 2020-05-10 | Loiza | Puerto Rico | 72087 | 7 | |
135421 | 135421 | 2020-05-11 | Loiza | Puerto Rico | 72087 | 7 | |
138411 | 138411 | 2020-05-12 | Loiza | Puerto Rico | 72087 | 7 | |
141407 | 141407 | 2020-05-13 | Loiza | Puerto Rico | 72087 | 7 | |
144403 | 144403 | 2020-05-14 | Loiza | Puerto Rico | 72087 | 6 | |
147404 | 147404 | 2020-05-15 | Loiza | Puerto Rico | 72087 | 6 | |
150411 | 150411 | 2020-05-16 | Loiza | Puerto Rico | 72087 | 6 | |
153422 | 153422 | 2020-05-17 | Loiza | Puerto Rico | 72087 | 7 | |
156439 | 156439 | 2020-05-18 | Loiza | Puerto Rico | 72087 | 7 | |
159460 | 159460 | 2020-05-19 | Loiza | Puerto Rico | 72087 | 7 | |
162487 | 162487 | 2020-05-20 | Loiza | Puerto Rico | 72087 | 7 | |
165516 | 165516 | 2020-05-21 | Loiza | Puerto Rico | 72087 | 7 | |
168552 | 168552 | 2020-05-22 | Loiza | Puerto Rico | 72087 | 7 | |
171591 | 171591 | 2020-05-23 | Loiza | Puerto Rico | 72087 | 7 | |
174633 | 174633 | 2020-05-24 | Loiza | Puerto Rico | 72087 | 10 | |
177677 | 177677 | 2020-05-25 | Loiza | Puerto Rico | 72087 | 10 | |
180720 | 180720 | 2020-05-26 | Loiza | Puerto Rico | 72087 | 10 | |
183770 | 183770 | 2020-05-27 | Loiza | Puerto Rico | 72087 | 11 | |
186827 | 186827 | 2020-05-28 | Loiza | Puerto Rico | 72087 | 12 | |
189889 | 189889 | 2020-05-29 | Loiza | Puerto Rico | 72087 | 13 | |
192954 | 192954 | 2020-05-30 | Loiza | Puerto Rico | 72087 | 16 | |
196023 | 196023 | 2020-05-31 | Loiza | Puerto Rico | 72087 | 20 | |
199096 | 199096 | 2020-06-01 | Loiza | Puerto Rico | 72087 | 20 | |
202171 | 202171 | 2020-06-02 | Loiza | Puerto Rico | 72087 | 22 | |
205248 | 205248 | 2020-06-03 | Loiza | Puerto Rico | 72087 | 22 | |
208329 | 208329 | 2020-06-04 | Loiza | Puerto Rico | 72087 | 31 | |
211411 | 211411 | 2020-06-05 | Loiza | Puerto Rico | 72087 | 31 | |
214497 | 214497 | 2020-06-06 | Loiza | Puerto Rico | 72087 | 33 | |
217587 | 217587 | 2020-06-07 | Loiza | Puerto Rico | 72087 | 33 | |
220679 | 220679 | 2020-06-08 | Loiza | Puerto Rico | 72087 | 36 | |
223774 | 223774 | 2020-06-09 | Loiza | Puerto Rico | 72087 | 40 | |
226874 | 226874 | 2020-06-10 | Loiza | Puerto Rico | 72087 | 40 | |
229978 | 229978 | 2020-06-11 | Loiza | Puerto Rico | 72087 | 40 | |
233083 | 233083 | 2020-06-12 | Loiza | Puerto Rico | 72087 | 40 | |
236188 | 236188 | 2020-06-13 | Loiza | Puerto Rico | 72087 | 40 | |
239296 | 239296 | 2020-06-14 | Loiza | Puerto Rico | 72087 | 40 | |
242405 | 242405 | 2020-06-15 | Loiza | Puerto Rico | 72087 | 40 | |
245517 | 245517 | 2020-06-16 | Loiza | Puerto Rico | 72087 | 40 | |
248630 | 248630 | 2020-06-17 | Loiza | Puerto Rico | 72087 | 40 | |
251745 | 251745 | 2020-06-18 | Loiza | Puerto Rico | 72087 | 40 | |
254860 | 254860 | 2020-06-19 | Loiza | Puerto Rico | 72087 | 40 | |
257986 | 257986 | 2020-06-20 | Loiza | Puerto Rico | 72087 | 40 | |
261113 | 261113 | 2020-06-21 | Loiza | Puerto Rico | 72087 | 40 | |
264241 | 264241 | 2020-06-22 | Loiza | Puerto Rico | 72087 | 40 | |
267369 | 267369 | 2020-06-23 | Loiza | Puerto Rico | 72087 | 40 | |
270503 | 270503 | 2020-06-24 | Loiza | Puerto Rico | 72087 | 40 | |
273642 | 273642 | 2020-06-25 | Loiza | Puerto Rico | 72087 | 48 | |
276789 | 276789 | 2020-06-26 | Loiza | Puerto Rico | 72087 | 48 | |
279937 | 279937 | 2020-06-27 | Loiza | Puerto Rico | 72087 | 48 | |
283083 | 283083 | 2020-06-28 | Loiza | Puerto Rico | 72087 | 48 | |
286228 | 286228 | 2020-06-29 | Loiza | Puerto Rico | 72087 | 50 | |
289379 | 289379 | 2020-06-30 | Loiza | Puerto Rico | 72087 | 50 | |
292531 | 292531 | 2020-07-01 | Loiza | Puerto Rico | 72087 | 50 | |
295687 | 295687 | 2020-07-02 | Loiza | Puerto Rico | 72087 | 50 | |
298846 | 298846 | 2020-07-03 | Loiza | Puerto Rico | 72087 | 51 | |
302010 | 302010 | 2020-07-04 | Loiza | Puerto Rico | 72087 | 51 | |
305173 | 305173 | 2020-07-05 | Loiza | Puerto Rico | 72087 | 52 | |
308340 | 308340 | 2020-07-06 | Loiza | Puerto Rico | 72087 | 53 | |
311509 | 311509 | 2020-07-07 | Loiza | Puerto Rico | 72087 | 53 | |
314681 | 314681 | 2020-07-08 | Loiza | Puerto Rico | 72087 | 53 | |
317854 | 317854 | 2020-07-09 | Loiza | Puerto Rico | 72087 | 53 | |
321032 | 321032 | 2020-07-10 | Loiza | Puerto Rico | 72087 | 53 | |
324212 | 324212 | 2020-07-11 | Loiza | Puerto Rico | 72087 | 53 | |
327397 | 327397 | 2020-07-12 | Loiza | Puerto Rico | 72087 | 55 | |
330583 | 330583 | 2020-07-13 | Loiza | Puerto Rico | 72087 | 56 | |
333775 | 333775 | 2020-07-14 | Loiza | Puerto Rico | 72087 | 56 | |
336969 | 336969 | 2020-07-15 | Loiza | Puerto Rico | 72087 | 56 | |
340166 | 340166 | 2020-07-16 | Loiza | Puerto Rico | 72087 | 56 | |
343364 | 343364 | 2020-07-17 | Loiza | Puerto Rico | 72087 | 58 | |
346564 | 346564 | 2020-07-18 | Loiza | Puerto Rico | 72087 | 61 | |
349764 | 349764 | 2020-07-19 | Loiza | Puerto Rico | 72087 | 63 | |
352967 | 352967 | 2020-07-20 | Loiza | Puerto Rico | 72087 | 64 | |
356170 | 356170 | 2020-07-21 | Loiza | Puerto Rico | 72087 | 65 | |
359374 | 359374 | 2020-07-22 | Loiza | Puerto Rico | 72087 | 65 | |
362580 | 362580 | 2020-07-23 | Loiza | Puerto Rico | 72087 | 65 | |
365786 | 365786 | 2020-07-24 | Loiza | Puerto Rico | 72087 | 67 | |
368995 | 368995 | 2020-07-25 | Loiza | Puerto Rico | 72087 | 69 | |
372207 | 372207 | 2020-07-26 | Loiza | Puerto Rico | 72087 | 71 | |
375420 | 375420 | 2020-07-27 | Loiza | Puerto Rico | 72087 | 72 | |
378636 | 378636 | 2020-07-28 | Loiza | Puerto Rico | 72087 | 73 | |
381853 | 381853 | 2020-07-29 | Loiza | Puerto Rico | 72087 | 74 | |
385071 | 385071 | 2020-07-30 | Loiza | Puerto Rico | 72087 | 76 | |
388288 | 388288 | 2020-07-31 | Loiza | Puerto Rico | 72087 | 77 | |
391505 | 391505 | 2020-08-01 | Loiza | Puerto Rico | 72087 | 88 | |
394721 | 394721 | 2020-08-02 | Loiza | Puerto Rico | 72087 | 94 | |
397938 | 397938 | 2020-08-03 | Loiza | Puerto Rico | 72087 | 98 | |
401153 | 401153 | 2020-08-04 | Loiza | Puerto Rico | 72087 | 102 | |
404371 | 404371 | 2020-08-05 | Loiza | Puerto Rico | 72087 | 108 | |
407590 | 407590 | 2020-08-06 | Loiza | Puerto Rico | 72087 | 110 | |
410810 | 410810 | 2020-08-07 | Loiza | Puerto Rico | 72087 | 117 | |
414030 | 414030 | 2020-08-08 | Loiza | Puerto Rico | 72087 | 122 | |
417251 | 417251 | 2020-08-09 | Loiza | Puerto Rico | 72087 | 124 | |
420471 | 420471 | 2020-08-10 | Loiza | Puerto Rico | 72087 | 135 | |
423694 | 423694 | 2020-08-11 | Loiza | Puerto Rico | 72087 | 136 | |
426917 | 426917 | 2020-08-12 | Loiza | Puerto Rico | 72087 | 136 |
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);