participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
16,126 rows where station_code = "US000N" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5130353 | 5130353 | 20240917113311_7Pjlp | US000N | 2024-09-19T12:13:05.089Z | 2024-09-19T12:13:05.089Z |
5130260 | 5130260 | 20240917104909_QVsr1 | US000N | 2024-09-19T12:12:51.965Z | 2024-09-19T12:12:51.965Z |
5130042 | 5130042 | 20240917082653_2lXGk | US000N | 2024-09-19T12:12:28.898Z | 2024-09-19T12:12:28.898Z |
5126438 | 5126438 | 20240918115044_FRJ8R | US000N | 2024-09-19T12:05:57.933Z | 2024-09-19T12:06:42.201Z |
5126347 | 5126347 | 20240918110919_oa1A2 | US000N | 2024-09-19T12:05:48.022Z | 2024-09-19T12:06:42.185Z |
5126219 | 5126219 | 20240918095132_6aAWk | US000N | 2024-09-19T12:05:22.907Z | 2024-09-19T12:06:42.163Z |
5126196 | 5126196 | 20240918092826_1syWv | US000N | 2024-09-19T12:05:19.781Z | 2024-09-19T12:06:42.159Z |
5126173 | 5126173 | 20240918090843_Pp2U2 | US000N | 2024-09-19T12:05:15.835Z | 2024-09-19T12:06:42.154Z |
5126131 | 5126131 | 20240918083512_whJvw | US000N | 2024-09-19T12:05:10.511Z | 2024-09-19T12:06:42.146Z |
5126103 | 5126103 | 20240918082135_wSh91 | US000N | 2024-09-19T12:05:07.034Z | 2024-09-19T12:06:42.141Z |
5123910 | 5123910 | 20240914115934_2Nh4b | US000N | 2024-09-18T12:11:59.807Z | 2024-09-19T12:20:16.485Z |
5123859 | 5123859 | 20240914114555_IygQn | US000N | 2024-09-18T12:11:58.788Z | 2024-09-19T12:20:15.803Z |
5123825 | 5123825 | 20240914114002_4M31b | US000N | 2024-09-18T12:11:58.388Z | 2024-09-19T12:20:15.607Z |
5123804 | 5123804 | 20240914113251_zMciC | US000N | 2024-09-18T12:11:57.954Z | 2024-09-19T12:20:15.395Z |
5123656 | 5123656 | 20240914105901_bTnx5 | US000N | 2024-09-18T12:11:53.194Z | 2024-09-19T12:20:13.494Z |
5123583 | 5123583 | 20240914103913_Mz634 | US000N | 2024-09-18T12:11:51.561Z | 2024-09-19T12:20:12.813Z |
5123439 | 5123439 | 20240914100532_xHF5v | US000N | 2024-09-18T12:11:48.817Z | 2024-09-19T12:20:11.052Z |
5123395 | 5123395 | 20240914095701_oaMMW | US000N | 2024-09-18T12:11:47.784Z | 2024-09-19T12:20:10.719Z |
5123321 | 5123321 | 20240914094526_LRK5o | US000N | 2024-09-18T12:11:45.254Z | 2024-09-19T12:20:10.357Z |
5123261 | 5123261 | 20240914092740_KUH3A | US000N | 2024-09-18T12:11:43.549Z | 2024-09-19T12:20:09.205Z |
5123196 | 5123196 | 20240914091520_PxtU3 | US000N | 2024-09-18T12:11:42.211Z | 2024-09-19T12:20:08.900Z |
5122992 | 5122992 | 20240914083604_3UeRk | US000N | 2024-09-18T12:11:37.163Z | 2024-09-19T12:20:07.129Z |
5122975 | 5122975 | 20240914082907_cQvaD | US000N | 2024-09-18T12:11:35.736Z | 2024-09-19T12:20:06.984Z |
5122704 | 5122704 | 20240914073259_0wz30 | US000N | 2024-09-18T12:11:28.799Z | 2024-09-19T12:20:05.789Z |
5122656 | 5122656 | 20240914072743_6eRGz | US000N | 2024-09-18T12:11:27.104Z | 2024-09-19T12:20:05.541Z |
5122567 | 5122567 | 20240914071125_l6QDM | US000N | 2024-09-18T12:11:23.486Z | 2024-09-19T12:20:05.052Z |
5120205 | 5120205 | 20240914030608_aMKbT | US000N | 2024-09-18T12:10:34.511Z | 2024-09-19T12:19:59.693Z |
5118565 | 5118565 | 20240915101711_QxOTn | US000N | 2024-09-18T12:08:51.197Z | 2024-09-19T12:19:23.892Z |
5118519 | 5118519 | 20240915100811_zgJ2F | US000N | 2024-09-18T12:08:49.624Z | 2024-09-19T12:19:23.531Z |
5118488 | 5118488 | 20240915095922_4rCuy | US000N | 2024-09-18T12:08:47.471Z | 2024-09-19T12:19:23.323Z |
5118390 | 5118390 | 20240915093543_58lZf | US000N | 2024-09-18T12:08:41.676Z | 2024-09-19T12:19:22.434Z |
5118374 | 5118374 | 20240915093002_ayp2f | US000N | 2024-09-18T12:08:40.781Z | 2024-09-19T12:19:22.392Z |
5118315 | 5118315 | 20240915091702_ChrM2 | US000N | 2024-09-18T12:08:37.255Z | 2024-09-19T12:19:22.039Z |
5118155 | 5118155 | 20240915084400_7Mjnj | US000N | 2024-09-18T12:08:27.252Z | 2024-09-19T12:19:20.913Z |
5118025 | 5118025 | 20240915080900_XoTTf | US000N | 2024-09-18T12:08:18.827Z | 2024-09-19T12:19:19.831Z |
5118001 | 5118001 | 20240915080748_MQqrQ | US000N | 2024-09-18T12:08:16.546Z | 2024-09-19T12:19:19.666Z |
5117866 | 5117866 | 20240915073131_Ugo0m | US000N | 2024-09-18T12:08:04.048Z | 2024-09-19T12:19:18.629Z |
5117782 | 5117782 | 20240915070142_AbVF2 | US000N | 2024-09-18T12:07:59.120Z | 2024-09-19T12:19:17.874Z |
5117536 | 5117536 | 20240915050830_EqqMS | US000N | 2024-09-18T12:07:45.696Z | 2024-09-19T12:19:15.796Z |
5117517 | 5117517 | 20240915045230_1K4ry | US000N | 2024-09-18T12:07:44.546Z | 2024-09-19T12:19:15.574Z |
5117489 | 5117489 | 20240915044248_DMBVl | US000N | 2024-09-18T12:07:42.871Z | 2024-09-19T12:19:15.424Z |
5109855 | 5109855 | 20240913112336_Nr4Sv | US000N | 2024-09-17T12:14:47.789Z | 2024-09-19T12:20:54.982Z |
5109428 | 5109428 | 20240913095302_3Bf3N | US000N | 2024-09-17T12:14:37.902Z | 2024-09-19T12:20:53.284Z |
5109367 | 5109367 | 20240913094006_vgsYb | US000N | 2024-09-17T12:14:36.636Z | 2024-09-19T12:20:53.148Z |
5109342 | 5109342 | 20240913093532_4obDF | US000N | 2024-09-17T12:14:35.973Z | 2024-09-19T12:20:53.032Z |
5109299 | 5109299 | 20240913092824_4EKvF | US000N | 2024-09-17T12:14:34.861Z | 2024-09-19T12:20:52.789Z |
5109204 | 5109204 | 20240913091304_Wb29D | US000N | 2024-09-17T12:14:33.284Z | 2024-09-19T12:20:52.490Z |
5109118 | 5109118 | 20240913085157_enIfO | US000N | 2024-09-17T12:14:30.719Z | 2024-09-19T12:20:51.769Z |
5109108 | 5109108 | 20240913084830_Itkfk | US000N | 2024-09-17T12:14:30.409Z | 2024-09-19T12:20:51.726Z |
5109077 | 5109077 | 20240913084227_p0Tve | US000N | 2024-09-17T12:14:29.539Z | 2024-09-19T12:20:51.634Z |
5108921 | 5108921 | 20240913080501_cQaoK | US000N | 2024-09-17T12:14:17.891Z | 2024-09-19T12:20:51.138Z |
5108885 | 5108885 | 20240913075546_eLW3P | US000N | 2024-09-17T12:14:14.109Z | 2024-09-19T12:20:51.006Z |
5108796 | 5108796 | 20240913073315_BYHQ1 | US000N | 2024-09-17T12:14:07.545Z | 2024-09-19T12:20:50.792Z |
5108792 | 5108792 | 20240913073041_tb62y | US000N | 2024-09-17T12:14:07.488Z | 2024-09-19T12:20:50.788Z |
5108522 | 5108522 | 20240913060907_hxVCe | US000N | 2024-09-17T12:13:49.590Z | 2024-09-19T12:20:49.242Z |
5108434 | 5108434 | 20240913053206_YWnWM | US000N | 2024-09-17T12:13:44.483Z | 2024-09-19T12:20:48.820Z |
5096711 | 5096711 | 20240912113301_Z6WWX | US000N | 2024-09-16T12:16:32.264Z | 2024-09-19T12:21:23.489Z |
5096636 | 5096636 | 20240912112600_Y5Yky | US000N | 2024-09-16T12:16:30.259Z | 2024-09-19T12:21:23.326Z |
5096616 | 5096616 | 20240912112339_wx4e2 | US000N | 2024-09-16T12:16:29.803Z | 2024-09-19T12:21:23.278Z |
5096585 | 5096585 | 20240912111729_BAn4w | US000N | 2024-09-16T12:16:28.010Z | 2024-09-19T12:21:22.919Z |
5096503 | 5096503 | 20240912110336_prhQP | US000N | 2024-09-16T12:16:25.390Z | 2024-09-19T12:21:22.421Z |
5096318 | 5096318 | 20240912103209_oCWos | US000N | 2024-09-16T12:16:19.971Z | 2024-09-19T12:21:22.104Z |
5096303 | 5096303 | 20240912103033_tu0ss | US000N | 2024-09-16T12:16:19.434Z | 2024-09-19T12:21:22.048Z |
5096181 | 5096181 | 20240912101247_mnzUW | US000N | 2024-09-16T12:16:13.612Z | 2024-09-19T12:21:21.798Z |
5096076 | 5096076 | 20240912095223_cpO6c | US000N | 2024-09-16T12:16:08.616Z | 2024-09-19T12:21:21.269Z |
5096040 | 5096040 | 20240912094445_0hmty | US000N | 2024-09-16T12:16:06.013Z | 2024-09-19T12:21:21.066Z |
5095885 | 5095885 | 20240912092115_E0F4m | US000N | 2024-09-16T12:16:01.351Z | 2024-09-19T12:21:20.585Z |
5095871 | 5095871 | 20240912092010_pigyd | US000N | 2024-09-16T12:16:01.022Z | 2024-09-19T12:21:20.577Z |
5095611 | 5095611 | 20240912082845_xtlVE | US000N | 2024-09-16T12:15:51.199Z | 2024-09-19T12:21:19.297Z |
5095602 | 5095602 | 20240912082437_j9zUx | US000N | 2024-09-16T12:15:50.446Z | 2024-09-19T12:21:19.214Z |
5082356 | 5082356 | 20240911095617_8AOV8 | US000N | 2024-09-15T12:18:12.207Z | 2024-09-19T12:21:47.859Z |
5082347 | 5082347 | 20240911095606_hYS7g | US000N | 2024-09-15T12:18:12.009Z | 2024-09-19T12:21:47.829Z |
5082324 | 5082324 | 20240911095258_sAyum | US000N | 2024-09-15T12:18:11.185Z | 2024-09-19T12:21:47.774Z |
5082256 | 5082256 | 20240911094511_Gjyuo | US000N | 2024-09-15T12:18:09.523Z | 2024-09-19T12:21:47.612Z |
5082200 | 5082200 | 20240911093554_mViXm | US000N | 2024-09-15T12:18:06.484Z | 2024-09-19T12:21:47.466Z |
5081775 | 5081775 | 20240911084118_cGHU7 | US000N | 2024-09-15T12:17:46.739Z | 2024-09-19T12:21:46.406Z |
5081366 | 5081366 | 20240911073107_h9hiZ | US000N | 2024-09-15T12:17:31.478Z | 2024-09-19T12:21:45.185Z |
5068500 | 5068500 | 20240910114223_dUvpT | US000N | 2024-09-14T12:19:16.819Z | 2024-09-18T12:15:26.236Z |
5068353 | 5068353 | 20240910112319_XwT0O | US000N | 2024-09-14T12:19:12.993Z | 2024-09-18T12:15:25.970Z |
5068003 | 5068003 | 20240910103949_L2bQV | US000N | 2024-09-14T12:19:06.636Z | 2024-09-18T12:15:25.356Z |
5067185 | 5067185 | 20240910090337_vA4Do | US000N | 2024-09-14T12:18:34.855Z | 2024-09-18T12:15:23.534Z |
5067168 | 5067168 | 20240910090216_BJy03 | US000N | 2024-09-14T12:18:34.507Z | 2024-09-18T12:15:23.508Z |
5066857 | 5066857 | 20240910082500_ihyJZ | US000N | 2024-09-14T12:18:16.553Z | 2024-09-18T12:15:22.867Z |
5066827 | 5066827 | 20240910082125_A2wcW | US000N | 2024-09-14T12:18:15.286Z | 2024-09-18T12:15:22.818Z |
5066760 | 5066760 | 20240910081332_jTrvw | US000N | 2024-09-14T12:18:10.899Z | 2024-09-18T12:15:22.716Z |
5066559 | 5066559 | 20240910074918_3TrhY | US000N | 2024-09-14T12:18:02.733Z | 2024-09-18T12:15:22.178Z |
5066056 | 5066056 | 20240910062759_jTlA7 | US000N | 2024-09-14T12:17:36.967Z | 2024-09-18T12:15:21.056Z |
5066000 | 5066000 | 20240910061545_YMzHD | US000N | 2024-09-14T12:17:34.528Z | 2024-09-18T12:15:20.969Z |
5065986 | 5065986 | 20240910061410_t8Upt | US000N | 2024-09-14T12:17:33.253Z | 2024-09-18T12:15:20.944Z |
5056870 | 5056870 | 20240908113403_0Q83j | US000N | 2024-09-13T12:17:40.328Z | 2024-09-16T12:21:27.588Z |
5056775 | 5056775 | 20240908112222_KMnP9 | US000N | 2024-09-13T12:17:39.219Z | 2024-09-16T12:21:27.273Z |
5056488 | 5056488 | 20240908103352_8X3uS | US000N | 2024-09-13T12:17:33.752Z | 2024-09-16T12:21:25.539Z |
5056482 | 5056482 | 20240908103350_0eUiF | US000N | 2024-09-13T12:17:33.712Z | 2024-09-16T12:21:25.537Z |
5056371 | 5056371 | 20240908101831_Ybj9i | US000N | 2024-09-13T12:17:30.846Z | 2024-09-16T12:21:24.552Z |
5056278 | 5056278 | 20240908100504_gcxvJ | US000N | 2024-09-13T12:17:29.567Z | 2024-09-16T12:21:24.166Z |
5056160 | 5056160 | 20240908094836_D6ou1 | US000N | 2024-09-13T12:17:28.076Z | 2024-09-16T12:21:23.607Z |
5055881 | 5055881 | 20240908091329_4dw2P | US000N | 2024-09-13T12:17:24.606Z | 2024-09-16T12:21:22.367Z |
5055529 | 5055529 | 20240908081940_gN36J | US000N | 2024-09-13T12:17:16.318Z | 2024-09-16T12:21:20.246Z |
5055199 | 5055199 | 20240908072031_c13Xj | US000N | 2024-09-13T12:17:07.447Z | 2024-09-16T12:21:18.339Z |
5054888 | 5054888 | 20240908044802_zrycT | US000N | 2024-09-13T12:16:57.962Z | 2024-09-16T12:21:17.116Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);