ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,704 rows where state = "Rhode Island" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 6
- Unknown 788
- Washington 764
- Bristol 763
- Kent 763
- Newport 763
- Providence 763
state 1
- Rhode Island · 4,604 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449886 | 2449886 | 2022-04-27 | Unknown | Rhode Island | 27829 | 8 | |
2449887 | 2449887 | 2022-04-27 | Washington | Rhode Island | 44009 | 33299 | 224 |
2446625 | 2446625 | 2022-04-26 | Bristol | Rhode Island | 44001 | 13810 | 169 |
2446626 | 2446626 | 2022-04-26 | Kent | Rhode Island | 44003 | 49278 | 513 |
2446627 | 2446627 | 2022-04-26 | Newport | Rhode Island | 44005 | 20388 | 91 |
2446628 | 2446628 | 2022-04-26 | Providence | Rhode Island | 44007 | 223474 | 2527 |
2446629 | 2446629 | 2022-04-26 | Unknown | Rhode Island | 29797 | 14 | |
2446630 | 2446630 | 2022-04-26 | Washington | Rhode Island | 44009 | 32976 | 224 |
2443370 | 2443370 | 2022-04-25 | Bristol | Rhode Island | 44001 | 13810 | 169 |
2443371 | 2443371 | 2022-04-25 | Kent | Rhode Island | 44003 | 49278 | 513 |
2443372 | 2443372 | 2022-04-25 | Newport | Rhode Island | 44005 | 20388 | 91 |
2443373 | 2443373 | 2022-04-25 | Providence | Rhode Island | 44007 | 223474 | 2527 |
2443374 | 2443374 | 2022-04-25 | Unknown | Rhode Island | 29308 | 11 | |
2443375 | 2443375 | 2022-04-25 | Washington | Rhode Island | 44009 | 32976 | 224 |
2440114 | 2440114 | 2022-04-24 | Bristol | Rhode Island | 44001 | 13810 | 169 |
2440115 | 2440115 | 2022-04-24 | Kent | Rhode Island | 44003 | 49278 | 513 |
2440116 | 2440116 | 2022-04-24 | Newport | Rhode Island | 44005 | 20388 | 91 |
2440117 | 2440117 | 2022-04-24 | Providence | Rhode Island | 44007 | 223474 | 2527 |
2440118 | 2440118 | 2022-04-24 | Unknown | Rhode Island | 28320 | 8 | |
2440119 | 2440119 | 2022-04-24 | Washington | Rhode Island | 44009 | 32976 | 224 |
2436858 | 2436858 | 2022-04-23 | Bristol | Rhode Island | 44001 | 13810 | 169 |
2436859 | 2436859 | 2022-04-23 | Kent | Rhode Island | 44003 | 49278 | 513 |
2436860 | 2436860 | 2022-04-23 | Newport | Rhode Island | 44005 | 20388 | 91 |
2436861 | 2436861 | 2022-04-23 | Providence | Rhode Island | 44007 | 223474 | 2527 |
2436862 | 2436862 | 2022-04-23 | Unknown | Rhode Island | 28320 | 8 | |
2436863 | 2436863 | 2022-04-23 | Washington | Rhode Island | 44009 | 32976 | 224 |
2433602 | 2433602 | 2022-04-22 | Bristol | Rhode Island | 44001 | 13810 | 169 |
2433603 | 2433603 | 2022-04-22 | Kent | Rhode Island | 44003 | 49278 | 513 |
2433604 | 2433604 | 2022-04-22 | Newport | Rhode Island | 44005 | 20388 | 91 |
2433605 | 2433605 | 2022-04-22 | Providence | Rhode Island | 44007 | 223474 | 2527 |
2433606 | 2433606 | 2022-04-22 | Unknown | Rhode Island | 28320 | 8 | |
2433607 | 2433607 | 2022-04-22 | Washington | Rhode Island | 44009 | 32976 | 224 |
2430346 | 2430346 | 2022-04-21 | Bristol | Rhode Island | 44001 | 13810 | 169 |
2430347 | 2430347 | 2022-04-21 | Kent | Rhode Island | 44003 | 49278 | 513 |
2430348 | 2430348 | 2022-04-21 | Newport | Rhode Island | 44005 | 20388 | 91 |
2430349 | 2430349 | 2022-04-21 | Providence | Rhode Island | 44007 | 223474 | 2527 |
2430350 | 2430350 | 2022-04-21 | Unknown | Rhode Island | 27976 | 8 | |
2430351 | 2430351 | 2022-04-21 | Washington | Rhode Island | 44009 | 32976 | 224 |
2427090 | 2427090 | 2022-04-20 | Bristol | Rhode Island | 44001 | 13810 | 169 |
2427091 | 2427091 | 2022-04-20 | Kent | Rhode Island | 44003 | 49278 | 513 |
2427092 | 2427092 | 2022-04-20 | Newport | Rhode Island | 44005 | 20388 | 91 |
2427093 | 2427093 | 2022-04-20 | Providence | Rhode Island | 44007 | 223474 | 2527 |
2427094 | 2427094 | 2022-04-20 | Unknown | Rhode Island | 27487 | 8 | |
2427095 | 2427095 | 2022-04-20 | Washington | Rhode Island | 44009 | 32976 | 224 |
2423834 | 2423834 | 2022-04-19 | Bristol | Rhode Island | 44001 | 13655 | 169 |
2423835 | 2423835 | 2022-04-19 | Kent | Rhode Island | 44003 | 48865 | 513 |
2423836 | 2423836 | 2022-04-19 | Newport | Rhode Island | 44005 | 20186 | 91 |
2423837 | 2423837 | 2022-04-19 | Providence | Rhode Island | 44007 | 222113 | 2525 |
2423838 | 2423838 | 2022-04-19 | Unknown | Rhode Island | 29609 | 10 | |
2423839 | 2423839 | 2022-04-19 | Washington | Rhode Island | 44009 | 32667 | 224 |
2420578 | 2420578 | 2022-04-18 | Bristol | Rhode Island | 44001 | 13655 | 169 |
2420579 | 2420579 | 2022-04-18 | Kent | Rhode Island | 44003 | 48865 | 513 |
2420580 | 2420580 | 2022-04-18 | Newport | Rhode Island | 44005 | 20186 | 91 |
2420581 | 2420581 | 2022-04-18 | Providence | Rhode Island | 44007 | 222113 | 2525 |
2420582 | 2420582 | 2022-04-18 | Unknown | Rhode Island | 29254 | 7 | |
2420583 | 2420583 | 2022-04-18 | Washington | Rhode Island | 44009 | 32667 | 224 |
2417322 | 2417322 | 2022-04-17 | Bristol | Rhode Island | 44001 | 13655 | 169 |
2417323 | 2417323 | 2022-04-17 | Kent | Rhode Island | 44003 | 48865 | 513 |
2417324 | 2417324 | 2022-04-17 | Newport | Rhode Island | 44005 | 20186 | 91 |
2417325 | 2417325 | 2022-04-17 | Providence | Rhode Island | 44007 | 222113 | 2525 |
2417326 | 2417326 | 2022-04-17 | Unknown | Rhode Island | 28394 | 5 | |
2417327 | 2417327 | 2022-04-17 | Washington | Rhode Island | 44009 | 32667 | 224 |
2414066 | 2414066 | 2022-04-16 | Bristol | Rhode Island | 44001 | 13655 | 169 |
2414067 | 2414067 | 2022-04-16 | Kent | Rhode Island | 44003 | 48865 | 513 |
2414068 | 2414068 | 2022-04-16 | Newport | Rhode Island | 44005 | 20186 | 91 |
2414069 | 2414069 | 2022-04-16 | Providence | Rhode Island | 44007 | 222113 | 2525 |
2414070 | 2414070 | 2022-04-16 | Unknown | Rhode Island | 28394 | 5 | |
2414071 | 2414071 | 2022-04-16 | Washington | Rhode Island | 44009 | 32667 | 224 |
2410810 | 2410810 | 2022-04-15 | Bristol | Rhode Island | 44001 | 13655 | 169 |
2410811 | 2410811 | 2022-04-15 | Kent | Rhode Island | 44003 | 48865 | 513 |
2410812 | 2410812 | 2022-04-15 | Newport | Rhode Island | 44005 | 20186 | 91 |
2410813 | 2410813 | 2022-04-15 | Providence | Rhode Island | 44007 | 222113 | 2525 |
2410814 | 2410814 | 2022-04-15 | Unknown | Rhode Island | 28394 | 5 | |
2410815 | 2410815 | 2022-04-15 | Washington | Rhode Island | 44009 | 32667 | 224 |
2407554 | 2407554 | 2022-04-14 | Bristol | Rhode Island | 44001 | 13655 | 169 |
2407555 | 2407555 | 2022-04-14 | Kent | Rhode Island | 44003 | 48865 | 513 |
2407556 | 2407556 | 2022-04-14 | Newport | Rhode Island | 44005 | 20186 | 91 |
2407557 | 2407557 | 2022-04-14 | Providence | Rhode Island | 44007 | 222113 | 2525 |
2407558 | 2407558 | 2022-04-14 | Unknown | Rhode Island | 28062 | 5 | |
2407559 | 2407559 | 2022-04-14 | Washington | Rhode Island | 44009 | 32667 | 224 |
2404298 | 2404298 | 2022-04-13 | Bristol | Rhode Island | 44001 | 13655 | 169 |
2404299 | 2404299 | 2022-04-13 | Kent | Rhode Island | 44003 | 48865 | 513 |
2404300 | 2404300 | 2022-04-13 | Newport | Rhode Island | 44005 | 20186 | 91 |
2404301 | 2404301 | 2022-04-13 | Providence | Rhode Island | 44007 | 222113 | 2525 |
2404302 | 2404302 | 2022-04-13 | Unknown | Rhode Island | 27523 | 5 | |
2404303 | 2404303 | 2022-04-13 | Washington | Rhode Island | 44009 | 32667 | 224 |
2401043 | 2401043 | 2022-04-12 | Bristol | Rhode Island | 44001 | 13538 | 169 |
2401044 | 2401044 | 2022-04-12 | Kent | Rhode Island | 44003 | 48495 | 512 |
2401045 | 2401045 | 2022-04-12 | Newport | Rhode Island | 44005 | 19986 | 89 |
2401046 | 2401046 | 2022-04-12 | Providence | Rhode Island | 44007 | 221007 | 2522 |
2401047 | 2401047 | 2022-04-12 | Unknown | Rhode Island | 29242 | 11 | |
2401048 | 2401048 | 2022-04-12 | Washington | Rhode Island | 44009 | 32380 | 224 |
2397788 | 2397788 | 2022-04-11 | Bristol | Rhode Island | 44001 | 13538 | 169 |
2397789 | 2397789 | 2022-04-11 | Kent | Rhode Island | 44003 | 48495 | 512 |
2397790 | 2397790 | 2022-04-11 | Newport | Rhode Island | 44005 | 19986 | 89 |
2397791 | 2397791 | 2022-04-11 | Providence | Rhode Island | 44007 | 221007 | 2522 |
2397792 | 2397792 | 2022-04-11 | Unknown | Rhode Island | 28778 | 11 | |
2397793 | 2397793 | 2022-04-11 | Washington | Rhode Island | 44009 | 32380 | 224 |
2394533 | 2394533 | 2022-04-10 | Bristol | Rhode Island | 44001 | 13538 | 169 |
2394534 | 2394534 | 2022-04-10 | Kent | Rhode Island | 44003 | 48495 | 512 |
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);