ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Rensselaer" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
3555 | 3555 | 2020-03-17 | Rensselaer | New York | 36083 | 1 | 0 |
4156 | 4156 | 2020-03-18 | Rensselaer | New York | 36083 | 4 | 0 |
4885 | 4885 | 2020-03-19 | Rensselaer | New York | 36083 | 4 | 0 |
5736 | 5736 | 2020-03-20 | Rensselaer | New York | 36083 | 8 | 0 |
6730 | 6730 | 2020-03-21 | Rensselaer | New York | 36083 | 20 | 0 |
7825 | 7825 | 2020-03-22 | Rensselaer | New York | 36083 | 26 | 0 |
9025 | 9025 | 2020-03-23 | Rensselaer | New York | 36083 | 29 | 0 |
10333 | 10333 | 2020-03-24 | Rensselaer | New York | 36083 | 30 | 0 |
11769 | 11769 | 2020-03-25 | Rensselaer | New York | 36083 | 31 | 0 |
13372 | 13372 | 2020-03-26 | Rensselaer | New York | 36083 | 32 | 0 |
15106 | 15106 | 2020-03-27 | Rensselaer | New York | 36083 | 35 | 0 |
16936 | 16936 | 2020-03-28 | Rensselaer | New York | 36083 | 38 | 0 |
18861 | 18861 | 2020-03-29 | Rensselaer | New York | 36083 | 39 | 0 |
20900 | 20900 | 2020-03-30 | Rensselaer | New York | 36083 | 40 | 0 |
23023 | 23023 | 2020-03-31 | Rensselaer | New York | 36083 | 55 | 0 |
25217 | 25217 | 2020-04-01 | Rensselaer | New York | 36083 | 60 | 0 |
27477 | 27477 | 2020-04-02 | Rensselaer | New York | 36083 | 67 | 1 |
29801 | 29801 | 2020-04-03 | Rensselaer | New York | 36083 | 71 | 1 |
32187 | 32187 | 2020-04-04 | Rensselaer | New York | 36083 | 73 | 1 |
34618 | 34618 | 2020-04-05 | Rensselaer | New York | 36083 | 74 | 1 |
37088 | 37088 | 2020-04-06 | Rensselaer | New York | 36083 | 78 | 1 |
42160 | 42160 | 2020-04-08 | Rensselaer | New York | 36083 | 91 | 1 |
39603 | 39603 | 2020-04-07 | Rensselaer | New York | 36083 | 91 | 3 |
44743 | 44743 | 2020-04-09 | Rensselaer | New York | 36083 | 79 | 3 |
47356 | 47356 | 2020-04-10 | Rensselaer | New York | 36083 | 91 | 4 |
50011 | 50011 | 2020-04-11 | Rensselaer | New York | 36083 | 96 | 4 |
52684 | 52684 | 2020-04-12 | Rensselaer | New York | 36083 | 105 | 6 |
55367 | 55367 | 2020-04-13 | Rensselaer | New York | 36083 | 113 | 6 |
58067 | 58067 | 2020-04-14 | Rensselaer | New York | 36083 | 120 | 7 |
60781 | 60781 | 2020-04-15 | Rensselaer | New York | 36083 | 124 | 8 |
63507 | 63507 | 2020-04-16 | Rensselaer | New York | 36083 | 137 | 9 |
66249 | 66249 | 2020-04-17 | Rensselaer | New York | 36083 | 150 | 9 |
69006 | 69006 | 2020-04-18 | Rensselaer | New York | 36083 | 164 | 9 |
71773 | 71773 | 2020-04-19 | Rensselaer | New York | 36083 | 173 | 10 |
74548 | 74548 | 2020-04-20 | Rensselaer | New York | 36083 | 177 | 10 |
77329 | 77329 | 2020-04-21 | Rensselaer | New York | 36083 | 183 | 11 |
80118 | 80118 | 2020-04-22 | Rensselaer | New York | 36083 | 186 | 11 |
82917 | 82917 | 2020-04-23 | Rensselaer | New York | 36083 | 191 | 12 |
85721 | 85721 | 2020-04-24 | Rensselaer | New York | 36083 | 198 | 12 |
88533 | 88533 | 2020-04-25 | Rensselaer | New York | 36083 | 221 | 12 |
91348 | 91348 | 2020-04-26 | Rensselaer | New York | 36083 | 242 | 13 |
94173 | 94173 | 2020-04-27 | Rensselaer | New York | 36083 | 246 | 17 |
97009 | 97009 | 2020-04-28 | Rensselaer | New York | 36083 | 250 | 17 |
99856 | 99856 | 2020-04-29 | Rensselaer | New York | 36083 | 262 | 17 |
102709 | 102709 | 2020-04-30 | Rensselaer | New York | 36083 | 287 | 20 |
105571 | 105571 | 2020-05-01 | Rensselaer | New York | 36083 | 298 | 20 |
108438 | 108438 | 2020-05-02 | Rensselaer | New York | 36083 | 311 | 21 |
111311 | 111311 | 2020-05-03 | Rensselaer | New York | 36083 | 322 | 23 |
114192 | 114192 | 2020-05-04 | Rensselaer | New York | 36083 | 337 | 23 |
117072 | 117072 | 2020-05-05 | Rensselaer | New York | 36083 | 339 | 23 |
120033 | 120033 | 2020-05-06 | Rensselaer | New York | 36083 | 347 | 28 |
123008 | 123008 | 2020-05-07 | Rensselaer | New York | 36083 | 367 | 28 |
125991 | 125991 | 2020-05-08 | Rensselaer | New York | 36083 | 380 | 28 |
128980 | 128980 | 2020-05-09 | Rensselaer | New York | 36083 | 407 | 29 |
131969 | 131969 | 2020-05-10 | Rensselaer | New York | 36083 | 409 | 29 |
134960 | 134960 | 2020-05-11 | Rensselaer | New York | 36083 | 411 | 30 |
137950 | 137950 | 2020-05-12 | Rensselaer | New York | 36083 | 416 | 30 |
140946 | 140946 | 2020-05-13 | Rensselaer | New York | 36083 | 420 | 30 |
143941 | 143941 | 2020-05-14 | Rensselaer | New York | 36083 | 423 | 30 |
146942 | 146942 | 2020-05-15 | Rensselaer | New York | 36083 | 428 | 30 |
149949 | 149949 | 2020-05-16 | Rensselaer | New York | 36083 | 438 | 30 |
152959 | 152959 | 2020-05-17 | Rensselaer | New York | 36083 | 439 | 32 |
155976 | 155976 | 2020-05-18 | Rensselaer | New York | 36083 | 444 | 32 |
158994 | 158994 | 2020-05-19 | Rensselaer | New York | 36083 | 444 | 32 |
162021 | 162021 | 2020-05-20 | Rensselaer | New York | 36083 | 453 | 32 |
165050 | 165050 | 2020-05-21 | Rensselaer | New York | 36083 | 456 | 32 |
168085 | 168085 | 2020-05-22 | Rensselaer | New York | 36083 | 460 | 32 |
171124 | 171124 | 2020-05-23 | Rensselaer | New York | 36083 | 463 | 32 |
174166 | 174166 | 2020-05-24 | Rensselaer | New York | 36083 | 463 | 32 |
177210 | 177210 | 2020-05-25 | Rensselaer | New York | 36083 | 465 | 32 |
180253 | 180253 | 2020-05-26 | Rensselaer | New York | 36083 | 466 | 32 |
183301 | 183301 | 2020-05-27 | Rensselaer | New York | 36083 | 466 | 32 |
186358 | 186358 | 2020-05-28 | Rensselaer | New York | 36083 | 469 | 32 |
189418 | 189418 | 2020-05-29 | Rensselaer | New York | 36083 | 478 | 32 |
192482 | 192482 | 2020-05-30 | Rensselaer | New York | 36083 | 486 | 32 |
195552 | 195552 | 2020-05-31 | Rensselaer | New York | 36083 | 491 | 32 |
198625 | 198625 | 2020-06-01 | Rensselaer | New York | 36083 | 492 | 32 |
201699 | 201699 | 2020-06-02 | Rensselaer | New York | 36083 | 493 | 32 |
204776 | 204776 | 2020-06-03 | Rensselaer | New York | 36083 | 495 | 32 |
207857 | 207857 | 2020-06-04 | Rensselaer | New York | 36083 | 495 | 32 |
210939 | 210939 | 2020-06-05 | Rensselaer | New York | 36083 | 497 | 32 |
214023 | 214023 | 2020-06-06 | Rensselaer | New York | 36083 | 499 | 32 |
217113 | 217113 | 2020-06-07 | Rensselaer | New York | 36083 | 502 | 32 |
220205 | 220205 | 2020-06-08 | Rensselaer | New York | 36083 | 503 | 32 |
223299 | 223299 | 2020-06-09 | Rensselaer | New York | 36083 | 505 | 32 |
226399 | 226399 | 2020-06-10 | Rensselaer | New York | 36083 | 507 | 33 |
229503 | 229503 | 2020-06-11 | Rensselaer | New York | 36083 | 508 | 33 |
232608 | 232608 | 2020-06-12 | Rensselaer | New York | 36083 | 510 | 33 |
235713 | 235713 | 2020-06-13 | Rensselaer | New York | 36083 | 511 | 34 |
238821 | 238821 | 2020-06-14 | Rensselaer | New York | 36083 | 513 | 34 |
241930 | 241930 | 2020-06-15 | Rensselaer | New York | 36083 | 514 | 34 |
245042 | 245042 | 2020-06-16 | Rensselaer | New York | 36083 | 514 | 34 |
407103 | 407103 | 2020-08-06 | Rensselaer | New York | 36083 | 758 | 35 |
410323 | 410323 | 2020-08-07 | Rensselaer | New York | 36083 | 759 | 35 |
251270 | 251270 | 2020-06-18 | Rensselaer | New York | 36083 | 515 | 36 |
254385 | 254385 | 2020-06-19 | Rensselaer | New York | 36083 | 519 | 36 |
413543 | 413543 | 2020-08-08 | Rensselaer | New York | 36083 | 761 | 36 |
248155 | 248155 | 2020-06-17 | Rensselaer | New York | 36083 | 515 | 37 |
257508 | 257508 | 2020-06-20 | Rensselaer | New York | 36083 | 521 | 37 |
260635 | 260635 | 2020-06-21 | Rensselaer | New York | 36083 | 524 | 37 |
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);