participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
73 rows where station_code = "AU004K" 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 |
---|---|---|---|---|---|
5131032 | 5131032 | 20240917181036_qDa8E | AU004K | 2024-09-19T12:14:09.666Z | 2024-09-19T12:14:09.666Z |
5130983 | 5130983 | 20240917171227_nNAGl | AU004K | 2024-09-19T12:14:02.688Z | 2024-09-19T12:14:02.688Z |
5124287 | 5124287 | 20240917190817_k4jzK | AU004K | 2024-09-19T12:00:28.388Z | 2024-09-19T12:06:41.872Z |
5124120 | 5124120 | 20240914152734_vkGRK | AU004K | 2024-09-18T12:12:08.398Z | 2024-09-19T12:20:17.982Z |
5124114 | 5124114 | 20240914151731_RwfjS | AU004K | 2024-09-18T12:12:07.879Z | 2024-09-19T12:20:17.952Z |
5124112 | 5124112 | 20240914151719_A3Ov3 | AU004K | 2024-09-18T12:12:07.824Z | 2024-09-19T12:20:17.951Z |
5124110 | 5124110 | 20240914151206_1ec8o | AU004K | 2024-09-18T12:12:07.660Z | 2024-09-19T12:20:17.943Z |
5124081 | 5124081 | 20240914144929_dWAE3 | AU004K | 2024-09-18T12:12:05.650Z | 2024-09-19T12:20:17.679Z |
5124037 | 5124037 | 20240914140757_DCVpU | AU004K | 2024-09-18T12:12:03.979Z | 2024-09-19T12:20:17.496Z |
5123957 | 5123957 | 20240914124752_eeB7h | AU004K | 2024-09-18T12:12:01.233Z | 2024-09-19T12:20:16.833Z |
5110666 | 5110666 | 20240914175332_gdicP | AU004K | 2024-09-18T12:00:39.574Z | 2024-09-19T12:18:22.427Z |
5110206 | 5110206 | 20240913133109_KWi1U | AU004K | 2024-09-17T12:14:59.368Z | 2024-09-19T12:20:56.103Z |
5110198 | 5110198 | 20240913131552_3Lqj8 | AU004K | 2024-09-17T12:14:59.148Z | 2024-09-19T12:20:56.081Z |
5083810 | 5083810 | 20240912154942_Y2Tn3 | AU004K | 2024-09-16T12:00:25.521Z | 2024-09-19T12:20:21.283Z |
5071841 | 5071841 | 20240911183407_4tQJS | AU004K | 2024-09-15T12:03:49.003Z | 2024-09-19T12:21:02.835Z |
5071054 | 5071054 | 20240911155252_JOlBz | AU004K | 2024-09-15T12:01:32.025Z | 2024-09-19T12:21:00.843Z |
5070899 | 5070899 | 20240911152636_ZKmJO | AU004K | 2024-09-15T12:01:06.693Z | 2024-09-19T12:21:00.521Z |
5070457 | 5070457 | 20240909125611_n0MKX | AU004K | 2024-09-14T12:21:21.945Z | 2024-09-17T12:19:12.474Z |
5068198 | 5068198 | 20240910110840_INuxw | AU004K | 2024-09-14T12:19:10.586Z | 2024-09-18T12:15:25.735Z |
5067713 | 5067713 | 20240910100429_mD2JB | AU004K | 2024-09-14T12:18:54.789Z | 2024-09-18T12:15:24.775Z |
5062764 | 5062764 | 20240909181735_UIzKD | AU004K | 2024-09-14T12:12:48.164Z | 2024-09-18T12:15:12.053Z |
5062669 | 5062669 | 20240909175827_EjPl7 | AU004K | 2024-09-14T12:12:41.650Z | 2024-09-18T12:15:11.847Z |
5062482 | 5062482 | 20240909173042_M432S | AU004K | 2024-09-14T12:12:26.372Z | 2024-09-18T12:15:11.389Z |
5062387 | 5062387 | 20240909171819_rEjWw | AU004K | 2024-09-14T12:12:16.206Z | 2024-09-18T12:15:11.277Z |
5061920 | 5061920 | 20240909162321_eWrER | AU004K | 2024-09-14T12:11:39.010Z | 2024-09-18T12:15:10.165Z |
5061904 | 5061904 | 20240909162131_De9Os | AU004K | 2024-09-14T12:11:37.114Z | 2024-09-18T12:15:10.127Z |
5061476 | 5061476 | 20240909151207_8E1Va | AU004K | 2024-09-14T12:10:52.053Z | 2024-09-18T12:15:09.335Z |
5061361 | 5061361 | 20240909145706_yJPde | AU004K | 2024-09-14T12:10:44.269Z | 2024-09-18T12:15:08.978Z |
5061359 | 5061359 | 20240909145613_UiJ72 | AU004K | 2024-09-14T12:10:44.166Z | 2024-09-18T12:15:08.978Z |
5060923 | 5060923 | 20240909132446_rUptL | AU004K | 2024-09-14T12:09:55.911Z | 2024-09-18T12:15:07.295Z |
5059613 | 5059613 | 20240910181736_uirX5 | AU004K | 2024-09-14T12:06:35.660Z | 2024-09-19T12:21:30.942Z |
5051992 | 5051992 | 20240907192115_LSSHS | AU004K | 2024-09-13T12:14:51.999Z | 2024-09-16T12:21:02.748Z |
5051968 | 5051968 | 20240907191634_zg5LR | AU004K | 2024-09-13T12:14:50.750Z | 2024-09-16T12:21:02.633Z |
5051957 | 5051957 | 20240907191534_RlerR | AU004K | 2024-09-13T12:14:50.365Z | 2024-09-16T12:21:02.626Z |
5051922 | 5051922 | 20240907190553_mgNPP | AU004K | 2024-09-13T12:14:45.320Z | 2024-09-16T12:21:02.501Z |
5051852 | 5051852 | 20240907185331_6HBil | AU004K | 2024-09-13T12:14:37.911Z | 2024-09-16T12:21:02.148Z |
5051772 | 5051772 | 20240907183420_BRLax | AU004K | 2024-09-13T12:14:33.137Z | 2024-09-16T12:21:01.841Z |
5051711 | 5051711 | 20240907182640_MWZDT | AU004K | 2024-09-13T12:14:30.407Z | 2024-09-16T12:21:01.650Z |
5051562 | 5051562 | 20240907174503_Uw8Hv | AU004K | 2024-09-13T12:14:23.065Z | 2024-09-16T12:21:01.201Z |
5050453 | 5050453 | 20240907152232_wk5Gk | AU004K | 2024-09-13T12:13:32.420Z | 2024-09-16T12:20:57.724Z |
5050127 | 5050127 | 20240909125300_UpEsj | AU004K | 2024-09-13T12:12:41.749Z | 2024-09-17T12:19:12.409Z |
5030930 | 5030930 | 20240906193327_QaR0X | AU004K | 2024-09-12T12:03:25.771Z | 2024-09-15T12:21:20.460Z |
5030917 | 5030917 | 20240906192845_K24BR | AU004K | 2024-09-12T12:03:24.232Z | 2024-09-15T12:21:20.391Z |
5030853 | 5030853 | 20240906190817_2yQBB | AU004K | 2024-09-12T12:03:14.751Z | 2024-09-15T12:21:20.156Z |
5030841 | 5030841 | 20240906190343_h80L3 | AU004K | 2024-09-12T12:03:13.290Z | 2024-09-15T12:21:20.026Z |
5006980 | 5006980 | 20240903193759_L3XN5 | AU004K | 2024-09-09T12:05:17.267Z | 2024-09-12T12:19:11.006Z |
5006716 | 5006716 | 20240903183754_KhfYE | AU004K | 2024-09-09T12:04:56.950Z | 2024-09-12T12:19:09.302Z |
5006313 | 5006313 | 20240903172031_Nisix | AU004K | 2024-09-09T12:04:30.445Z | 2024-09-12T12:19:08.101Z |
5005269 | 5005269 | 20240903144242_F52O2 | AU004K | 2024-09-09T12:03:32.597Z | 2024-09-12T12:19:05.609Z |
5005108 | 5005108 | 20240903135917_15FfJ | AU004K | 2024-09-09T12:03:20.266Z | 2024-09-12T12:19:05.278Z |
5005063 | 5005063 | 20240903135246_qOp3t | AU004K | 2024-09-09T12:03:18.241Z | 2024-09-12T12:19:05.204Z |
5004744 | 5004744 | 20240903122244_fjFCd | AU004K | 2024-09-09T12:02:57.868Z | 2024-09-12T12:19:03.703Z |
5004059 | 5004059 | 20240903103349_7n2kF | AU004K | 2024-09-09T12:02:19.557Z | 2024-09-12T12:19:00.613Z |
5003868 | 5003868 | 20240903100724_iYXBL | AU004K | 2024-09-09T12:02:09.181Z | 2024-09-12T12:18:59.620Z |
4996314 | 4996314 | 20240902191659_yWg2Y | AU004K | 2024-09-08T12:04:41.561Z | 2024-09-11T12:20:52.920Z |
4996294 | 4996294 | 20240902191141_MvHCy | AU004K | 2024-09-08T12:04:40.524Z | 2024-09-11T12:20:52.732Z |
4996090 | 4996090 | 20240902183739_eTJOk | AU004K | 2024-09-08T12:04:21.526Z | 2024-09-11T12:20:51.009Z |
4995375 | 4995375 | 20240902164929_Q3ODb | AU004K | 2024-09-08T12:03:36.219Z | 2024-09-11T12:20:44.903Z |
4995218 | 4995218 | 20240902162931_MzPZl | AU004K | 2024-09-08T12:03:24.242Z | 2024-09-11T12:20:42.979Z |
4995192 | 4995192 | 20240902162620_Poaum | AU004K | 2024-09-08T12:03:22.908Z | 2024-09-11T12:20:42.847Z |
4995129 | 4995129 | 20240902161904_2dsU4 | AU004K | 2024-09-08T12:03:17.072Z | 2024-09-11T12:20:42.190Z |
4995107 | 4995107 | 20240902161410_GkaJO | AU004K | 2024-09-08T12:03:15.873Z | 2024-09-11T12:20:42.005Z |
4995076 | 4995076 | 20240902161052_0bFPP | AU004K | 2024-09-08T12:03:14.418Z | 2024-09-11T12:20:41.749Z |
4994813 | 4994813 | 20240902152046_FIolE | AU004K | 2024-09-08T12:03:00.331Z | 2024-09-11T12:20:39.420Z |
4994617 | 4994617 | 20240902144403_XxJ32 | AU004K | 2024-09-08T12:02:46.026Z | 2024-09-11T12:20:35.670Z |
4994308 | 4994308 | 20240902132753_X9IhJ | AU004K | 2024-09-08T12:02:27.802Z | 2024-09-11T12:20:32.662Z |
4987810 | 4987810 | 20240901190045_4VAxu | AU004K | 2024-09-07T12:06:20.824Z | 2024-09-10T12:19:11.437Z |
4985971 | 4985971 | 20240901135730_nsyIO | AU004K | 2024-09-07T12:03:57.318Z | 2024-09-10T12:19:08.691Z |
4985831 | 4985831 | 20240901133857_YrXqI | AU004K | 2024-09-07T12:03:48.670Z | 2024-09-10T12:19:08.425Z |
4985745 | 4985745 | 20240901132807_jSlFb | AU004K | 2024-09-07T12:03:42.766Z | 2024-09-10T12:19:08.313Z |
4985662 | 4985662 | 20240901131619_MH1gu | AU004K | 2024-09-07T12:03:36.467Z | 2024-09-10T12:19:08.111Z |
4985023 | 4985023 | 20240901112048_3Hs9x | AU004K | 2024-09-07T12:02:44.505Z | 2024-09-10T12:19:06.781Z |
4984990 | 4984990 | 20240901111555_mUQDW | AU004K | 2024-09-07T12:02:41.992Z | 2024-09-10T12:19:06.735Z |
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);