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 cases
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 | |
11999 | 11999 | 2020-03-25 | Bristol | Rhode Island | 44001 | 5 | 0 |
13621 | 13621 | 2020-03-26 | Bristol | Rhode Island | 44001 | 5 | 0 |
15368 | 15368 | 2020-03-27 | Bristol | Rhode Island | 44001 | 5 | 0 |
17222 | 17222 | 2020-03-28 | Bristol | Rhode Island | 44001 | 5 | 0 |
12000 | 12000 | 2020-03-25 | Kent | Rhode Island | 44003 | 7 | 0 |
13622 | 13622 | 2020-03-26 | Kent | Rhode Island | 44003 | 7 | 0 |
15369 | 15369 | 2020-03-27 | Kent | Rhode Island | 44003 | 7 | 0 |
17223 | 17223 | 2020-03-28 | Kent | Rhode Island | 44003 | 7 | 0 |
12001 | 12001 | 2020-03-25 | Newport | Rhode Island | 44005 | 8 | 0 |
13623 | 13623 | 2020-03-26 | Newport | Rhode Island | 44005 | 8 | 0 |
15370 | 15370 | 2020-03-27 | Newport | Rhode Island | 44005 | 8 | 0 |
17224 | 17224 | 2020-03-28 | Newport | Rhode Island | 44005 | 8 | 0 |
12004 | 12004 | 2020-03-25 | Washington | Rhode Island | 44009 | 9 | 0 |
13626 | 13626 | 2020-03-26 | Washington | Rhode Island | 44009 | 9 | 0 |
15373 | 15373 | 2020-03-27 | Washington | Rhode Island | 44009 | 9 | 0 |
17227 | 17227 | 2020-03-28 | Washington | Rhode Island | 44009 | 9 | 0 |
19162 | 19162 | 2020-03-29 | Bristol | Rhode Island | 44001 | 11 | 0 |
21213 | 21213 | 2020-03-30 | Bristol | Rhode Island | 44001 | 14 | 0 |
19164 | 19164 | 2020-03-29 | Newport | Rhode Island | 44005 | 17 | 0 |
23350 | 23350 | 2020-03-31 | Bristol | Rhode Island | 44001 | 19 | 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 | |
25547 | 25547 | 2020-04-01 | Bristol | Rhode Island | 44001 | 20 | 0 |
3109 | 3109 | 2020-03-16 | Unknown | Rhode Island | 21 | 0 | |
19167 | 19167 | 2020-03-29 | Washington | Rhode Island | 44009 | 21 | 0 |
21215 | 21215 | 2020-03-30 | Newport | Rhode Island | 44005 | 21 | 0 |
27820 | 27820 | 2020-04-02 | Bristol | Rhode Island | 44001 | 21 | 0 |
30155 | 30155 | 2020-04-03 | Bristol | Rhode Island | 44001 | 21 | 0 |
3639 | 3639 | 2020-03-17 | Unknown | Rhode Island | 23 | 0 | |
23352 | 23352 | 2020-03-31 | Newport | Rhode Island | 44005 | 23 | 0 |
32546 | 32546 | 2020-04-04 | Bristol | Rhode Island | 44001 | 24 | 0 |
34982 | 34982 | 2020-04-05 | Bristol | Rhode Island | 44001 | 25 | 0 |
37457 | 37457 | 2020-04-06 | Bristol | Rhode Island | 44001 | 25 | 0 |
19163 | 19163 | 2020-03-29 | Kent | Rhode Island | 44003 | 28 | 0 |
21218 | 21218 | 2020-03-30 | Washington | Rhode Island | 44009 | 28 | 0 |
23355 | 23355 | 2020-03-31 | Washington | Rhode Island | 44009 | 29 | 0 |
39980 | 39980 | 2020-04-07 | Bristol | Rhode Island | 44001 | 30 | 0 |
25549 | 25549 | 2020-04-01 | Newport | Rhode Island | 44005 | 31 | 0 |
42540 | 42540 | 2020-04-08 | Bristol | Rhode Island | 44001 | 31 | 0 |
21214 | 21214 | 2020-03-30 | Kent | Rhode Island | 44003 | 32 | 0 |
25552 | 25552 | 2020-04-01 | Washington | Rhode Island | 44009 | 32 | 0 |
4258 | 4258 | 2020-03-18 | Unknown | Rhode Island | 33 | 0 | |
27822 | 27822 | 2020-04-02 | Newport | Rhode Island | 44005 | 33 | 0 |
30157 | 30157 | 2020-04-03 | Newport | Rhode Island | 44005 | 33 | 0 |
27825 | 27825 | 2020-04-02 | Washington | Rhode Island | 44009 | 34 | 0 |
30160 | 30160 | 2020-04-03 | Washington | Rhode Island | 44009 | 34 | 0 |
12002 | 12002 | 2020-03-25 | Providence | Rhode Island | 44007 | 37 | 0 |
25551 | 25551 | 2020-04-01 | Unknown | Rhode Island | 37 | 7 | |
45126 | 45126 | 2020-04-09 | Bristol | Rhode Island | 44001 | 37 | 0 |
47743 | 47743 | 2020-04-10 | Bristol | Rhode Island | 44001 | 37 | 0 |
32548 | 32548 | 2020-04-04 | Newport | Rhode Island | 44005 | 39 | 0 |
50400 | 50400 | 2020-04-11 | Bristol | Rhode Island | 44001 | 39 | 0 |
53073 | 53073 | 2020-04-12 | Bristol | Rhode Island | 44001 | 39 | 0 |
55758 | 55758 | 2020-04-13 | Bristol | Rhode Island | 44001 | 39 | 0 |
23351 | 23351 | 2020-03-31 | Kent | Rhode Island | 44003 | 40 | 0 |
13624 | 13624 | 2020-03-26 | Providence | Rhode Island | 44007 | 42 | 0 |
15371 | 15371 | 2020-03-27 | Providence | Rhode Island | 44007 | 42 | 0 |
17225 | 17225 | 2020-03-28 | Providence | Rhode Island | 44007 | 42 | 0 |
34984 | 34984 | 2020-04-05 | Newport | Rhode Island | 44005 | 42 | 0 |
37459 | 37459 | 2020-04-06 | Newport | Rhode Island | 44005 | 42 | 0 |
5000 | 5000 | 2020-03-19 | Unknown | Rhode Island | 44 | 0 | |
5873 | 5873 | 2020-03-20 | Unknown | Rhode Island | 44 | 0 | |
32551 | 32551 | 2020-04-04 | Washington | Rhode Island | 44009 | 48 | 0 |
58461 | 58461 | 2020-04-14 | Bristol | Rhode Island | 44001 | 49 | 0 |
61176 | 61176 | 2020-04-15 | Bristol | Rhode Island | 44001 | 49 | 0 |
34987 | 34987 | 2020-04-05 | Washington | Rhode Island | 44009 | 53 | 0 |
37462 | 37462 | 2020-04-06 | Washington | Rhode Island | 44009 | 53 | 0 |
25548 | 25548 | 2020-04-01 | Kent | Rhode Island | 44003 | 55 | 0 |
39982 | 39982 | 2020-04-07 | Newport | Rhode Island | 44005 | 56 | 0 |
42542 | 42542 | 2020-04-08 | Newport | Rhode Island | 44005 | 56 | 0 |
63902 | 63902 | 2020-04-16 | Bristol | Rhode Island | 44001 | 56 | 0 |
45128 | 45128 | 2020-04-09 | Newport | Rhode Island | 44005 | 57 | 0 |
47745 | 47745 | 2020-04-10 | Newport | Rhode Island | 44005 | 57 | 0 |
66648 | 66648 | 2020-04-17 | Bristol | Rhode Island | 44001 | 57 | 0 |
27821 | 27821 | 2020-04-02 | Kent | Rhode Island | 44003 | 59 | 0 |
30156 | 30156 | 2020-04-03 | Kent | Rhode Island | 44003 | 59 | 0 |
69406 | 69406 | 2020-04-18 | Bristol | Rhode Island | 44001 | 59 | 0 |
72173 | 72173 | 2020-04-19 | Bristol | Rhode Island | 44001 | 65 | 0 |
6877 | 6877 | 2020-03-21 | Unknown | Rhode Island | 66 | 0 | |
12003 | 12003 | 2020-03-25 | Unknown | Rhode Island | 66 | 0 | |
74948 | 74948 | 2020-04-20 | Bristol | Rhode Island | 44001 | 67 | 0 |
77730 | 77730 | 2020-04-21 | Bristol | Rhode Island | 44001 | 68 | 0 |
80520 | 80520 | 2020-04-22 | Bristol | Rhode Island | 44001 | 68 | 0 |
83319 | 83319 | 2020-04-23 | Bristol | Rhode Island | 44001 | 68 | 0 |
19166 | 19166 | 2020-03-29 | Unknown | Rhode Island | 69 | 3 | |
23354 | 23354 | 2020-03-31 | Unknown | Rhode Island | 72 | 8 | |
50402 | 50402 | 2020-04-11 | Newport | Rhode Island | 44005 | 74 | 0 |
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);