ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 44003 and state = "Rhode Island" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
19163 | 19163 | 2020-03-29 | Kent | Rhode Island | 44003 | 28 | 0 |
21214 | 21214 | 2020-03-30 | Kent | Rhode Island | 44003 | 32 | 0 |
23351 | 23351 | 2020-03-31 | Kent | Rhode Island | 44003 | 40 | 0 |
25548 | 25548 | 2020-04-01 | Kent | Rhode Island | 44003 | 55 | 0 |
27821 | 27821 | 2020-04-02 | Kent | Rhode Island | 44003 | 59 | 0 |
30156 | 30156 | 2020-04-03 | Kent | Rhode Island | 44003 | 59 | 0 |
32547 | 32547 | 2020-04-04 | Kent | Rhode Island | 44003 | 82 | 0 |
34983 | 34983 | 2020-04-05 | Kent | Rhode Island | 44003 | 92 | 0 |
37458 | 37458 | 2020-04-06 | Kent | Rhode Island | 44003 | 92 | 0 |
39981 | 39981 | 2020-04-07 | Kent | Rhode Island | 44003 | 125 | 0 |
42541 | 42541 | 2020-04-08 | Kent | Rhode Island | 44003 | 137 | 0 |
45127 | 45127 | 2020-04-09 | Kent | Rhode Island | 44003 | 152 | 0 |
47744 | 47744 | 2020-04-10 | Kent | Rhode Island | 44003 | 152 | 0 |
50401 | 50401 | 2020-04-11 | Kent | Rhode Island | 44003 | 169 | 0 |
53074 | 53074 | 2020-04-12 | Kent | Rhode Island | 44003 | 169 | 0 |
55759 | 55759 | 2020-04-13 | Kent | Rhode Island | 44003 | 169 | 0 |
58462 | 58462 | 2020-04-14 | Kent | Rhode Island | 44003 | 244 | 0 |
61177 | 61177 | 2020-04-15 | Kent | Rhode Island | 44003 | 244 | 0 |
63903 | 63903 | 2020-04-16 | Kent | Rhode Island | 44003 | 272 | 0 |
66649 | 66649 | 2020-04-17 | Kent | Rhode Island | 44003 | 299 | 0 |
69407 | 69407 | 2020-04-18 | Kent | Rhode Island | 44003 | 316 | 0 |
72174 | 72174 | 2020-04-19 | Kent | Rhode Island | 44003 | 341 | 0 |
74949 | 74949 | 2020-04-20 | Kent | Rhode Island | 44003 | 366 | 0 |
77731 | 77731 | 2020-04-21 | Kent | Rhode Island | 44003 | 386 | 0 |
80521 | 80521 | 2020-04-22 | Kent | Rhode Island | 44003 | 386 | 0 |
83320 | 83320 | 2020-04-23 | Kent | Rhode Island | 44003 | 386 | 0 |
86124 | 86124 | 2020-04-24 | Kent | Rhode Island | 44003 | 466 | 0 |
88938 | 88938 | 2020-04-25 | Kent | Rhode Island | 44003 | 496 | 2 |
91754 | 91754 | 2020-04-26 | Kent | Rhode Island | 44003 | 526 | 2 |
94581 | 94581 | 2020-04-27 | Kent | Rhode Island | 44003 | 526 | 2 |
97420 | 97420 | 2020-04-28 | Kent | Rhode Island | 44003 | 574 | 2 |
100269 | 100269 | 2020-04-29 | Kent | Rhode Island | 44003 | 598 | 4 |
103122 | 103122 | 2020-04-30 | Kent | Rhode Island | 44003 | 622 | 4 |
105985 | 105985 | 2020-05-01 | Kent | Rhode Island | 44003 | 638 | 4 |
108852 | 108852 | 2020-05-02 | Kent | Rhode Island | 44003 | 675 | 4 |
111726 | 111726 | 2020-05-03 | Kent | Rhode Island | 44003 | 697 | 25 |
114608 | 114608 | 2020-05-04 | Kent | Rhode Island | 44003 | 703 | 25 |
117564 | 117564 | 2020-05-05 | Kent | Rhode Island | 44003 | 703 | 25 |
120526 | 120526 | 2020-05-06 | Kent | Rhode Island | 44003 | 703 | 25 |
123504 | 123504 | 2020-05-07 | Kent | Rhode Island | 44003 | 703 | 25 |
126487 | 126487 | 2020-05-08 | Kent | Rhode Island | 44003 | 703 | 25 |
129476 | 129476 | 2020-05-09 | Kent | Rhode Island | 44003 | 703 | 25 |
132465 | 132465 | 2020-05-10 | Kent | Rhode Island | 44003 | 703 | 25 |
135456 | 135456 | 2020-05-11 | Kent | Rhode Island | 44003 | 859 | 46 |
138446 | 138446 | 2020-05-12 | Kent | Rhode Island | 44003 | 850 | 46 |
141442 | 141442 | 2020-05-13 | Kent | Rhode Island | 44003 | 883 | 46 |
144438 | 144438 | 2020-05-14 | Kent | Rhode Island | 44003 | 883 | 46 |
147439 | 147439 | 2020-05-15 | Kent | Rhode Island | 44003 | 883 | 46 |
150447 | 150447 | 2020-05-16 | Kent | Rhode Island | 44003 | 883 | 46 |
153458 | 153458 | 2020-05-17 | Kent | Rhode Island | 44003 | 883 | 46 |
156475 | 156475 | 2020-05-18 | Kent | Rhode Island | 44003 | 883 | 46 |
159496 | 159496 | 2020-05-19 | Kent | Rhode Island | 44003 | 883 | 46 |
162523 | 162523 | 2020-05-20 | Kent | Rhode Island | 44003 | 958 | 46 |
165552 | 165552 | 2020-05-21 | Kent | Rhode Island | 44003 | 974 | 46 |
168588 | 168588 | 2020-05-22 | Kent | Rhode Island | 44003 | 985 | 46 |
171627 | 171627 | 2020-05-23 | Kent | Rhode Island | 44003 | 1005 | 46 |
174669 | 174669 | 2020-05-24 | Kent | Rhode Island | 44003 | 1013 | 46 |
177713 | 177713 | 2020-05-25 | Kent | Rhode Island | 44003 | 1013 | 46 |
180756 | 180756 | 2020-05-26 | Kent | Rhode Island | 44003 | 1013 | 46 |
183806 | 183806 | 2020-05-27 | Kent | Rhode Island | 44003 | 1032 | 68 |
186863 | 186863 | 2020-05-28 | Kent | Rhode Island | 44003 | 1038 | 68 |
189925 | 189925 | 2020-05-29 | Kent | Rhode Island | 44003 | 1052 | 68 |
192990 | 192990 | 2020-05-30 | Kent | Rhode Island | 44003 | 1052 | 68 |
196059 | 196059 | 2020-05-31 | Kent | Rhode Island | 44003 | 1052 | 68 |
199132 | 199132 | 2020-06-01 | Kent | Rhode Island | 44003 | 1052 | 68 |
202207 | 202207 | 2020-06-02 | Kent | Rhode Island | 44003 | 1052 | 68 |
205284 | 205284 | 2020-06-03 | Kent | Rhode Island | 44003 | 1052 | 68 |
208365 | 208365 | 2020-06-04 | Kent | Rhode Island | 44003 | 1052 | 68 |
211447 | 211447 | 2020-06-05 | Kent | Rhode Island | 44003 | 1052 | 68 |
214533 | 214533 | 2020-06-06 | Kent | Rhode Island | 44003 | 1052 | 68 |
217623 | 217623 | 2020-06-07 | Kent | Rhode Island | 44003 | 1052 | 68 |
220715 | 220715 | 2020-06-08 | Kent | Rhode Island | 44003 | 1105 | 82 |
223810 | 223810 | 2020-06-09 | Kent | Rhode Island | 44003 | 1105 | 82 |
226910 | 226910 | 2020-06-10 | Kent | Rhode Island | 44003 | 1105 | 82 |
230014 | 230014 | 2020-06-11 | Kent | Rhode Island | 44003 | 1105 | 82 |
233119 | 233119 | 2020-06-12 | Kent | Rhode Island | 44003 | 1105 | 82 |
236224 | 236224 | 2020-06-13 | Kent | Rhode Island | 44003 | 1105 | 82 |
239332 | 239332 | 2020-06-14 | Kent | Rhode Island | 44003 | 1105 | 82 |
242441 | 242441 | 2020-06-15 | Kent | Rhode Island | 44003 | 1128 | 82 |
245553 | 245553 | 2020-06-16 | Kent | Rhode Island | 44003 | 1128 | 82 |
248666 | 248666 | 2020-06-17 | Kent | Rhode Island | 44003 | 1128 | 82 |
251781 | 251781 | 2020-06-18 | Kent | Rhode Island | 44003 | 1128 | 82 |
254896 | 254896 | 2020-06-19 | Kent | Rhode Island | 44003 | 1128 | 82 |
258022 | 258022 | 2020-06-20 | Kent | Rhode Island | 44003 | 1128 | 82 |
261149 | 261149 | 2020-06-21 | Kent | Rhode Island | 44003 | 1128 | 82 |
264277 | 264277 | 2020-06-22 | Kent | Rhode Island | 44003 | 1169 | 82 |
267405 | 267405 | 2020-06-23 | Kent | Rhode Island | 44003 | 1169 | 82 |
270539 | 270539 | 2020-06-24 | Kent | Rhode Island | 44003 | 1169 | 82 |
273678 | 273678 | 2020-06-25 | Kent | Rhode Island | 44003 | 1169 | 82 |
276825 | 276825 | 2020-06-26 | Kent | Rhode Island | 44003 | 1169 | 93 |
279973 | 279973 | 2020-06-27 | Kent | Rhode Island | 44003 | 1169 | 93 |
283119 | 283119 | 2020-06-28 | Kent | Rhode Island | 44003 | 1169 | 93 |
286264 | 286264 | 2020-06-29 | Kent | Rhode Island | 44003 | 1199 | 93 |
289415 | 289415 | 2020-06-30 | Kent | Rhode Island | 44003 | 1199 | 93 |
292567 | 292567 | 2020-07-01 | Kent | Rhode Island | 44003 | 1199 | 93 |
295723 | 295723 | 2020-07-02 | Kent | Rhode Island | 44003 | 1199 | 93 |
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);