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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 6
- Unknown 804
- Bristol 780
- Kent 780
- Newport 780
- Providence 780
- Washington 780
state 1
- Rhode Island · 4,704 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
419 | 419 | 2020-03-01 | Unknown | Rhode Island | 2 | 0 | |
451 | 451 | 2020-03-02 | Unknown | Rhode Island | 2 | 0 | |
486 | 486 | 2020-03-03 | Unknown | Rhode Island | 2 | 0 | |
523 | 523 | 2020-03-04 | Unknown | Rhode Island | 2 | 0 | |
570 | 570 | 2020-03-05 | Unknown | Rhode Island | 2 | 0 | |
637 | 637 | 2020-03-06 | Unknown | Rhode Island | 3 | 0 | |
729 | 729 | 2020-03-07 | Unknown | Rhode Island | 3 | 0 | |
838 | 838 | 2020-03-08 | Unknown | Rhode Island | 3 | 0 | |
967 | 967 | 2020-03-09 | Unknown | Rhode Island | 3 | 0 | |
1120 | 1120 | 2020-03-10 | Unknown | Rhode Island | 5 | 0 | |
1314 | 1314 | 2020-03-11 | Unknown | Rhode Island | 5 | 0 | |
1560 | 1560 | 2020-03-12 | Unknown | Rhode Island | 5 | 0 | |
1860 | 1860 | 2020-03-13 | Unknown | Rhode Island | 20 | 0 | |
2222 | 2222 | 2020-03-14 | Unknown | Rhode Island | 20 | 0 | |
2644 | 2644 | 2020-03-15 | Unknown | Rhode Island | 20 | 0 | |
3109 | 3109 | 2020-03-16 | Unknown | Rhode Island | 21 | 0 | |
3639 | 3639 | 2020-03-17 | Unknown | Rhode Island | 23 | 0 | |
4258 | 4258 | 2020-03-18 | Unknown | Rhode Island | 33 | 0 | |
5000 | 5000 | 2020-03-19 | Unknown | Rhode Island | 44 | 0 | |
5873 | 5873 | 2020-03-20 | Unknown | Rhode Island | 44 | 0 | |
6877 | 6877 | 2020-03-21 | Unknown | Rhode Island | 66 | 0 | |
7997 | 7997 | 2020-03-22 | Unknown | Rhode Island | 83 | 0 | |
9208 | 9208 | 2020-03-23 | Unknown | Rhode Island | 106 | 0 | |
10533 | 10533 | 2020-03-24 | Unknown | Rhode Island | 124 | 0 | |
11999 | 11999 | 2020-03-25 | Bristol | Rhode Island | 44001 | 5 | 0 |
12000 | 12000 | 2020-03-25 | Kent | Rhode Island | 44003 | 7 | 0 |
12001 | 12001 | 2020-03-25 | Newport | Rhode Island | 44005 | 8 | 0 |
12002 | 12002 | 2020-03-25 | Providence | Rhode Island | 44007 | 37 | 0 |
12003 | 12003 | 2020-03-25 | Unknown | Rhode Island | 66 | 0 | |
12004 | 12004 | 2020-03-25 | Washington | Rhode Island | 44009 | 9 | 0 |
13621 | 13621 | 2020-03-26 | Bristol | Rhode Island | 44001 | 5 | 0 |
13622 | 13622 | 2020-03-26 | Kent | Rhode Island | 44003 | 7 | 0 |
13623 | 13623 | 2020-03-26 | Newport | Rhode Island | 44005 | 8 | 0 |
13624 | 13624 | 2020-03-26 | Providence | Rhode Island | 44007 | 42 | 0 |
13625 | 13625 | 2020-03-26 | Unknown | Rhode Island | 94 | 0 | |
13626 | 13626 | 2020-03-26 | Washington | Rhode Island | 44009 | 9 | 0 |
15368 | 15368 | 2020-03-27 | Bristol | Rhode Island | 44001 | 5 | 0 |
15369 | 15369 | 2020-03-27 | Kent | Rhode Island | 44003 | 7 | 0 |
15370 | 15370 | 2020-03-27 | Newport | Rhode Island | 44005 | 8 | 0 |
15371 | 15371 | 2020-03-27 | Providence | Rhode Island | 44007 | 42 | 0 |
15372 | 15372 | 2020-03-27 | Unknown | Rhode Island | 132 | 0 | |
15373 | 15373 | 2020-03-27 | Washington | Rhode Island | 44009 | 9 | 0 |
17222 | 17222 | 2020-03-28 | Bristol | Rhode Island | 44001 | 5 | 0 |
17223 | 17223 | 2020-03-28 | Kent | Rhode Island | 44003 | 7 | 0 |
17224 | 17224 | 2020-03-28 | Newport | Rhode Island | 44005 | 8 | 0 |
17225 | 17225 | 2020-03-28 | Providence | Rhode Island | 44007 | 42 | 0 |
17226 | 17226 | 2020-03-28 | Unknown | Rhode Island | 168 | 2 | |
17227 | 17227 | 2020-03-28 | Washington | Rhode Island | 44009 | 9 | 0 |
19162 | 19162 | 2020-03-29 | Bristol | Rhode Island | 44001 | 11 | 0 |
19163 | 19163 | 2020-03-29 | Kent | Rhode Island | 44003 | 28 | 0 |
19164 | 19164 | 2020-03-29 | Newport | Rhode Island | 44005 | 17 | 0 |
19165 | 19165 | 2020-03-29 | Providence | Rhode Island | 44007 | 148 | 0 |
19166 | 19166 | 2020-03-29 | Unknown | Rhode Island | 69 | 3 | |
19167 | 19167 | 2020-03-29 | Washington | Rhode Island | 44009 | 21 | 0 |
21213 | 21213 | 2020-03-30 | Bristol | Rhode Island | 44001 | 14 | 0 |
21214 | 21214 | 2020-03-30 | Kent | Rhode Island | 44003 | 32 | 0 |
21215 | 21215 | 2020-03-30 | Newport | Rhode Island | 44005 | 21 | 0 |
21216 | 21216 | 2020-03-30 | Providence | Rhode Island | 44007 | 214 | 0 |
21217 | 21217 | 2020-03-30 | Unknown | Rhode Island | 99 | 4 | |
21218 | 21218 | 2020-03-30 | Washington | Rhode Island | 44009 | 28 | 0 |
23350 | 23350 | 2020-03-31 | Bristol | Rhode Island | 44001 | 19 | 0 |
23351 | 23351 | 2020-03-31 | Kent | Rhode Island | 44003 | 40 | 0 |
23352 | 23352 | 2020-03-31 | Newport | Rhode Island | 44005 | 23 | 0 |
23353 | 23353 | 2020-03-31 | Providence | Rhode Island | 44007 | 305 | 0 |
23354 | 23354 | 2020-03-31 | Unknown | Rhode Island | 72 | 8 | |
23355 | 23355 | 2020-03-31 | Washington | Rhode Island | 44009 | 29 | 0 |
25547 | 25547 | 2020-04-01 | Bristol | Rhode Island | 44001 | 20 | 0 |
25548 | 25548 | 2020-04-01 | Kent | Rhode Island | 44003 | 55 | 0 |
25549 | 25549 | 2020-04-01 | Newport | Rhode Island | 44005 | 31 | 0 |
25550 | 25550 | 2020-04-01 | Providence | Rhode Island | 44007 | 391 | 3 |
25551 | 25551 | 2020-04-01 | Unknown | Rhode Island | 37 | 7 | |
25552 | 25552 | 2020-04-01 | Washington | Rhode Island | 44009 | 32 | 0 |
27820 | 27820 | 2020-04-02 | Bristol | Rhode Island | 44001 | 21 | 0 |
27821 | 27821 | 2020-04-02 | Kent | Rhode Island | 44003 | 59 | 0 |
27822 | 27822 | 2020-04-02 | Newport | Rhode Island | 44005 | 33 | 0 |
27823 | 27823 | 2020-04-02 | Providence | Rhode Island | 44007 | 418 | 3 |
27824 | 27824 | 2020-04-02 | Unknown | Rhode Island | 92 | 9 | |
27825 | 27825 | 2020-04-02 | Washington | Rhode Island | 44009 | 34 | 0 |
30155 | 30155 | 2020-04-03 | Bristol | Rhode Island | 44001 | 21 | 0 |
30156 | 30156 | 2020-04-03 | Kent | Rhode Island | 44003 | 59 | 0 |
30157 | 30157 | 2020-04-03 | Newport | Rhode Island | 44005 | 33 | 0 |
30158 | 30158 | 2020-04-03 | Providence | Rhode Island | 44007 | 418 | 7 |
30159 | 30159 | 2020-04-03 | Unknown | Rhode Island | 146 | 7 | |
30160 | 30160 | 2020-04-03 | Washington | Rhode Island | 44009 | 34 | 0 |
32546 | 32546 | 2020-04-04 | Bristol | Rhode Island | 44001 | 24 | 0 |
32547 | 32547 | 2020-04-04 | Kent | Rhode Island | 44003 | 82 | 0 |
32548 | 32548 | 2020-04-04 | Newport | Rhode Island | 44005 | 39 | 0 |
32549 | 32549 | 2020-04-04 | Providence | Rhode Island | 44007 | 491 | 7 |
32550 | 32550 | 2020-04-04 | Unknown | Rhode Island | 122 | 10 | |
32551 | 32551 | 2020-04-04 | Washington | Rhode Island | 44009 | 48 | 0 |
34982 | 34982 | 2020-04-05 | Bristol | Rhode Island | 44001 | 25 | 0 |
34983 | 34983 | 2020-04-05 | Kent | Rhode Island | 44003 | 92 | 0 |
34984 | 34984 | 2020-04-05 | Newport | Rhode Island | 44005 | 42 | 0 |
34985 | 34985 | 2020-04-05 | Providence | Rhode Island | 44007 | 538 | 7 |
34986 | 34986 | 2020-04-05 | Unknown | Rhode Island | 172 | 18 | |
34987 | 34987 | 2020-04-05 | Washington | Rhode Island | 44009 | 53 | 0 |
37457 | 37457 | 2020-04-06 | Bristol | Rhode Island | 44001 | 25 | 0 |
37458 | 37458 | 2020-04-06 | Kent | Rhode Island | 44003 | 92 | 0 |
37459 | 37459 | 2020-04-06 | Newport | Rhode Island | 44005 | 42 | 0 |
37460 | 37460 | 2020-04-06 | Providence | Rhode Island | 44007 | 538 | 7 |
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);