ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Las Piedras" and state = "Puerto Rico" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
117529 | 117529 | 2020-05-05 | Las Piedras | Puerto Rico | 72085 | 12 | |
120491 | 120491 | 2020-05-06 | Las Piedras | Puerto Rico | 72085 | 12 | |
123468 | 123468 | 2020-05-07 | Las Piedras | Puerto Rico | 72085 | 12 | |
126451 | 126451 | 2020-05-08 | Las Piedras | Puerto Rico | 72085 | 13 | |
129440 | 129440 | 2020-05-09 | Las Piedras | Puerto Rico | 72085 | 13 | |
132429 | 132429 | 2020-05-10 | Las Piedras | Puerto Rico | 72085 | 13 | |
135420 | 135420 | 2020-05-11 | Las Piedras | Puerto Rico | 72085 | 13 | |
138410 | 138410 | 2020-05-12 | Las Piedras | Puerto Rico | 72085 | 13 | |
141406 | 141406 | 2020-05-13 | Las Piedras | Puerto Rico | 72085 | 13 | |
144402 | 144402 | 2020-05-14 | Las Piedras | Puerto Rico | 72085 | 15 | |
147403 | 147403 | 2020-05-15 | Las Piedras | Puerto Rico | 72085 | 17 | |
150410 | 150410 | 2020-05-16 | Las Piedras | Puerto Rico | 72085 | 17 | |
153421 | 153421 | 2020-05-17 | Las Piedras | Puerto Rico | 72085 | 18 | |
156438 | 156438 | 2020-05-18 | Las Piedras | Puerto Rico | 72085 | 19 | |
159459 | 159459 | 2020-05-19 | Las Piedras | Puerto Rico | 72085 | 21 | |
162486 | 162486 | 2020-05-20 | Las Piedras | Puerto Rico | 72085 | 22 | |
165515 | 165515 | 2020-05-21 | Las Piedras | Puerto Rico | 72085 | 23 | |
168551 | 168551 | 2020-05-22 | Las Piedras | Puerto Rico | 72085 | 24 | |
171590 | 171590 | 2020-05-23 | Las Piedras | Puerto Rico | 72085 | 24 | |
174632 | 174632 | 2020-05-24 | Las Piedras | Puerto Rico | 72085 | 24 | |
177676 | 177676 | 2020-05-25 | Las Piedras | Puerto Rico | 72085 | 25 | |
180719 | 180719 | 2020-05-26 | Las Piedras | Puerto Rico | 72085 | 25 | |
183769 | 183769 | 2020-05-27 | Las Piedras | Puerto Rico | 72085 | 25 | |
186826 | 186826 | 2020-05-28 | Las Piedras | Puerto Rico | 72085 | 25 | |
189888 | 189888 | 2020-05-29 | Las Piedras | Puerto Rico | 72085 | 25 | |
192953 | 192953 | 2020-05-30 | Las Piedras | Puerto Rico | 72085 | 25 | |
196022 | 196022 | 2020-05-31 | Las Piedras | Puerto Rico | 72085 | 25 | |
199095 | 199095 | 2020-06-01 | Las Piedras | Puerto Rico | 72085 | 25 | |
202170 | 202170 | 2020-06-02 | Las Piedras | Puerto Rico | 72085 | 26 | |
205247 | 205247 | 2020-06-03 | Las Piedras | Puerto Rico | 72085 | 26 | |
208328 | 208328 | 2020-06-04 | Las Piedras | Puerto Rico | 72085 | 32 | |
211410 | 211410 | 2020-06-05 | Las Piedras | Puerto Rico | 72085 | 32 | |
214496 | 214496 | 2020-06-06 | Las Piedras | Puerto Rico | 72085 | 36 | |
217586 | 217586 | 2020-06-07 | Las Piedras | Puerto Rico | 72085 | 37 | |
220678 | 220678 | 2020-06-08 | Las Piedras | Puerto Rico | 72085 | 37 | |
223773 | 223773 | 2020-06-09 | Las Piedras | Puerto Rico | 72085 | 37 | |
226873 | 226873 | 2020-06-10 | Las Piedras | Puerto Rico | 72085 | 42 | |
229977 | 229977 | 2020-06-11 | Las Piedras | Puerto Rico | 72085 | 41 | |
233082 | 233082 | 2020-06-12 | Las Piedras | Puerto Rico | 72085 | 42 | |
236187 | 236187 | 2020-06-13 | Las Piedras | Puerto Rico | 72085 | 42 | |
239295 | 239295 | 2020-06-14 | Las Piedras | Puerto Rico | 72085 | 44 | |
242404 | 242404 | 2020-06-15 | Las Piedras | Puerto Rico | 72085 | 44 | |
245516 | 245516 | 2020-06-16 | Las Piedras | Puerto Rico | 72085 | 44 | |
248629 | 248629 | 2020-06-17 | Las Piedras | Puerto Rico | 72085 | 45 | |
251744 | 251744 | 2020-06-18 | Las Piedras | Puerto Rico | 72085 | 45 | |
254859 | 254859 | 2020-06-19 | Las Piedras | Puerto Rico | 72085 | 45 | |
257985 | 257985 | 2020-06-20 | Las Piedras | Puerto Rico | 72085 | 47 | |
261112 | 261112 | 2020-06-21 | Las Piedras | Puerto Rico | 72085 | 47 | |
264240 | 264240 | 2020-06-22 | Las Piedras | Puerto Rico | 72085 | 48 | |
267368 | 267368 | 2020-06-23 | Las Piedras | Puerto Rico | 72085 | 49 | |
270502 | 270502 | 2020-06-24 | Las Piedras | Puerto Rico | 72085 | 62 | |
273641 | 273641 | 2020-06-25 | Las Piedras | Puerto Rico | 72085 | 63 | |
276788 | 276788 | 2020-06-26 | Las Piedras | Puerto Rico | 72085 | 64 | |
279936 | 279936 | 2020-06-27 | Las Piedras | Puerto Rico | 72085 | 65 | |
283082 | 283082 | 2020-06-28 | Las Piedras | Puerto Rico | 72085 | 66 | |
286227 | 286227 | 2020-06-29 | Las Piedras | Puerto Rico | 72085 | 68 | |
289378 | 289378 | 2020-06-30 | Las Piedras | Puerto Rico | 72085 | 69 | |
292530 | 292530 | 2020-07-01 | Las Piedras | Puerto Rico | 72085 | 70 | |
295686 | 295686 | 2020-07-02 | Las Piedras | Puerto Rico | 72085 | 73 | |
298845 | 298845 | 2020-07-03 | Las Piedras | Puerto Rico | 72085 | 74 | |
302009 | 302009 | 2020-07-04 | Las Piedras | Puerto Rico | 72085 | 74 | |
305172 | 305172 | 2020-07-05 | Las Piedras | Puerto Rico | 72085 | 76 | |
308339 | 308339 | 2020-07-06 | Las Piedras | Puerto Rico | 72085 | 85 | |
311508 | 311508 | 2020-07-07 | Las Piedras | Puerto Rico | 72085 | 87 | |
314680 | 314680 | 2020-07-08 | Las Piedras | Puerto Rico | 72085 | 87 | |
317853 | 317853 | 2020-07-09 | Las Piedras | Puerto Rico | 72085 | 87 | |
321031 | 321031 | 2020-07-10 | Las Piedras | Puerto Rico | 72085 | 89 | |
324211 | 324211 | 2020-07-11 | Las Piedras | Puerto Rico | 72085 | 90 | |
327396 | 327396 | 2020-07-12 | Las Piedras | Puerto Rico | 72085 | 93 | |
330582 | 330582 | 2020-07-13 | Las Piedras | Puerto Rico | 72085 | 95 | |
333774 | 333774 | 2020-07-14 | Las Piedras | Puerto Rico | 72085 | 96 | |
336968 | 336968 | 2020-07-15 | Las Piedras | Puerto Rico | 72085 | 97 | |
340165 | 340165 | 2020-07-16 | Las Piedras | Puerto Rico | 72085 | 97 | |
343363 | 343363 | 2020-07-17 | Las Piedras | Puerto Rico | 72085 | 100 | |
346563 | 346563 | 2020-07-18 | Las Piedras | Puerto Rico | 72085 | 101 | |
349763 | 349763 | 2020-07-19 | Las Piedras | Puerto Rico | 72085 | 103 | |
352966 | 352966 | 2020-07-20 | Las Piedras | Puerto Rico | 72085 | 106 | |
356169 | 356169 | 2020-07-21 | Las Piedras | Puerto Rico | 72085 | 107 | |
359373 | 359373 | 2020-07-22 | Las Piedras | Puerto Rico | 72085 | 107 | |
362579 | 362579 | 2020-07-23 | Las Piedras | Puerto Rico | 72085 | 109 | |
365785 | 365785 | 2020-07-24 | Las Piedras | Puerto Rico | 72085 | 113 | |
368994 | 368994 | 2020-07-25 | Las Piedras | Puerto Rico | 72085 | 116 | |
372206 | 372206 | 2020-07-26 | Las Piedras | Puerto Rico | 72085 | 119 | |
375419 | 375419 | 2020-07-27 | Las Piedras | Puerto Rico | 72085 | 120 | |
378635 | 378635 | 2020-07-28 | Las Piedras | Puerto Rico | 72085 | 120 | |
381852 | 381852 | 2020-07-29 | Las Piedras | Puerto Rico | 72085 | 120 | |
385070 | 385070 | 2020-07-30 | Las Piedras | Puerto Rico | 72085 | 123 | |
388287 | 388287 | 2020-07-31 | Las Piedras | Puerto Rico | 72085 | 125 | |
391504 | 391504 | 2020-08-01 | Las Piedras | Puerto Rico | 72085 | 127 | |
394720 | 394720 | 2020-08-02 | Las Piedras | Puerto Rico | 72085 | 130 | |
397937 | 397937 | 2020-08-03 | Las Piedras | Puerto Rico | 72085 | 133 | |
401152 | 401152 | 2020-08-04 | Las Piedras | Puerto Rico | 72085 | 134 | |
404370 | 404370 | 2020-08-05 | Las Piedras | Puerto Rico | 72085 | 136 | |
407589 | 407589 | 2020-08-06 | Las Piedras | Puerto Rico | 72085 | 138 | |
410809 | 410809 | 2020-08-07 | Las Piedras | Puerto Rico | 72085 | 141 | |
414029 | 414029 | 2020-08-08 | Las Piedras | Puerto Rico | 72085 | 147 | |
417250 | 417250 | 2020-08-09 | Las Piedras | Puerto Rico | 72085 | 151 | |
420470 | 420470 | 2020-08-10 | Las Piedras | Puerto Rico | 72085 | 158 | |
423693 | 423693 | 2020-08-11 | Las Piedras | Puerto Rico | 72085 | 163 | |
426916 | 426916 | 2020-08-12 | Las Piedras | Puerto Rico | 72085 | 168 |
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);