ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Montgomery" and fips = 36057 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501454 | 2501454 | 2022-05-13 | Montgomery | New York | 36057 | 12471 | 205 |
2498196 | 2498196 | 2022-05-12 | Montgomery | New York | 36057 | 12471 | 205 |
2494938 | 2494938 | 2022-05-11 | Montgomery | New York | 36057 | 12444 | 205 |
2491680 | 2491680 | 2022-05-10 | Montgomery | New York | 36057 | 12422 | 205 |
2488422 | 2488422 | 2022-05-09 | Montgomery | New York | 36057 | 12401 | 204 |
2485165 | 2485165 | 2022-05-08 | Montgomery | New York | 36057 | 12379 | 204 |
2481907 | 2481907 | 2022-05-07 | Montgomery | New York | 36057 | 12350 | 204 |
2478649 | 2478649 | 2022-05-06 | Montgomery | New York | 36057 | 12331 | 204 |
2475391 | 2475391 | 2022-05-05 | Montgomery | New York | 36057 | 12320 | 204 |
2472134 | 2472134 | 2022-05-04 | Montgomery | New York | 36057 | 12300 | 204 |
2468878 | 2468878 | 2022-05-03 | Montgomery | New York | 36057 | 12274 | 204 |
2465622 | 2465622 | 2022-05-02 | Montgomery | New York | 36057 | 12260 | 204 |
2462367 | 2462367 | 2022-05-01 | Montgomery | New York | 36057 | 12246 | 204 |
2459111 | 2459111 | 2022-04-30 | Montgomery | New York | 36057 | 12236 | 204 |
2455855 | 2455855 | 2022-04-29 | Montgomery | New York | 36057 | 12215 | 204 |
2452599 | 2452599 | 2022-04-28 | Montgomery | New York | 36057 | 12199 | 204 |
2449343 | 2449343 | 2022-04-27 | Montgomery | New York | 36057 | 12169 | 204 |
2446086 | 2446086 | 2022-04-26 | Montgomery | New York | 36057 | 12154 | 204 |
2442831 | 2442831 | 2022-04-25 | Montgomery | New York | 36057 | 12134 | 204 |
2439575 | 2439575 | 2022-04-24 | Montgomery | New York | 36057 | 12122 | 204 |
2436319 | 2436319 | 2022-04-23 | Montgomery | New York | 36057 | 12111 | 204 |
2433063 | 2433063 | 2022-04-22 | Montgomery | New York | 36057 | 12097 | 204 |
2429807 | 2429807 | 2022-04-21 | Montgomery | New York | 36057 | 12082 | 204 |
2426551 | 2426551 | 2022-04-20 | Montgomery | New York | 36057 | 12060 | 203 |
2423295 | 2423295 | 2022-04-19 | Montgomery | New York | 36057 | 12049 | 203 |
2420038 | 2420038 | 2022-04-18 | Montgomery | New York | 36057 | 12045 | 203 |
2416783 | 2416783 | 2022-04-17 | Montgomery | New York | 36057 | 12035 | 203 |
2413527 | 2413527 | 2022-04-16 | Montgomery | New York | 36057 | 12015 | 203 |
2410271 | 2410271 | 2022-04-15 | Montgomery | New York | 36057 | 12003 | 203 |
2407015 | 2407015 | 2022-04-14 | Montgomery | New York | 36057 | 11998 | 203 |
2403759 | 2403759 | 2022-04-13 | Montgomery | New York | 36057 | 11977 | 203 |
2400504 | 2400504 | 2022-04-12 | Montgomery | New York | 36057 | 11971 | 203 |
2397249 | 2397249 | 2022-04-11 | Montgomery | New York | 36057 | 11961 | 203 |
2393994 | 2393994 | 2022-04-10 | Montgomery | New York | 36057 | 11951 | 203 |
2390738 | 2390738 | 2022-04-09 | Montgomery | New York | 36057 | 11942 | 203 |
2387482 | 2387482 | 2022-04-08 | Montgomery | New York | 36057 | 11930 | 203 |
2384227 | 2384227 | 2022-04-07 | Montgomery | New York | 36057 | 11917 | 203 |
2380972 | 2380972 | 2022-04-06 | Montgomery | New York | 36057 | 11907 | 203 |
2377717 | 2377717 | 2022-04-05 | Montgomery | New York | 36057 | 11900 | 203 |
2374464 | 2374464 | 2022-04-04 | Montgomery | New York | 36057 | 11892 | 203 |
2371212 | 2371212 | 2022-04-03 | Montgomery | New York | 36057 | 11888 | 203 |
2367959 | 2367959 | 2022-04-02 | Montgomery | New York | 36057 | 11880 | 203 |
2364706 | 2364706 | 2022-04-01 | Montgomery | New York | 36057 | 11873 | 203 |
2361452 | 2361452 | 2022-03-31 | Montgomery | New York | 36057 | 11868 | 203 |
2358198 | 2358198 | 2022-03-30 | Montgomery | New York | 36057 | 11851 | 203 |
2354944 | 2354944 | 2022-03-29 | Montgomery | New York | 36057 | 11836 | 203 |
2351691 | 2351691 | 2022-03-28 | Montgomery | New York | 36057 | 11825 | 202 |
2348439 | 2348439 | 2022-03-27 | Montgomery | New York | 36057 | 11818 | 202 |
2345186 | 2345186 | 2022-03-26 | Montgomery | New York | 36057 | 11813 | 202 |
2341933 | 2341933 | 2022-03-25 | Montgomery | New York | 36057 | 11809 | 202 |
2338680 | 2338680 | 2022-03-24 | Montgomery | New York | 36057 | 11803 | 202 |
2335426 | 2335426 | 2022-03-23 | Montgomery | New York | 36057 | 11794 | 202 |
2332172 | 2332172 | 2022-03-22 | Montgomery | New York | 36057 | 11776 | 202 |
2328919 | 2328919 | 2022-03-21 | Montgomery | New York | 36057 | 11775 | 202 |
2325667 | 2325667 | 2022-03-20 | Montgomery | New York | 36057 | 11773 | 202 |
2322414 | 2322414 | 2022-03-19 | Montgomery | New York | 36057 | 11767 | 202 |
2319160 | 2319160 | 2022-03-18 | Montgomery | New York | 36057 | 11763 | 202 |
2315906 | 2315906 | 2022-03-17 | Montgomery | New York | 36057 | 11757 | 202 |
2312653 | 2312653 | 2022-03-16 | Montgomery | New York | 36057 | 11754 | 201 |
2309400 | 2309400 | 2022-03-15 | Montgomery | New York | 36057 | 11748 | 201 |
2306147 | 2306147 | 2022-03-14 | Montgomery | New York | 36057 | 11743 | 199 |
2302896 | 2302896 | 2022-03-13 | Montgomery | New York | 36057 | 11738 | 199 |
2299644 | 2299644 | 2022-03-12 | Montgomery | New York | 36057 | 11731 | 199 |
2296392 | 2296392 | 2022-03-11 | Montgomery | New York | 36057 | 11721 | 199 |
2293140 | 2293140 | 2022-03-10 | Montgomery | New York | 36057 | 11712 | 199 |
2289888 | 2289888 | 2022-03-09 | Montgomery | New York | 36057 | 11710 | 199 |
2286636 | 2286636 | 2022-03-08 | Montgomery | New York | 36057 | 11705 | 199 |
2283384 | 2283384 | 2022-03-07 | Montgomery | New York | 36057 | 11701 | 199 |
2280132 | 2280132 | 2022-03-06 | Montgomery | New York | 36057 | 11695 | 199 |
2276879 | 2276879 | 2022-03-05 | Montgomery | New York | 36057 | 11687 | 199 |
2273626 | 2273626 | 2022-03-04 | Montgomery | New York | 36057 | 11672 | 199 |
2270373 | 2270373 | 2022-03-03 | Montgomery | New York | 36057 | 11672 | 199 |
2267121 | 2267121 | 2022-03-02 | Montgomery | New York | 36057 | 11669 | 198 |
2263869 | 2263869 | 2022-03-01 | Montgomery | New York | 36057 | 11661 | 198 |
2260618 | 2260618 | 2022-02-28 | Montgomery | New York | 36057 | 11653 | 197 |
2257367 | 2257367 | 2022-02-27 | Montgomery | New York | 36057 | 11652 | 197 |
2254116 | 2254116 | 2022-02-26 | Montgomery | New York | 36057 | 11651 | 197 |
2250865 | 2250865 | 2022-02-25 | Montgomery | New York | 36057 | 11644 | 197 |
2247614 | 2247614 | 2022-02-24 | Montgomery | New York | 36057 | 11634 | 197 |
2244363 | 2244363 | 2022-02-23 | Montgomery | New York | 36057 | 11626 | 196 |
2241112 | 2241112 | 2022-02-22 | Montgomery | New York | 36057 | 11613 | 195 |
2237861 | 2237861 | 2022-02-21 | Montgomery | New York | 36057 | 11611 | 195 |
2234610 | 2234610 | 2022-02-20 | Montgomery | New York | 36057 | 11603 | 194 |
2231359 | 2231359 | 2022-02-19 | Montgomery | New York | 36057 | 11589 | 194 |
2228108 | 2228108 | 2022-02-18 | Montgomery | New York | 36057 | 11565 | 194 |
2224857 | 2224857 | 2022-02-17 | Montgomery | New York | 36057 | 11546 | 194 |
2221606 | 2221606 | 2022-02-16 | Montgomery | New York | 36057 | 11532 | 194 |
2218355 | 2218355 | 2022-02-15 | Montgomery | New York | 36057 | 11516 | 194 |
2215104 | 2215104 | 2022-02-14 | Montgomery | New York | 36057 | 11504 | 194 |
2211853 | 2211853 | 2022-02-13 | Montgomery | New York | 36057 | 11493 | 194 |
2208600 | 2208600 | 2022-02-12 | Montgomery | New York | 36057 | 11486 | 194 |
2205347 | 2205347 | 2022-02-11 | Montgomery | New York | 36057 | 11460 | 194 |
2202094 | 2202094 | 2022-02-10 | Montgomery | New York | 36057 | 11433 | 194 |
2198840 | 2198840 | 2022-02-09 | Montgomery | New York | 36057 | 11387 | 193 |
2195586 | 2195586 | 2022-02-08 | Montgomery | New York | 36057 | 11356 | 193 |
2192332 | 2192332 | 2022-02-07 | Montgomery | New York | 36057 | 11334 | 191 |
2189078 | 2189078 | 2022-02-06 | Montgomery | New York | 36057 | 11322 | 189 |
2185825 | 2185825 | 2022-02-05 | Montgomery | New York | 36057 | 11289 | 188 |
2182573 | 2182573 | 2022-02-04 | Montgomery | New York | 36057 | 11272 | 187 |
2179321 | 2179321 | 2022-02-03 | Montgomery | New York | 36057 | 11241 | 187 |
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);