participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,613 rows where station_code = "AU000R" 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 |
---|---|---|---|---|---|
5084210 | 5084210 | 20240912185907_sr4tr | AU000R | 2024-09-16T12:01:35.114Z | 2024-09-16T12:17:04.183Z |
5084013 | 5084013 | 20240912173709_f5u8Y | AU000R | 2024-09-16T12:00:55.513Z | 2024-09-16T12:17:04.037Z |
5071837 | 5071837 | 20240911183340_nxtLf | AU000R | 2024-09-15T12:03:48.631Z | 2024-09-16T12:17:28.954Z |
5071779 | 5071779 | 20240911181743_uzexI | AU000R | 2024-09-15T12:03:31.167Z | 2024-09-16T12:17:28.939Z |
5071777 | 5071777 | 20240911181743_gBtR2 | AU000R | 2024-09-15T12:03:30.676Z | 2024-09-16T12:17:28.938Z |
5071693 | 5071693 | 20240911175238_vP1YB | AU000R | 2024-09-15T12:03:16.325Z | 2024-09-16T12:17:28.898Z |
5071141 | 5071141 | 20240911160429_ChWhJ | AU000R | 2024-09-15T12:01:46.377Z | 2024-09-16T12:17:28.744Z |
5063011 | 5063011 | 20240909193628_WLJYK | AU000R | 2024-09-14T12:13:17.683Z | 2024-09-16T12:19:41.323Z |
5062906 | 5062906 | 20240909185844_dxDz8 | AU000R | 2024-09-14T12:13:02.085Z | 2024-09-16T12:19:40.203Z |
5062772 | 5062772 | 20240909182057_aQ77N | AU000R | 2024-09-14T12:12:49.271Z | 2024-09-16T12:19:39.529Z |
5062704 | 5062704 | 20240909180345_AQjVS | AU000R | 2024-09-14T12:12:44.325Z | 2024-09-16T12:19:38.851Z |
5062640 | 5062640 | 20240909175358_rkmTd | AU000R | 2024-09-14T12:12:40.133Z | 2024-09-16T12:19:38.274Z |
5062608 | 5062608 | 20240909174632_6o2Hi | AU000R | 2024-09-14T12:12:36.826Z | 2024-09-16T12:19:38.015Z |
5062358 | 5062358 | 20240909171450_HLE2y | AU000R | 2024-09-14T12:12:13.070Z | 2024-09-16T12:19:37.067Z |
5062231 | 5062231 | 20240909170145_sYnbl | AU000R | 2024-09-14T12:11:57.552Z | 2024-09-16T12:19:36.680Z |
5062049 | 5062049 | 20240909163801_32oTS | AU000R | 2024-09-14T12:11:46.681Z | 2024-09-16T12:19:35.372Z |
5062042 | 5062042 | 20240909163607_b1GI5 | AU000R | 2024-09-14T12:11:46.314Z | 2024-09-16T12:19:35.360Z |
5061225 | 5061225 | 20240909143413_z9vDc | AU000R | 2024-09-14T12:10:35.890Z | 2024-09-16T12:19:29.883Z |
5060899 | 5060899 | 20240909131830_PBKwt | AU000R | 2024-09-14T12:09:54.533Z | 2024-09-16T12:19:28.127Z |
5059830 | 5059830 | 20240910190102_LuHV0 | AU000R | 2024-09-14T12:07:22.208Z | 2024-09-16T12:18:09.130Z |
5059783 | 5059783 | 20240910185253_kQgoi | AU000R | 2024-09-14T12:07:11.543Z | 2024-09-16T12:18:08.381Z |
5059645 | 5059645 | 20240910182227_w2Bu3 | AU000R | 2024-09-14T12:06:39.301Z | 2024-09-16T12:18:06.683Z |
5059262 | 5059262 | 20240910172709_4icXi | AU000R | 2024-09-14T12:05:34.496Z | 2024-09-16T12:18:03.259Z |
5059170 | 5059170 | 20240910171922_X2DOB | AU000R | 2024-09-14T12:05:23.253Z | 2024-09-16T12:18:02.485Z |
5058873 | 5058873 | 20240910165348_Kc11F | AU000R | 2024-09-14T12:04:43.469Z | 2024-09-16T12:17:59.279Z |
5058141 | 5058141 | 20240910154755_d3zJj | AU000R | 2024-09-14T12:03:01.603Z | 2024-09-16T12:17:50.570Z |
5058070 | 5058070 | 20240910154106_02PGn | AU000R | 2024-09-14T12:02:50.540Z | 2024-09-16T12:17:49.821Z |
5052007 | 5052007 | 20240907192614_nUdf3 | AU000R | 2024-09-13T12:14:53.157Z | 2024-09-16T12:21:03.089Z |
5051930 | 5051930 | 20240907190750_fwWze | AU000R | 2024-09-13T12:14:46.661Z | 2024-09-16T12:21:02.522Z |
5051774 | 5051774 | 20240907183433_3Baks | AU000R | 2024-09-13T12:14:33.214Z | 2024-09-16T12:21:01.845Z |
5051720 | 5051720 | 20240907182919_5RXtF | AU000R | 2024-09-13T12:14:30.599Z | 2024-09-16T12:21:01.662Z |
5051717 | 5051717 | 20240907182702_Y63MR | AU000R | 2024-09-13T12:14:30.516Z | 2024-09-16T12:21:01.660Z |
5051673 | 5051673 | 20240907181922_D3jPw | AU000R | 2024-09-13T12:14:28.747Z | 2024-09-16T12:21:01.536Z |
5051153 | 5051153 | 20240907165559_fWNsf | AU000R | 2024-09-13T12:14:04.610Z | 2024-09-16T12:20:59.745Z |
5050693 | 5050693 | 20240907160003_e6PAP | AU000R | 2024-09-13T12:13:43.981Z | 2024-09-16T12:20:58.358Z |
5049511 | 5049511 | 20240909110739_oVTPy | AU000R | 2024-09-13T12:12:16.325Z | 2024-09-16T12:20:43.108Z |
5045738 | 5045738 | 20240908184440_kfO60 | AU000R | 2024-09-13T12:04:49.975Z | 2024-09-16T12:20:27.217Z |
5035317 | 5035317 | 20240907091900_b2Nte | AU000R | 2024-09-12T12:12:00.247Z | 2024-09-15T12:21:39.344Z |
5030914 | 5030914 | 20240906192840_g0ZM1 | AU000R | 2024-09-12T12:03:23.965Z | 2024-09-15T12:21:20.385Z |
5030858 | 5030858 | 20240906191051_jvkxe | AU000R | 2024-09-12T12:03:15.670Z | 2024-09-15T12:21:20.172Z |
5030753 | 5030753 | 20240906182215_R0wgX | AU000R | 2024-09-12T12:02:56.157Z | 2024-09-15T12:21:19.549Z |
5030711 | 5030711 | 20240906175207_NWDzV | AU000R | 2024-09-12T12:02:43.556Z | 2024-09-15T12:21:19.494Z |
5006959 | 5006959 | 20240903193544_K0qKS | AU000R | 2024-09-09T12:05:15.665Z | 2024-09-12T12:19:10.965Z |
5006852 | 5006852 | 20240903191209_yJhb0 | AU000R | 2024-09-09T12:05:08.705Z | 2024-09-12T12:19:10.391Z |
5006741 | 5006741 | 20240903184451_I9cgA | AU000R | 2024-09-09T12:04:58.623Z | 2024-09-12T12:19:09.377Z |
5006707 | 5006707 | 20240903183615_9mUiH | AU000R | 2024-09-09T12:04:56.600Z | 2024-09-12T12:19:09.266Z |
5006702 | 5006702 | 20240903183238_snO1q | AU000R | 2024-09-09T12:04:55.969Z | 2024-09-12T12:19:09.252Z |
5006414 | 5006414 | 20240903173410_tbpRe | AU000R | 2024-09-09T12:04:38.360Z | 2024-09-12T12:19:08.260Z |
5006329 | 5006329 | 20240903172351_MzAfO | AU000R | 2024-09-09T12:04:31.114Z | 2024-09-12T12:19:08.140Z |
5006055 | 5006055 | 20240903164939_7Je5l | AU000R | 2024-09-09T12:04:18.301Z | 2024-09-12T12:19:07.555Z |
5005753 | 5005753 | 20240903160506_DHQQT | AU000R | 2024-09-09T12:04:02.140Z | 2024-09-12T12:19:06.556Z |
5005353 | 5005353 | 20240903145705_yTgxv | AU000R | 2024-09-09T12:03:38.503Z | 2024-09-12T12:19:05.800Z |
5005185 | 5005185 | 20240903142648_T1dCn | AU000R | 2024-09-09T12:03:25.413Z | 2024-09-12T12:19:05.422Z |
5005098 | 5005098 | 20240903135849_RhC7s | AU000R | 2024-09-09T12:03:20.001Z | 2024-09-12T12:19:05.249Z |
5005011 | 5005011 | 20240903134729_bCX2h | AU000R | 2024-09-09T12:03:15.852Z | 2024-09-12T12:19:05.152Z |
5004742 | 5004742 | 20240903122244_fjFCd | AU000R | 2024-09-09T12:02:57.868Z | 2024-09-12T12:19:03.703Z |
5004092 | 5004092 | 20240903103958_Jxi3I | AU000R | 2024-09-09T12:02:21.501Z | 2024-09-12T12:19:00.773Z |
5003885 | 5003885 | 20240903100958_0xQwC | AU000R | 2024-09-09T12:02:10.774Z | 2024-09-12T12:19:00.080Z |
4996356 | 4996356 | 20240902192313_4n5Qd | AU000R | 2024-09-08T12:04:43.902Z | 2024-09-11T12:20:53.163Z |
4996229 | 4996229 | 20240902190236_oPrwC | AU000R | 2024-09-08T12:04:34.708Z | 2024-09-11T12:20:51.947Z |
4995971 | 4995971 | 20240902182155_bYCC0 | AU000R | 2024-09-08T12:04:14.823Z | 2024-09-11T12:20:50.000Z |
4995755 | 4995755 | 20240902174813_1UaMA | AU000R | 2024-09-08T12:04:03.057Z | 2024-09-11T12:20:47.985Z |
4995536 | 4995536 | 20240902171439_lFziN | AU000R | 2024-09-08T12:03:45.209Z | 2024-09-11T12:20:46.171Z |
4995509 | 4995509 | 20240902171113_Xoi0h | AU000R | 2024-09-08T12:03:43.658Z | 2024-09-11T12:20:45.978Z |
4995279 | 4995279 | 20240902163454_aCDjf | AU000R | 2024-09-08T12:03:30.364Z | 2024-09-11T12:20:43.242Z |
4994944 | 4994944 | 20240902153902_3h53r | AU000R | 2024-09-08T12:03:07.413Z | 2024-09-11T12:20:40.610Z |
4994416 | 4994416 | 20240902135601_Djs0X | AU000R | 2024-09-08T12:02:33.644Z | 2024-09-11T12:20:33.701Z |
4994184 | 4994184 | 20240902124012_3yCas | AU000R | 2024-09-08T12:02:17.550Z | 2024-09-11T12:20:31.209Z |
4994118 | 4994118 | 20240902122153_S1G0B | AU000R | 2024-09-08T12:02:13.206Z | 2024-09-11T12:20:30.488Z |
4993474 | 4993474 | 20240902104051_cwL7s | AU000R | 2024-09-08T12:01:36.610Z | 2024-09-11T12:20:23.277Z |
4993421 | 4993421 | 20240902103424_m2ZEf | AU000R | 2024-09-08T12:01:33.488Z | 2024-09-11T12:20:22.790Z |
4987726 | 4987726 | 20240901184118_VEjL2 | AU000R | 2024-09-07T12:06:10.487Z | 2024-09-10T12:19:11.206Z |
4987058 | 4987058 | 20240901164135_x1tHF | AU000R | 2024-09-07T12:05:15.899Z | 2024-09-10T12:19:09.997Z |
4986715 | 4986715 | 20240901153954_reiZY | AU000R | 2024-09-07T12:04:54.128Z | 2024-09-10T12:19:09.683Z |
4986148 | 4986148 | 20240901142245_Y7bOn | AU000R | 2024-09-07T12:04:12.021Z | 2024-09-10T12:19:09.002Z |
4986038 | 4986038 | 20240901141000_AIks9 | AU000R | 2024-09-07T12:04:03.838Z | 2024-09-10T12:19:08.829Z |
4985646 | 4985646 | 20240901131259_EYHxK | AU000R | 2024-09-07T12:03:34.202Z | 2024-09-10T12:19:08.106Z |
4985521 | 4985521 | 20240901124253_qe38t | AU000R | 2024-09-07T12:03:24.084Z | 2024-09-10T12:19:07.980Z |
4985425 | 4985425 | 20240901122102_EqHjV | AU000R | 2024-09-07T12:03:18.032Z | 2024-09-10T12:19:07.848Z |
4985359 | 4985359 | 20240901120700_zsZsU | AU000R | 2024-09-07T12:03:11.649Z | 2024-09-10T12:19:07.661Z |
4985345 | 4985345 | 20240901120412_wAgVF | AU000R | 2024-09-07T12:03:10.334Z | 2024-09-10T12:19:07.625Z |
4984984 | 4984984 | 20240901111513_U10L1 | AU000R | 2024-09-07T12:02:41.696Z | 2024-09-10T12:19:06.734Z |
4984427 | 4984427 | 20240901100348_NOGds | AU000R | 2024-09-07T12:01:53.726Z | 2024-09-10T12:19:05.344Z |
4963440 | 4963440 | 20240811201118_UoYOb | AU000R | 2024-09-04T12:05:34.744Z | 2024-09-06T12:04:39.500Z |
4963310 | 4963310 | 20240811195611_sAj9A | AU000R | 2024-09-04T12:05:26.442Z | 2024-09-06T12:04:28.718Z |
4963276 | 4963276 | 20240811195330_9fUfj | AU000R | 2024-09-04T12:05:24.134Z | 2024-09-06T12:04:27.081Z |
4963120 | 4963120 | 20240811194530_ni3io | AU000R | 2024-09-04T12:05:12.747Z | 2024-09-06T12:04:19.173Z |
4963111 | 4963111 | 20240811194507_osueg | AU000R | 2024-09-04T12:05:11.853Z | 2024-09-06T12:04:18.776Z |
4962799 | 4962799 | 20240811192339_3S2Pl | AU000R | 2024-09-04T12:04:53.051Z | 2024-09-06T12:04:03.383Z |
4962433 | 4962433 | 20240811185547_DhvAb | AU000R | 2024-09-04T12:04:30.323Z | 2024-09-06T12:03:46.076Z |
4962053 | 4962053 | 20240811183238_sW86M | AU000R | 2024-09-04T12:04:14.029Z | 2024-09-06T12:03:26.027Z |
4962038 | 4962038 | 20240811183058_plY6C | AU000R | 2024-09-04T12:04:13.318Z | 2024-09-06T12:03:25.449Z |
4961264 | 4961264 | 20240811172728_HEROt | AU000R | 2024-09-04T12:03:25.391Z | 2024-09-06T12:02:49.746Z |
4961055 | 4961055 | 20240811171331_Q3hz2 | AU000R | 2024-09-04T12:03:14.984Z | 2024-09-06T12:02:42.064Z |
4960984 | 4960984 | 20240811170800_m5FWz | AU000R | 2024-09-04T12:03:09.402Z | 2024-09-06T12:02:38.048Z |
4960897 | 4960897 | 20240811170022_t1lLs | AU000R | 2024-09-04T12:03:04.231Z | 2024-09-06T12:02:31.927Z |
4960597 | 4960597 | 20240811163558_oR1mv | AU000R | 2024-09-04T12:02:45.021Z | 2024-09-06T12:02:17.376Z |
4960098 | 4960098 | 20240811160106_aTjpX | AU000R | 2024-09-04T12:02:11.638Z | 2024-09-06T12:01:52.132Z |
4959869 | 4959869 | 20240811154346_VkQEa | AU000R | 2024-09-04T12:02:00.231Z | 2024-09-06T12:01:41.101Z |
4959746 | 4959746 | 20240811153340_tbAAs | AU000R | 2024-09-04T12:01:53.417Z | 2024-09-06T12:01:35.393Z |
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);