participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
303 rows where station_code = "AU003G" 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 |
---|---|---|---|---|---|
5084160 | 5084160 | 20240912183828_upufC | AU003G | 2024-09-16T12:01:19.691Z | 2024-09-16T12:17:04.145Z |
5084152 | 5084152 | 20240912183316_NM4sf | AU003G | 2024-09-16T12:01:16.640Z | 2024-09-16T12:17:04.140Z |
5084124 | 5084124 | 20240912182003_wMg5Q | AU003G | 2024-09-16T12:01:12.560Z | 2024-09-16T12:17:04.107Z |
5084071 | 5084071 | 20240912175939_zjm3T | AU003G | 2024-09-16T12:01:04.608Z | 2024-09-16T12:17:04.077Z |
5084003 | 5084003 | 20240912173356_sza7F | AU003G | 2024-09-16T12:00:54.091Z | 2024-09-16T12:17:04.026Z |
5068817 | 5068817 | 20240910123208_m2EwA | AU003G | 2024-09-14T12:19:21.727Z | 2024-09-16T12:20:15.383Z |
5062930 | 5062930 | 20240909191231_l79D7 | AU003G | 2024-09-14T12:13:04.494Z | 2024-09-16T12:19:40.483Z |
5062899 | 5062899 | 20240909185448_YeR6c | AU003G | 2024-09-14T12:13:01.383Z | 2024-09-16T12:19:40.130Z |
5062737 | 5062737 | 20240909180814_PFto2 | AU003G | 2024-09-14T12:12:46.319Z | 2024-09-16T12:19:39.167Z |
5061621 | 5061621 | 20240909152957_3DFoQ | AU003G | 2024-09-14T12:11:01.633Z | 2024-09-16T12:19:32.601Z |
5061587 | 5061587 | 20240909152614_6UqVQ | AU003G | 2024-09-14T12:10:59.127Z | 2024-09-16T12:19:32.252Z |
5061291 | 5061291 | 20240909144205_hjttl | AU003G | 2024-09-14T12:10:40.370Z | 2024-09-16T12:19:30.309Z |
5057879 | 5057879 | 20240910152135_viyom | AU003G | 2024-09-14T12:02:18.540Z | 2024-09-16T12:17:48.094Z |
5051892 | 5051892 | 20240907190104_iJBuq | AU003G | 2024-09-13T12:14:42.201Z | 2024-09-16T12:21:02.412Z |
5049490 | 5049490 | 20240909110317_uq4jj | AU003G | 2024-09-13T12:12:15.190Z | 2024-09-16T12:20:43.003Z |
5038284 | 5038284 | 20240905185338_Z3qmF | AU003G | 2024-09-12T12:14:30.793Z | 2024-09-14T12:22:55.487Z |
5038276 | 5038276 | 20240905184507_CECaF | AU003G | 2024-09-12T12:14:30.344Z | 2024-09-14T12:22:55.477Z |
5037970 | 5037970 | 20240905170851_KkriK | AU003G | 2024-09-12T12:14:18.105Z | 2024-09-14T12:22:54.844Z |
5037246 | 5037246 | 20240905152814_UGE13 | AU003G | 2024-09-12T12:14:03.781Z | 2024-09-14T12:22:54.017Z |
5036907 | 5036907 | 20240905144157_xnoAo | AU003G | 2024-09-12T12:13:57.191Z | 2024-09-14T12:22:53.541Z |
5036853 | 5036853 | 20240905143531_SdSrp | AU003G | 2024-09-12T12:13:55.986Z | 2024-09-14T12:22:53.300Z |
5028987 | 5028987 | 20240905111309_B0gCo | AU003G | 2024-09-11T12:16:04.629Z | 2024-09-14T12:22:50.239Z |
5028254 | 5028254 | 20240905091936_Zxjr9 | AU003G | 2024-09-11T12:15:04.969Z | 2024-09-13T12:20:05.863Z |
5024057 | 5024057 | 20240905185338_SkRaI | AU003G | 2024-09-11T12:02:29.001Z | 2024-09-11T12:16:31.914Z |
5024053 | 5024053 | 20240905184507_lqHwP | AU003G | 2024-09-11T12:02:28.300Z | 2024-09-11T12:16:31.911Z |
5023815 | 5023815 | 20240905170851_blVbZ | AU003G | 2024-09-10T12:16:50.350Z | 2024-09-11T12:16:31.797Z |
5023131 | 5023131 | 20240905152814_72F8O | AU003G | 2024-09-10T12:16:39.496Z | 2024-09-11T12:16:31.546Z |
5022690 | 5022690 | 20240905091936_WAO93 | AU003G | 2024-09-10T12:16:27.727Z | 2024-09-10T12:16:55.598Z |
5018262 | 5018262 | 20240904173219_kjDhu | AU003G | 2024-09-10T12:10:17.494Z | 2024-09-13T12:19:47.468Z |
5017728 | 5017728 | 20240904163651_A3iDA | AU003G | 2024-09-10T12:09:27.617Z | 2024-09-13T12:19:47.066Z |
5015462 | 5015462 | 20240904114154_SMVpr | AU003G | 2024-09-10T12:06:11.999Z | 2024-09-13T12:19:44.057Z |
5015200 | 5015200 | 20240905144157_Jw3ay | AU003G | 2024-09-10T12:04:39.820Z | 2024-09-11T12:16:31.419Z |
5015148 | 5015148 | 20240905143531_dg3NK | AU003G | 2024-09-10T12:04:34.478Z | 2024-09-11T12:16:31.402Z |
5013794 | 5013794 | 20240905111309_f2MXA | AU003G | 2024-09-10T12:01:35.842Z | 2024-09-14T12:22:50.240Z |
5006835 | 5006835 | 20240903190756_mM3ZP | AU003G | 2024-09-09T12:05:07.639Z | 2024-09-12T12:19:10.277Z |
5006661 | 5006661 | 20240903181923_11FfV | AU003G | 2024-09-09T12:04:52.053Z | 2024-09-12T12:19:09.148Z |
5006093 | 5006093 | 20240903165355_dZJ0j | AU003G | 2024-09-09T12:04:20.106Z | 2024-09-12T12:19:07.630Z |
5005881 | 5005881 | 20240903162643_pgigB | AU003G | 2024-09-09T12:04:11.050Z | 2024-09-12T12:19:06.994Z |
5003325 | 5003325 | 20240904113950_zXu6Z | AU003G | 2024-09-09T12:01:34.764Z | 2024-09-13T12:19:44.038Z |
4995977 | 4995977 | 20240902182251_oG8At | AU003G | 2024-09-08T12:04:15.363Z | 2024-09-11T12:20:50.035Z |
4995744 | 4995744 | 20240902174423_fgcD3 | AU003G | 2024-09-08T12:04:01.283Z | 2024-09-11T12:20:47.699Z |
4995301 | 4995301 | 20240902163758_fp6tT | AU003G | 2024-09-08T12:03:32.287Z | 2024-09-11T12:20:43.362Z |
4987932 | 4987932 | 20240901192047_lFx7A | AU003G | 2024-09-07T12:06:29.658Z | 2024-09-10T12:19:11.857Z |
4987638 | 4987638 | 20240901181736_h3IoR | AU003G | 2024-09-07T12:06:01.938Z | 2024-09-10T12:19:11.062Z |
4987553 | 4987553 | 20240901175601_hI2yO | AU003G | 2024-09-07T12:05:56.053Z | 2024-09-10T12:19:10.966Z |
4985141 | 4985141 | 20240901113626_ypEek | AU003G | 2024-09-07T12:02:53.631Z | 2024-09-10T12:19:06.955Z |
4985035 | 4985035 | 20240901112216_L376G | AU003G | 2024-09-07T12:02:45.385Z | 2024-09-10T12:19:06.812Z |
4983985 | 4983985 | 20240901084050_gMrze | AU003G | 2024-09-07T12:01:11.312Z | 2024-09-10T12:19:04.130Z |
4958478 | 4958478 | 20240811103430_Wl50Y | AU003G | 2024-09-03T12:22:25.700Z | 2024-09-06T12:32:07.090Z |
4958260 | 4958260 | 20240811100901_pF3PD | AU003G | 2024-09-03T12:22:18.766Z | 2024-09-06T12:31:58.428Z |
4958145 | 4958145 | 20240811095841_Fuy9x | AU003G | 2024-09-03T12:22:11.044Z | 2024-09-06T12:31:53.904Z |
4957760 | 4957760 | 20240811091727_IV76S | AU003G | 2024-09-03T12:21:42.046Z | 2024-09-06T12:31:35.187Z |
4957401 | 4957401 | 20240811083743_pMBIh | AU003G | 2024-09-03T12:21:11.077Z | 2024-09-06T12:31:17.587Z |
4934832 | 4934832 | 20240810190850_3CGkG | AU003G | 2024-09-01T12:05:51.650Z | 2024-09-06T12:20:21.693Z |
4934643 | 4934643 | 20240810184253_I98PN | AU003G | 2024-09-01T12:05:36.644Z | 2024-09-06T12:20:17.108Z |
4934602 | 4934602 | 20240810183727_w5qF3 | AU003G | 2024-09-01T12:05:33.992Z | 2024-09-06T12:20:16.131Z |
4934589 | 4934589 | 20240810183556_KR3cO | AU003G | 2024-09-01T12:05:33.175Z | 2024-09-06T12:20:15.813Z |
4934579 | 4934579 | 20240810183351_V44Dy | AU003G | 2024-09-01T12:05:32.011Z | 2024-09-06T12:20:15.217Z |
4934407 | 4934407 | 20240810181106_E2MMJ | AU003G | 2024-09-01T12:05:16.750Z | 2024-09-06T12:20:11.108Z |
4934254 | 4934254 | 20240810175930_v0Wsl | AU003G | 2024-09-01T12:05:05.767Z | 2024-09-06T12:20:06.352Z |
4934225 | 4934225 | 20240810175602_Pfn5F | AU003G | 2024-09-01T12:05:03.950Z | 2024-09-06T12:20:04.402Z |
4934109 | 4934109 | 20240810174624_hg5Vm | AU003G | 2024-09-01T12:04:57.567Z | 2024-09-06T12:19:58.425Z |
4934053 | 4934053 | 20240810174037_DqcsS | AU003G | 2024-09-01T12:04:54.419Z | 2024-09-06T12:19:53.249Z |
4934047 | 4934047 | 20240810174014_tyi3Y | AU003G | 2024-09-01T12:04:54.053Z | 2024-09-06T12:19:52.676Z |
4934000 | 4934000 | 20240810173842_ZN4sW | AU003G | 2024-09-01T12:04:51.284Z | 2024-09-06T12:19:48.496Z |
4931595 | 4931595 | 20240810104527_WxJr8 | AU003G | 2024-08-31T12:24:43.668Z | 2024-09-02T12:31:02.683Z |
4931422 | 4931422 | 20240810102814_oHBmX | AU003G | 2024-08-31T12:24:36.272Z | 2024-09-02T12:30:53.906Z |
4931301 | 4931301 | 20240810101151_bjzYQ | AU003G | 2024-08-31T12:24:29.182Z | 2024-09-02T12:30:47.446Z |
4931176 | 4931176 | 20240810095549_PjS9o | AU003G | 2024-08-31T12:24:19.169Z | 2024-09-02T12:30:42.969Z |
4924066 | 4924066 | 20240810130528_5P3ud | AU003G | 2024-08-31T12:01:35.400Z | 2024-09-06T12:16:42.412Z |
4923970 | 4923970 | 20240810125703_GJ2Ji | AU003G | 2024-08-31T12:01:25.774Z | 2024-09-06T12:16:36.219Z |
4923893 | 4923893 | 20240810124939_7fLGb | AU003G | 2024-08-31T12:01:14.798Z | 2024-09-06T12:16:29.670Z |
4911280 | 4911280 | 20240809194430_zrPhX | AU003G | 2024-08-29T12:07:13.514Z | 2024-09-02T12:21:28.114Z |
4911228 | 4911228 | 20240809193641_xd2lc | AU003G | 2024-08-29T12:07:09.229Z | 2024-09-02T12:21:26.348Z |
4911139 | 4911139 | 20240809192654_XeMqt | AU003G | 2024-08-29T12:07:02.093Z | 2024-09-02T12:21:20.112Z |
4911094 | 4911094 | 20240809192406_kbzYn | AU003G | 2024-08-29T12:06:59.083Z | 2024-09-02T12:21:17.264Z |
4911075 | 4911075 | 20240809192245_5S4Qd | AU003G | 2024-08-29T12:06:57.959Z | 2024-09-02T12:21:16.331Z |
4911030 | 4911030 | 20240809191427_sDn2Y | AU003G | 2024-08-29T12:06:54.079Z | 2024-09-02T12:21:14.697Z |
4911003 | 4911003 | 20240809191059_6i33w | AU003G | 2024-08-29T12:06:52.115Z | 2024-09-02T12:21:13.784Z |
4910959 | 4910959 | 20240809190423_wi2rA | AU003G | 2024-08-29T12:06:49.688Z | 2024-09-02T12:21:12.627Z |
4910874 | 4910874 | 20240809185302_wwEyz | AU003G | 2024-08-29T12:06:44.323Z | 2024-09-02T12:21:09.868Z |
4910862 | 4910862 | 20240809184953_53kJK | AU003G | 2024-08-29T12:06:43.436Z | 2024-09-02T12:21:09.489Z |
4910796 | 4910796 | 20240809184106_m7Fzv | AU003G | 2024-08-29T12:06:39.827Z | 2024-09-02T12:21:07.388Z |
4910793 | 4910793 | 20240809184105_ni6G8 | AU003G | 2024-08-29T12:06:39.661Z | 2024-09-02T12:21:07.285Z |
4910735 | 4910735 | 20240809183519_rqC0z | AU003G | 2024-08-29T12:06:35.836Z | 2024-09-02T12:21:05.112Z |
4910690 | 4910690 | 20240809182922_hd7Yt | AU003G | 2024-08-29T12:06:31.584Z | 2024-09-02T12:21:03.421Z |
4910616 | 4910616 | 20240809182116_MqsVN | AU003G | 2024-08-29T12:06:24.564Z | 2024-09-02T12:21:00.487Z |
4910453 | 4910453 | 20240809180747_6Y4IP | AU003G | 2024-08-29T12:06:13.843Z | 2024-09-02T12:20:45.761Z |
4910434 | 4910434 | 20240809180614_0Hjs3 | AU003G | 2024-08-29T12:06:12.734Z | 2024-09-02T12:20:42.686Z |
4910049 | 4910049 | 20240809173832_h2A0F | AU003G | 2024-08-29T12:05:46.027Z | 2024-09-02T12:20:29.547Z |
4909686 | 4909686 | 20240809171435_DyYcc | AU003G | 2024-08-29T12:05:23.854Z | 2024-09-02T12:20:12.023Z |
4909641 | 4909641 | 20240809171142_2lHbE | AU003G | 2024-08-29T12:05:21.121Z | 2024-09-02T12:20:07.085Z |
4909430 | 4909430 | 20240809165734_h99sO | AU003G | 2024-08-29T12:05:09.339Z | 2024-09-02T12:19:58.314Z |
4909127 | 4909127 | 20240809163258_CKGvQ | AU003G | 2024-08-29T12:04:48.140Z | 2024-09-02T12:19:46.274Z |
4908966 | 4908966 | 20240809162058_AKL8S | AU003G | 2024-08-29T12:04:39.142Z | 2024-09-02T12:19:34.950Z |
4907286 | 4907286 | 20240809140447_RjTC4 | AU003G | 2024-08-29T12:02:51.143Z | 2024-09-02T12:18:17.456Z |
4906932 | 4906932 | 20240809133002_aiwz8 | AU003G | 2024-08-29T12:02:26.992Z | 2024-09-02T12:18:02.628Z |
4906898 | 4906898 | 20240809132552_Y5yRj | AU003G | 2024-08-29T12:02:24.478Z | 2024-09-02T12:18:01.532Z |
4906401 | 4906401 | 20240809123616_s2S7y | AU003G | 2024-08-29T12:01:50.591Z | 2024-09-02T12:17:36.132Z |
4906111 | 4906111 | 20240809120048_2L9c2 | AU003G | 2024-08-29T12:01:28.006Z | 2024-09-02T12:17:26.760Z |
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);