ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Cameron" and fips = 42023 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 |
---|---|---|---|---|---|---|---|
2501858 | 2501858 | 2022-05-13 | Cameron | Pennsylvania | 42023 | 822 | 21 |
2498600 | 2498600 | 2022-05-12 | Cameron | Pennsylvania | 42023 | 822 | 21 |
2495342 | 2495342 | 2022-05-11 | Cameron | Pennsylvania | 42023 | 822 | 21 |
2492084 | 2492084 | 2022-05-10 | Cameron | Pennsylvania | 42023 | 816 | 21 |
2488826 | 2488826 | 2022-05-09 | Cameron | Pennsylvania | 42023 | 816 | 21 |
2485569 | 2485569 | 2022-05-08 | Cameron | Pennsylvania | 42023 | 816 | 21 |
2482311 | 2482311 | 2022-05-07 | Cameron | Pennsylvania | 42023 | 816 | 21 |
2479053 | 2479053 | 2022-05-06 | Cameron | Pennsylvania | 42023 | 816 | 21 |
2475795 | 2475795 | 2022-05-05 | Cameron | Pennsylvania | 42023 | 816 | 21 |
2472538 | 2472538 | 2022-05-04 | Cameron | Pennsylvania | 42023 | 816 | 21 |
2469282 | 2469282 | 2022-05-03 | Cameron | Pennsylvania | 42023 | 816 | 21 |
2466026 | 2466026 | 2022-05-02 | Cameron | Pennsylvania | 42023 | 816 | 20 |
2462771 | 2462771 | 2022-05-01 | Cameron | Pennsylvania | 42023 | 816 | 20 |
2459515 | 2459515 | 2022-04-30 | Cameron | Pennsylvania | 42023 | 816 | 20 |
2456259 | 2456259 | 2022-04-29 | Cameron | Pennsylvania | 42023 | 816 | 20 |
2453003 | 2453003 | 2022-04-28 | Cameron | Pennsylvania | 42023 | 816 | 20 |
2449747 | 2449747 | 2022-04-27 | Cameron | Pennsylvania | 42023 | 816 | 20 |
2446490 | 2446490 | 2022-04-26 | Cameron | Pennsylvania | 42023 | 816 | 20 |
2443235 | 2443235 | 2022-04-25 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2439979 | 2439979 | 2022-04-24 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2436723 | 2436723 | 2022-04-23 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2433467 | 2433467 | 2022-04-22 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2430211 | 2430211 | 2022-04-21 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2426955 | 2426955 | 2022-04-20 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2423699 | 2423699 | 2022-04-19 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2420443 | 2420443 | 2022-04-18 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2417187 | 2417187 | 2022-04-17 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2413931 | 2413931 | 2022-04-16 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2410675 | 2410675 | 2022-04-15 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2407419 | 2407419 | 2022-04-14 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2404163 | 2404163 | 2022-04-13 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2400908 | 2400908 | 2022-04-12 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2397653 | 2397653 | 2022-04-11 | Cameron | Pennsylvania | 42023 | 815 | 20 |
2394398 | 2394398 | 2022-04-10 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2391142 | 2391142 | 2022-04-09 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2387886 | 2387886 | 2022-04-08 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2384631 | 2384631 | 2022-04-07 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2381376 | 2381376 | 2022-04-06 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2378121 | 2378121 | 2022-04-05 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2374867 | 2374867 | 2022-04-04 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2371615 | 2371615 | 2022-04-03 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2368362 | 2368362 | 2022-04-02 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2365109 | 2365109 | 2022-04-01 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2361856 | 2361856 | 2022-03-31 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2358602 | 2358602 | 2022-03-30 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2355348 | 2355348 | 2022-03-29 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2352095 | 2352095 | 2022-03-28 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2348843 | 2348843 | 2022-03-27 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2345590 | 2345590 | 2022-03-26 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2342337 | 2342337 | 2022-03-25 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2339084 | 2339084 | 2022-03-24 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2335830 | 2335830 | 2022-03-23 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2332576 | 2332576 | 2022-03-22 | Cameron | Pennsylvania | 42023 | 814 | 20 |
2329323 | 2329323 | 2022-03-21 | Cameron | Pennsylvania | 42023 | 814 | 19 |
2326071 | 2326071 | 2022-03-20 | Cameron | Pennsylvania | 42023 | 814 | 19 |
2322818 | 2322818 | 2022-03-19 | Cameron | Pennsylvania | 42023 | 814 | 19 |
2319564 | 2319564 | 2022-03-18 | Cameron | Pennsylvania | 42023 | 814 | 19 |
2316310 | 2316310 | 2022-03-17 | Cameron | Pennsylvania | 42023 | 814 | 19 |
2313057 | 2313057 | 2022-03-16 | Cameron | Pennsylvania | 42023 | 814 | 19 |
2309804 | 2309804 | 2022-03-15 | Cameron | Pennsylvania | 42023 | 813 | 19 |
2306551 | 2306551 | 2022-03-14 | Cameron | Pennsylvania | 42023 | 813 | 19 |
2303300 | 2303300 | 2022-03-13 | Cameron | Pennsylvania | 42023 | 813 | 19 |
2300048 | 2300048 | 2022-03-12 | Cameron | Pennsylvania | 42023 | 813 | 19 |
2296796 | 2296796 | 2022-03-11 | Cameron | Pennsylvania | 42023 | 813 | 19 |
2293544 | 2293544 | 2022-03-10 | Cameron | Pennsylvania | 42023 | 813 | 19 |
2290292 | 2290292 | 2022-03-09 | Cameron | Pennsylvania | 42023 | 813 | 19 |
2287040 | 2287040 | 2022-03-08 | Cameron | Pennsylvania | 42023 | 813 | 19 |
2283788 | 2283788 | 2022-03-07 | Cameron | Pennsylvania | 42023 | 813 | 19 |
2280536 | 2280536 | 2022-03-06 | Cameron | Pennsylvania | 42023 | 813 | 19 |
2277283 | 2277283 | 2022-03-05 | Cameron | Pennsylvania | 42023 | 813 | 19 |
2274030 | 2274030 | 2022-03-04 | Cameron | Pennsylvania | 42023 | 813 | 19 |
2270777 | 2270777 | 2022-03-03 | Cameron | Pennsylvania | 42023 | 812 | 19 |
2267525 | 2267525 | 2022-03-02 | Cameron | Pennsylvania | 42023 | 812 | 19 |
2264272 | 2264272 | 2022-03-01 | Cameron | Pennsylvania | 42023 | 812 | 19 |
2261022 | 2261022 | 2022-02-28 | Cameron | Pennsylvania | 42023 | 811 | 19 |
2257771 | 2257771 | 2022-02-27 | Cameron | Pennsylvania | 42023 | 811 | 19 |
2254520 | 2254520 | 2022-02-26 | Cameron | Pennsylvania | 42023 | 811 | 19 |
2251269 | 2251269 | 2022-02-25 | Cameron | Pennsylvania | 42023 | 811 | 19 |
2248018 | 2248018 | 2022-02-24 | Cameron | Pennsylvania | 42023 | 811 | 19 |
2244767 | 2244767 | 2022-02-23 | Cameron | Pennsylvania | 42023 | 807 | 19 |
2241516 | 2241516 | 2022-02-22 | Cameron | Pennsylvania | 42023 | 807 | 19 |
2238265 | 2238265 | 2022-02-21 | Cameron | Pennsylvania | 42023 | 806 | 19 |
2235014 | 2235014 | 2022-02-20 | Cameron | Pennsylvania | 42023 | 806 | 19 |
2231763 | 2231763 | 2022-02-19 | Cameron | Pennsylvania | 42023 | 804 | 19 |
2228512 | 2228512 | 2022-02-18 | Cameron | Pennsylvania | 42023 | 802 | 19 |
2225261 | 2225261 | 2022-02-17 | Cameron | Pennsylvania | 42023 | 800 | 19 |
2222010 | 2222010 | 2022-02-16 | Cameron | Pennsylvania | 42023 | 800 | 19 |
2218759 | 2218759 | 2022-02-15 | Cameron | Pennsylvania | 42023 | 800 | 19 |
2215508 | 2215508 | 2022-02-14 | Cameron | Pennsylvania | 42023 | 800 | 19 |
2212257 | 2212257 | 2022-02-13 | Cameron | Pennsylvania | 42023 | 800 | 19 |
2209004 | 2209004 | 2022-02-12 | Cameron | Pennsylvania | 42023 | 801 | 19 |
2205751 | 2205751 | 2022-02-11 | Cameron | Pennsylvania | 42023 | 799 | 19 |
2202498 | 2202498 | 2022-02-10 | Cameron | Pennsylvania | 42023 | 798 | 19 |
2199244 | 2199244 | 2022-02-09 | Cameron | Pennsylvania | 42023 | 798 | 19 |
2195990 | 2195990 | 2022-02-08 | Cameron | Pennsylvania | 42023 | 788 | 19 |
2192736 | 2192736 | 2022-02-07 | Cameron | Pennsylvania | 42023 | 785 | 19 |
2189482 | 2189482 | 2022-02-06 | Cameron | Pennsylvania | 42023 | 784 | 19 |
2186229 | 2186229 | 2022-02-05 | Cameron | Pennsylvania | 42023 | 783 | 18 |
2182977 | 2182977 | 2022-02-04 | Cameron | Pennsylvania | 42023 | 781 | 18 |
2179725 | 2179725 | 2022-02-03 | Cameron | Pennsylvania | 42023 | 776 | 18 |
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);