ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,518 rows where county = "Rio Grande" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12554 | 12554 | 2020-03-26 | Rio Grande | Colorado | 8105 | 2 | 0 |
14223 | 14223 | 2020-03-27 | Rio Grande | Colorado | 8105 | 2 | 0 |
16007 | 16007 | 2020-03-28 | Rio Grande | Colorado | 8105 | 2 | 0 |
17899 | 17899 | 2020-03-29 | Rio Grande | Colorado | 8105 | 3 | 0 |
19878 | 19878 | 2020-03-30 | Rio Grande | Colorado | 8105 | 4 | 0 |
21954 | 21954 | 2020-03-31 | Rio Grande | Colorado | 8105 | 5 | 0 |
24113 | 24113 | 2020-04-01 | Rio Grande | Colorado | 8105 | 5 | 0 |
26343 | 26343 | 2020-04-02 | Rio Grande | Colorado | 8105 | 5 | 0 |
28645 | 28645 | 2020-04-03 | Rio Grande | Colorado | 8105 | 5 | 0 |
31003 | 31003 | 2020-04-04 | Rio Grande | Colorado | 8105 | 5 | 0 |
33409 | 33409 | 2020-04-05 | Rio Grande | Colorado | 8105 | 5 | 0 |
35854 | 35854 | 2020-04-06 | Rio Grande | Colorado | 8105 | 5 | 0 |
38344 | 38344 | 2020-04-07 | Rio Grande | Colorado | 8105 | 5 | 0 |
40887 | 40887 | 2020-04-08 | Rio Grande | Colorado | 8105 | 5 | 0 |
43461 | 43461 | 2020-04-09 | Rio Grande | Colorado | 8105 | 5 | 0 |
46061 | 46061 | 2020-04-10 | Rio Grande | Colorado | 8105 | 5 | 0 |
48691 | 48691 | 2020-04-11 | Rio Grande | Colorado | 8105 | 5 | 0 |
51353 | 51353 | 2020-04-12 | Rio Grande | Colorado | 8105 | 5 | 0 |
54032 | 54032 | 2020-04-13 | Rio Grande | Colorado | 8105 | 5 | 0 |
56724 | 56724 | 2020-04-14 | Rio Grande | Colorado | 8105 | 5 | 0 |
59432 | 59432 | 2020-04-15 | Rio Grande | Colorado | 8105 | 7 | 0 |
62151 | 62151 | 2020-04-16 | Rio Grande | Colorado | 8105 | 7 | 0 |
64884 | 64884 | 2020-04-17 | Rio Grande | Colorado | 8105 | 7 | 0 |
67632 | 67632 | 2020-04-18 | Rio Grande | Colorado | 8105 | 7 | 0 |
70394 | 70394 | 2020-04-19 | Rio Grande | Colorado | 8105 | 7 | 0 |
73163 | 73163 | 2020-04-20 | Rio Grande | Colorado | 8105 | 7 | 0 |
75939 | 75939 | 2020-04-21 | Rio Grande | Colorado | 8105 | 7 | 0 |
78723 | 78723 | 2020-04-22 | Rio Grande | Colorado | 8105 | 7 | 0 |
81517 | 81517 | 2020-04-23 | Rio Grande | Colorado | 8105 | 7 | 0 |
84317 | 84317 | 2020-04-24 | Rio Grande | Colorado | 8105 | 7 | 0 |
87125 | 87125 | 2020-04-25 | Rio Grande | Colorado | 8105 | 7 | 0 |
89942 | 89942 | 2020-04-26 | Rio Grande | Colorado | 8105 | 7 | 0 |
92760 | 92760 | 2020-04-27 | Rio Grande | Colorado | 8105 | 7 | 0 |
95592 | 95592 | 2020-04-28 | Rio Grande | Colorado | 8105 | 7 | 0 |
98437 | 98437 | 2020-04-29 | Rio Grande | Colorado | 8105 | 7 | 0 |
101287 | 101287 | 2020-04-30 | Rio Grande | Colorado | 8105 | 7 | 0 |
104142 | 104142 | 2020-05-01 | Rio Grande | Colorado | 8105 | 7 | 0 |
107007 | 107007 | 2020-05-02 | Rio Grande | Colorado | 8105 | 7 | 0 |
109876 | 109876 | 2020-05-03 | Rio Grande | Colorado | 8105 | 7 | 0 |
112751 | 112751 | 2020-05-04 | Rio Grande | Colorado | 8105 | 7 | 0 |
115634 | 115634 | 2020-05-05 | Rio Grande | Colorado | 8105 | 7 | 0 |
117545 | 117545 | 2020-05-05 | Rio Grande | Puerto Rico | 72119 | 22 | |
118593 | 118593 | 2020-05-06 | Rio Grande | Colorado | 8105 | 7 | 0 |
120507 | 120507 | 2020-05-06 | Rio Grande | Puerto Rico | 72119 | 23 | |
121562 | 121562 | 2020-05-07 | Rio Grande | Colorado | 8105 | 7 | 0 |
123484 | 123484 | 2020-05-07 | Rio Grande | Puerto Rico | 72119 | 26 | |
124542 | 124542 | 2020-05-08 | Rio Grande | Colorado | 8105 | 7 | 0 |
126467 | 126467 | 2020-05-08 | Rio Grande | Puerto Rico | 72119 | 27 | |
127528 | 127528 | 2020-05-09 | Rio Grande | Colorado | 8105 | 7 | 0 |
129456 | 129456 | 2020-05-09 | Rio Grande | Puerto Rico | 72119 | 26 | |
130519 | 130519 | 2020-05-10 | Rio Grande | Colorado | 8105 | 7 | 0 |
132445 | 132445 | 2020-05-10 | Rio Grande | Puerto Rico | 72119 | 26 | |
133510 | 133510 | 2020-05-11 | Rio Grande | Colorado | 8105 | 8 | 0 |
135436 | 135436 | 2020-05-11 | Rio Grande | Puerto Rico | 72119 | 26 | |
136499 | 136499 | 2020-05-12 | Rio Grande | Colorado | 8105 | 7 | 0 |
138426 | 138426 | 2020-05-12 | Rio Grande | Puerto Rico | 72119 | 26 | |
139490 | 139490 | 2020-05-13 | Rio Grande | Colorado | 8105 | 7 | 0 |
141422 | 141422 | 2020-05-13 | Rio Grande | Puerto Rico | 72119 | 26 | |
142486 | 142486 | 2020-05-14 | Rio Grande | Colorado | 8105 | 7 | 0 |
144418 | 144418 | 2020-05-14 | Rio Grande | Puerto Rico | 72119 | 27 | |
145486 | 145486 | 2020-05-15 | Rio Grande | Colorado | 8105 | 7 | 0 |
147419 | 147419 | 2020-05-15 | Rio Grande | Puerto Rico | 72119 | 27 | |
148489 | 148489 | 2020-05-16 | Rio Grande | Colorado | 8105 | 8 | 0 |
150427 | 150427 | 2020-05-16 | Rio Grande | Puerto Rico | 72119 | 27 | |
151498 | 151498 | 2020-05-17 | Rio Grande | Colorado | 8105 | 8 | 0 |
153438 | 153438 | 2020-05-17 | Rio Grande | Puerto Rico | 72119 | 27 | |
154510 | 154510 | 2020-05-18 | Rio Grande | Colorado | 8105 | 8 | 0 |
156455 | 156455 | 2020-05-18 | Rio Grande | Puerto Rico | 72119 | 27 | |
157526 | 157526 | 2020-05-19 | Rio Grande | Colorado | 8105 | 9 | 0 |
159476 | 159476 | 2020-05-19 | Rio Grande | Puerto Rico | 72119 | 28 | |
160552 | 160552 | 2020-05-20 | Rio Grande | Colorado | 8105 | 8 | 0 |
162503 | 162503 | 2020-05-20 | Rio Grande | Puerto Rico | 72119 | 28 | |
163580 | 163580 | 2020-05-21 | Rio Grande | Colorado | 8105 | 14 | 1 |
165532 | 165532 | 2020-05-21 | Rio Grande | Puerto Rico | 72119 | 29 | |
166613 | 166613 | 2020-05-22 | Rio Grande | Colorado | 8105 | 15 | 1 |
168568 | 168568 | 2020-05-22 | Rio Grande | Puerto Rico | 72119 | 31 | |
169650 | 169650 | 2020-05-23 | Rio Grande | Colorado | 8105 | 16 | 0 |
171607 | 171607 | 2020-05-23 | Rio Grande | Puerto Rico | 72119 | 35 | |
172691 | 172691 | 2020-05-24 | Rio Grande | Colorado | 8105 | 16 | 0 |
174649 | 174649 | 2020-05-24 | Rio Grande | Puerto Rico | 72119 | 35 | |
175735 | 175735 | 2020-05-25 | Rio Grande | Colorado | 8105 | 16 | 0 |
177693 | 177693 | 2020-05-25 | Rio Grande | Puerto Rico | 72119 | 45 | |
178779 | 178779 | 2020-05-26 | Rio Grande | Colorado | 8105 | 16 | 0 |
180736 | 180736 | 2020-05-26 | Rio Grande | Puerto Rico | 72119 | 45 | |
181823 | 181823 | 2020-05-27 | Rio Grande | Colorado | 8105 | 16 | 0 |
183786 | 183786 | 2020-05-27 | Rio Grande | Puerto Rico | 72119 | 47 | |
184877 | 184877 | 2020-05-28 | Rio Grande | Colorado | 8105 | 16 | 0 |
186843 | 186843 | 2020-05-28 | Rio Grande | Puerto Rico | 72119 | 47 | |
187933 | 187933 | 2020-05-29 | Rio Grande | Colorado | 8105 | 16 | 0 |
189905 | 189905 | 2020-05-29 | Rio Grande | Puerto Rico | 72119 | 53 | |
190998 | 190998 | 2020-05-30 | Rio Grande | Colorado | 8105 | 23 | 0 |
192970 | 192970 | 2020-05-30 | Rio Grande | Puerto Rico | 72119 | 52 | |
194065 | 194065 | 2020-05-31 | Rio Grande | Colorado | 8105 | 33 | 0 |
196039 | 196039 | 2020-05-31 | Rio Grande | Puerto Rico | 72119 | 52 | |
197135 | 197135 | 2020-06-01 | Rio Grande | Colorado | 8105 | 35 | 0 |
199112 | 199112 | 2020-06-01 | Rio Grande | Puerto Rico | 72119 | 54 | |
200208 | 200208 | 2020-06-02 | Rio Grande | Colorado | 8105 | 37 | 0 |
202187 | 202187 | 2020-06-02 | Rio Grande | Puerto Rico | 72119 | 56 | |
203284 | 203284 | 2020-06-03 | Rio Grande | Colorado | 8105 | 36 | 0 |
205264 | 205264 | 2020-06-03 | Rio Grande | Puerto Rico | 72119 | 56 |
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);