ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Las Marias" and state = "Puerto Rico" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
117528 | 117528 | 2020-05-05 | Las Marias | Puerto Rico | 72083 | 5 | |
120490 | 120490 | 2020-05-06 | Las Marias | Puerto Rico | 72083 | 5 | |
123467 | 123467 | 2020-05-07 | Las Marias | Puerto Rico | 72083 | 5 | |
126450 | 126450 | 2020-05-08 | Las Marias | Puerto Rico | 72083 | 5 | |
129439 | 129439 | 2020-05-09 | Las Marias | Puerto Rico | 72083 | 5 | |
132428 | 132428 | 2020-05-10 | Las Marias | Puerto Rico | 72083 | 5 | |
135419 | 135419 | 2020-05-11 | Las Marias | Puerto Rico | 72083 | 6 | |
138409 | 138409 | 2020-05-12 | Las Marias | Puerto Rico | 72083 | 6 | |
141405 | 141405 | 2020-05-13 | Las Marias | Puerto Rico | 72083 | 6 | |
144401 | 144401 | 2020-05-14 | Las Marias | Puerto Rico | 72083 | 6 | |
147402 | 147402 | 2020-05-15 | Las Marias | Puerto Rico | 72083 | 6 | |
150409 | 150409 | 2020-05-16 | Las Marias | Puerto Rico | 72083 | 6 | |
153420 | 153420 | 2020-05-17 | Las Marias | Puerto Rico | 72083 | 6 | |
156437 | 156437 | 2020-05-18 | Las Marias | Puerto Rico | 72083 | 7 | |
159458 | 159458 | 2020-05-19 | Las Marias | Puerto Rico | 72083 | 7 | |
162485 | 162485 | 2020-05-20 | Las Marias | Puerto Rico | 72083 | 9 | |
165514 | 165514 | 2020-05-21 | Las Marias | Puerto Rico | 72083 | 9 | |
168550 | 168550 | 2020-05-22 | Las Marias | Puerto Rico | 72083 | 9 | |
171589 | 171589 | 2020-05-23 | Las Marias | Puerto Rico | 72083 | 10 | |
174631 | 174631 | 2020-05-24 | Las Marias | Puerto Rico | 72083 | 11 | |
177675 | 177675 | 2020-05-25 | Las Marias | Puerto Rico | 72083 | 11 | |
180718 | 180718 | 2020-05-26 | Las Marias | Puerto Rico | 72083 | 11 | |
183768 | 183768 | 2020-05-27 | Las Marias | Puerto Rico | 72083 | 11 | |
186825 | 186825 | 2020-05-28 | Las Marias | Puerto Rico | 72083 | 11 | |
189887 | 189887 | 2020-05-29 | Las Marias | Puerto Rico | 72083 | 12 | |
192952 | 192952 | 2020-05-30 | Las Marias | Puerto Rico | 72083 | 12 | |
196021 | 196021 | 2020-05-31 | Las Marias | Puerto Rico | 72083 | 12 | |
199094 | 199094 | 2020-06-01 | Las Marias | Puerto Rico | 72083 | 11 | |
202169 | 202169 | 2020-06-02 | Las Marias | Puerto Rico | 72083 | 11 | |
205246 | 205246 | 2020-06-03 | Las Marias | Puerto Rico | 72083 | 11 | |
208327 | 208327 | 2020-06-04 | Las Marias | Puerto Rico | 72083 | 11 | |
211409 | 211409 | 2020-06-05 | Las Marias | Puerto Rico | 72083 | 11 | |
214495 | 214495 | 2020-06-06 | Las Marias | Puerto Rico | 72083 | 12 | |
217585 | 217585 | 2020-06-07 | Las Marias | Puerto Rico | 72083 | 13 | |
220677 | 220677 | 2020-06-08 | Las Marias | Puerto Rico | 72083 | 13 | |
223772 | 223772 | 2020-06-09 | Las Marias | Puerto Rico | 72083 | 13 | |
226872 | 226872 | 2020-06-10 | Las Marias | Puerto Rico | 72083 | 13 | |
229976 | 229976 | 2020-06-11 | Las Marias | Puerto Rico | 72083 | 13 | |
233081 | 233081 | 2020-06-12 | Las Marias | Puerto Rico | 72083 | 13 | |
236186 | 236186 | 2020-06-13 | Las Marias | Puerto Rico | 72083 | 13 | |
239294 | 239294 | 2020-06-14 | Las Marias | Puerto Rico | 72083 | 13 | |
242403 | 242403 | 2020-06-15 | Las Marias | Puerto Rico | 72083 | 13 | |
245515 | 245515 | 2020-06-16 | Las Marias | Puerto Rico | 72083 | 13 | |
248628 | 248628 | 2020-06-17 | Las Marias | Puerto Rico | 72083 | 13 | |
251743 | 251743 | 2020-06-18 | Las Marias | Puerto Rico | 72083 | 13 | |
254858 | 254858 | 2020-06-19 | Las Marias | Puerto Rico | 72083 | 13 | |
257984 | 257984 | 2020-06-20 | Las Marias | Puerto Rico | 72083 | 13 | |
261111 | 261111 | 2020-06-21 | Las Marias | Puerto Rico | 72083 | 13 | |
264239 | 264239 | 2020-06-22 | Las Marias | Puerto Rico | 72083 | 13 | |
267367 | 267367 | 2020-06-23 | Las Marias | Puerto Rico | 72083 | 13 | |
270501 | 270501 | 2020-06-24 | Las Marias | Puerto Rico | 72083 | 13 | |
273640 | 273640 | 2020-06-25 | Las Marias | Puerto Rico | 72083 | 18 | |
276787 | 276787 | 2020-06-26 | Las Marias | Puerto Rico | 72083 | 18 | |
279935 | 279935 | 2020-06-27 | Las Marias | Puerto Rico | 72083 | 18 | |
283081 | 283081 | 2020-06-28 | Las Marias | Puerto Rico | 72083 | 18 | |
286226 | 286226 | 2020-06-29 | Las Marias | Puerto Rico | 72083 | 18 | |
289377 | 289377 | 2020-06-30 | Las Marias | Puerto Rico | 72083 | 18 | |
292529 | 292529 | 2020-07-01 | Las Marias | Puerto Rico | 72083 | 18 | |
295685 | 295685 | 2020-07-02 | Las Marias | Puerto Rico | 72083 | 20 | |
298844 | 298844 | 2020-07-03 | Las Marias | Puerto Rico | 72083 | 20 | |
302008 | 302008 | 2020-07-04 | Las Marias | Puerto Rico | 72083 | 20 | |
305171 | 305171 | 2020-07-05 | Las Marias | Puerto Rico | 72083 | 20 | |
308338 | 308338 | 2020-07-06 | Las Marias | Puerto Rico | 72083 | 20 | |
311507 | 311507 | 2020-07-07 | Las Marias | Puerto Rico | 72083 | 20 | |
314679 | 314679 | 2020-07-08 | Las Marias | Puerto Rico | 72083 | 20 | |
317852 | 317852 | 2020-07-09 | Las Marias | Puerto Rico | 72083 | 20 | |
321030 | 321030 | 2020-07-10 | Las Marias | Puerto Rico | 72083 | 26 | |
324210 | 324210 | 2020-07-11 | Las Marias | Puerto Rico | 72083 | 27 | |
327395 | 327395 | 2020-07-12 | Las Marias | Puerto Rico | 72083 | 29 | |
330581 | 330581 | 2020-07-13 | Las Marias | Puerto Rico | 72083 | 29 | |
333773 | 333773 | 2020-07-14 | Las Marias | Puerto Rico | 72083 | 29 | |
336967 | 336967 | 2020-07-15 | Las Marias | Puerto Rico | 72083 | 29 | |
340164 | 340164 | 2020-07-16 | Las Marias | Puerto Rico | 72083 | 29 | |
343362 | 343362 | 2020-07-17 | Las Marias | Puerto Rico | 72083 | 31 | |
346562 | 346562 | 2020-07-18 | Las Marias | Puerto Rico | 72083 | 32 | |
349762 | 349762 | 2020-07-19 | Las Marias | Puerto Rico | 72083 | 33 | |
352965 | 352965 | 2020-07-20 | Las Marias | Puerto Rico | 72083 | 34 | |
356168 | 356168 | 2020-07-21 | Las Marias | Puerto Rico | 72083 | 34 | |
359372 | 359372 | 2020-07-22 | Las Marias | Puerto Rico | 72083 | 34 | |
362578 | 362578 | 2020-07-23 | Las Marias | Puerto Rico | 72083 | 36 | |
365784 | 365784 | 2020-07-24 | Las Marias | Puerto Rico | 72083 | 38 | |
368993 | 368993 | 2020-07-25 | Las Marias | Puerto Rico | 72083 | 42 | |
372205 | 372205 | 2020-07-26 | Las Marias | Puerto Rico | 72083 | 42 | |
375418 | 375418 | 2020-07-27 | Las Marias | Puerto Rico | 72083 | 43 | |
378634 | 378634 | 2020-07-28 | Las Marias | Puerto Rico | 72083 | 43 | |
381851 | 381851 | 2020-07-29 | Las Marias | Puerto Rico | 72083 | 46 | |
385069 | 385069 | 2020-07-30 | Las Marias | Puerto Rico | 72083 | 48 | |
388286 | 388286 | 2020-07-31 | Las Marias | Puerto Rico | 72083 | 48 | |
391503 | 391503 | 2020-08-01 | Las Marias | Puerto Rico | 72083 | 52 | |
394719 | 394719 | 2020-08-02 | Las Marias | Puerto Rico | 72083 | 52 | |
397936 | 397936 | 2020-08-03 | Las Marias | Puerto Rico | 72083 | 54 | |
401151 | 401151 | 2020-08-04 | Las Marias | Puerto Rico | 72083 | 55 | |
404369 | 404369 | 2020-08-05 | Las Marias | Puerto Rico | 72083 | 57 | |
407588 | 407588 | 2020-08-06 | Las Marias | Puerto Rico | 72083 | 58 | |
410808 | 410808 | 2020-08-07 | Las Marias | Puerto Rico | 72083 | 58 | |
414028 | 414028 | 2020-08-08 | Las Marias | Puerto Rico | 72083 | 63 | |
417249 | 417249 | 2020-08-09 | Las Marias | Puerto Rico | 72083 | 70 | |
420469 | 420469 | 2020-08-10 | Las Marias | Puerto Rico | 72083 | 72 | |
423692 | 423692 | 2020-08-11 | Las Marias | Puerto Rico | 72083 | 72 | |
426915 | 426915 | 2020-08-12 | Las Marias | Puerto Rico | 72083 | 72 |
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);