participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,446 rows where station_code = "AU0030" 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 |
---|---|---|---|---|---|
5578300 | 5578300 | 20241121192443_ZuXLU | AU0030 | 2024-11-23T14:16:44.858Z | 2024-11-23T14:21:24.802Z |
5578215 | 5578215 | 20241121191243_HQhSk | AU0030 | 2024-11-23T14:16:35.849Z | 2024-11-23T14:21:24.784Z |
5578008 | 5578008 | 20241121183032_yPe2K | AU0030 | 2024-11-23T14:16:22.564Z | 2024-11-23T14:21:24.738Z |
5577931 | 5577931 | 20241121181644_G1z6I | AU0030 | 2024-11-23T14:16:15.771Z | 2024-11-23T14:21:24.718Z |
5577889 | 5577889 | 20241121180935_PwNHx | AU0030 | 2024-11-23T14:16:12.644Z | 2024-11-23T14:21:24.708Z |
5577886 | 5577886 | 20241121180906_a2Ekd | AU0030 | 2024-11-23T14:16:12.498Z | 2024-11-23T14:21:24.708Z |
5577743 | 5577743 | 20241121174838_kmMpf | AU0030 | 2024-11-23T14:15:55.646Z | 2024-11-23T14:21:24.676Z |
5577646 | 5577646 | 20241121173121_BO0Uc | AU0030 | 2024-11-23T14:15:35.611Z | 2024-11-23T14:21:24.648Z |
5577511 | 5577511 | 20241121163928_fg5Y4 | AU0030 | 2024-11-23T14:15:21.428Z | 2024-11-23T14:21:24.609Z |
5577490 | 5577490 | 20241121162547_SpK8t | AU0030 | 2024-11-23T14:15:19.166Z | 2024-11-23T14:21:24.598Z |
5577451 | 5577451 | 20241121160816_v37rW | AU0030 | 2024-11-23T14:15:14.844Z | 2024-11-23T14:21:24.583Z |
5577447 | 5577447 | 20241121160645_02GhE | AU0030 | 2024-11-23T14:15:14.370Z | 2024-11-23T14:21:24.582Z |
5577365 | 5577365 | 20241121151752_4WNgH | AU0030 | 2024-11-23T14:15:00.908Z | 2024-11-23T14:21:24.524Z |
5577297 | 5577297 | 20241121142846_ZKMtv | AU0030 | 2024-11-23T14:14:38.822Z | 2024-11-23T14:21:24.434Z |
5577293 | 5577293 | 20241121142104_3Djic | AU0030 | 2024-11-23T14:14:36.355Z | 2024-11-23T14:21:24.419Z |
5577266 | 5577266 | 20241121134055_ZS2gU | AU0030 | 2024-11-23T14:14:29.914Z | 2024-11-23T14:21:24.366Z |
5577250 | 5577250 | 20241121131619_KnAYC | AU0030 | 2024-11-23T14:14:24.902Z | 2024-11-23T14:21:24.329Z |
5577192 | 5577192 | 20241121120916_dFjr3 | AU0030 | 2024-11-23T14:13:53.866Z | 2024-11-23T14:21:24.226Z |
5569639 | 5569639 | 20241121193730_hVY8x | AU0030 | 2024-11-22T14:11:25.559Z | 2024-11-23T14:21:24.820Z |
5569628 | 5569628 | 20241121185308_GcLnb | AU0030 | 2024-11-22T14:11:24.672Z | 2024-11-23T14:21:24.761Z |
5569615 | 5569615 | 20241121181028_M2mIL | AU0030 | 2024-11-22T14:11:23.482Z | 2024-11-23T14:21:24.709Z |
5569591 | 5569591 | 20241121173156_yLI0b | AU0030 | 2024-11-22T14:11:20.855Z | 2024-11-23T14:21:24.649Z |
5569529 | 5569529 | 20241121155730_bCVAO | AU0030 | 2024-11-22T14:11:02.360Z | 2024-11-23T14:21:24.577Z |
5569507 | 5569507 | 20241121154607_g4ych | AU0030 | 2024-11-22T14:10:59.909Z | 2024-11-23T14:21:24.563Z |
5569484 | 5569484 | 20241121153900_tMshM | AU0030 | 2024-11-22T14:10:57.518Z | 2024-11-23T14:21:24.554Z |
5569372 | 5569372 | 20241121152033_si1Ro | AU0030 | 2024-11-22T14:10:49.213Z | 2024-11-23T14:21:24.527Z |
5568964 | 5568964 | 20241121141104_sIlDZ | AU0030 | 2024-11-22T14:10:07.447Z | 2024-11-23T14:21:24.400Z |
5555942 | 5555942 | 20241119180237_5seNZ | AU0030 | 2024-11-20T14:07:07.292Z | 2024-11-23T14:24:19.158Z |
5555818 | 5555818 | 20241119165312_Joj2h | AU0030 | 2024-11-20T14:06:45.864Z | 2024-11-23T14:24:17.481Z |
5552399 | 5552399 | 20241117132243_2nwpl | AU0030 | 2024-11-19T14:07:42.057Z | 2024-11-23T14:25:19.958Z |
5552043 | 5552043 | 20241118172853_gjHIl | AU0030 | 2024-11-19T14:05:57.604Z | 2024-11-23T14:25:04.464Z |
5547766 | 5547766 | 20241117193759_c0Qtw | AU0030 | 2024-11-18T14:06:28.407Z | 2024-11-23T14:25:26.132Z |
5547754 | 5547754 | 20241117193518_AQzwJ | AU0030 | 2024-11-18T14:06:27.009Z | 2024-11-23T14:25:26.123Z |
5547695 | 5547695 | 20241117190919_P2LNn | AU0030 | 2024-11-18T14:06:17.578Z | 2024-11-23T14:25:25.694Z |
5547642 | 5547642 | 20241117184607_tdMei | AU0030 | 2024-11-18T14:06:10.313Z | 2024-11-23T14:25:25.261Z |
5547621 | 5547621 | 20241117183440_Nn3RT | AU0030 | 2024-11-18T14:06:08.169Z | 2024-11-23T14:25:25.063Z |
5547609 | 5547609 | 20241117183321_2IfPr | AU0030 | 2024-11-18T14:06:07.668Z | 2024-11-23T14:25:25.001Z |
5547548 | 5547548 | 20241117175647_9P8r9 | AU0030 | 2024-11-18T14:06:03.007Z | 2024-11-23T14:25:23.952Z |
5547539 | 5547539 | 20241117174510_tCmql | AU0030 | 2024-11-18T14:06:01.660Z | 2024-11-23T14:25:23.672Z |
5547471 | 5547471 | 20241117170759_MY6xf | AU0030 | 2024-11-18T14:05:56.028Z | 2024-11-23T14:25:22.943Z |
5547462 | 5547462 | 20241117165848_CeWWR | AU0030 | 2024-11-18T14:05:54.580Z | 2024-11-23T14:25:22.797Z |
5547459 | 5547459 | 20241117165537_6Dsmd | AU0030 | 2024-11-18T14:05:54.201Z | 2024-11-23T14:25:22.734Z |
5547362 | 5547362 | 20241117154934_ISZwq | AU0030 | 2024-11-18T14:05:34.916Z | 2024-11-23T14:25:21.715Z |
5547143 | 5547143 | 20241117145843_mkBIQ | AU0030 | 2024-11-18T14:05:10.668Z | 2024-11-23T14:25:20.843Z |
5546969 | 5546969 | 20241117134926_WM3vq | AU0030 | 2024-11-18T14:04:34.568Z | 2024-11-23T14:25:20.260Z |
5544853 | 5544853 | 20241116173336_X3Mxc | AU0030 | 2024-11-17T14:02:18.655Z | 2024-11-23T14:25:36.904Z |
5544845 | 5544845 | 20241116171509_Wb2NY | AU0030 | 2024-11-17T14:02:17.294Z | 2024-11-23T14:25:36.845Z |
5542918 | 5542918 | 20241115165640_NBGAe | AU0030 | 2024-11-16T14:03:04.075Z | 2024-11-23T14:25:52.163Z |
5542899 | 5542899 | 20241115161151_jVjKh | AU0030 | 2024-11-16T14:02:57.192Z | 2024-11-23T14:25:51.986Z |
5542890 | 5542890 | 20241115154358_gh3tA | AU0030 | 2024-11-16T14:02:55.492Z | 2024-11-23T14:25:51.917Z |
5542874 | 5542874 | 20241115151657_4XtAy | AU0030 | 2024-11-16T14:02:52.529Z | 2024-11-23T14:25:51.812Z |
5541094 | 5541094 | 20241114153236_wrUtV | AU0030 | 2024-11-15T14:05:04.479Z | 2024-11-23T14:26:15.346Z |
5541090 | 5541090 | 20241114152406_5HwQn | AU0030 | 2024-11-15T14:05:03.916Z | 2024-11-23T14:26:15.289Z |
5537008 | 5537008 | 20241112200446_Qz1Qh | AU0030 | 2024-11-14T14:10:49.956Z | 2024-11-21T14:26:07.892Z |
5536943 | 5536943 | 20241112194629_RUgaj | AU0030 | 2024-11-14T14:10:44.858Z | 2024-11-21T14:26:07.262Z |
5536917 | 5536917 | 20241112194043_4Rqeo | AU0030 | 2024-11-14T14:10:41.109Z | 2024-11-21T14:26:07.166Z |
5536655 | 5536655 | 20241112184900_XheEK | AU0030 | 2024-11-14T14:10:25.865Z | 2024-11-21T14:26:04.153Z |
5536545 | 5536545 | 20241112182708_UPTww | AU0030 | 2024-11-14T14:10:14.824Z | 2024-11-21T14:26:02.685Z |
5536415 | 5536415 | 20241112175723_RGDpE | AU0030 | 2024-11-14T14:09:52.253Z | 2024-11-21T14:26:00.815Z |
5536317 | 5536317 | 20241112172240_XqyqK | AU0030 | 2024-11-14T14:09:36.388Z | 2024-11-21T14:25:59.956Z |
5536217 | 5536217 | 20241112162732_E8m64 | AU0030 | 2024-11-14T14:09:20.226Z | 2024-11-21T14:25:58.101Z |
5536200 | 5536200 | 20241112161822_99eSc | AU0030 | 2024-11-14T14:09:18.928Z | 2024-11-21T14:25:57.556Z |
5535848 | 5535848 | 20241112143702_qFNqa | AU0030 | 2024-11-14T14:08:54.391Z | 2024-11-21T14:25:53.830Z |
5534828 | 5534828 | 20241113195755_qd3si | AU0030 | 2024-11-14T14:05:32.237Z | 2024-11-22T14:24:17.044Z |
5534820 | 5534820 | 20241113194452_zD9vh | AU0030 | 2024-11-14T14:05:31.194Z | 2024-11-22T14:24:16.922Z |
5534815 | 5534815 | 20241113194119_OnbaM | AU0030 | 2024-11-14T14:05:30.595Z | 2024-11-22T14:24:16.897Z |
5534790 | 5534790 | 20241113192619_AB4hL | AU0030 | 2024-11-14T14:05:25.853Z | 2024-11-22T14:24:16.472Z |
5534761 | 5534761 | 20241113183421_9k2I2 | AU0030 | 2024-11-14T14:05:19.283Z | 2024-11-22T14:24:16.161Z |
5534711 | 5534711 | 20241113164202_JbgFe | AU0030 | 2024-11-14T14:05:04.975Z | 2024-11-22T14:24:15.758Z |
5527464 | 5527464 | 20241111165227_5q3wX | AU0030 | 2024-11-13T14:08:19.376Z | 2024-11-20T14:25:11.675Z |
5527455 | 5527455 | 20241111164928_HTP4v | AU0030 | 2024-11-13T14:08:18.654Z | 2024-11-20T14:25:11.600Z |
5527341 | 5527341 | 20241111152356_pnWQ9 | AU0030 | 2024-11-13T14:07:55.330Z | 2024-11-20T14:25:07.054Z |
5527192 | 5527192 | 20241111120558_NtssR | AU0030 | 2024-11-13T14:06:48.454Z | 2024-11-20T14:24:53.265Z |
5522436 | 5522436 | 20241110200302_JhYw7 | AU0030 | 2024-11-12T14:13:15.858Z | 2024-11-19T14:22:02.044Z |
5522382 | 5522382 | 20241110195308_OQuhd | AU0030 | 2024-11-12T14:13:09.216Z | 2024-11-19T14:22:01.166Z |
5522363 | 5522363 | 20241110194953_gwlv7 | AU0030 | 2024-11-12T14:13:07.836Z | 2024-11-19T14:22:00.877Z |
5522349 | 5522349 | 20241110194832_uzHFN | AU0030 | 2024-11-12T14:13:06.649Z | 2024-11-19T14:22:00.736Z |
5522092 | 5522092 | 20241110190412_g1SMl | AU0030 | 2024-11-12T14:12:46.115Z | 2024-11-19T14:21:57.640Z |
5521985 | 5521985 | 20241110184411_YQ9NZ | AU0030 | 2024-11-12T14:12:22.659Z | 2024-11-19T14:21:56.668Z |
5521901 | 5521901 | 20241110183043_wnkvc | AU0030 | 2024-11-12T14:12:08.125Z | 2024-11-19T14:21:56.068Z |
5521842 | 5521842 | 20241110182219_Y3VOd | AU0030 | 2024-11-12T14:12:03.266Z | 2024-11-19T14:21:55.416Z |
5521645 | 5521645 | 20241110174750_dIQ72 | AU0030 | 2024-11-12T14:11:46.479Z | 2024-11-19T14:21:53.937Z |
5521545 | 5521545 | 20241110172820_fzWdc | AU0030 | 2024-11-12T14:11:32.569Z | 2024-11-19T14:21:53.386Z |
5521425 | 5521425 | 20241110170859_p0vng | AU0030 | 2024-11-12T14:11:05.658Z | 2024-11-19T14:21:52.720Z |
5521294 | 5521294 | 20241110164533_GFn0Q | AU0030 | 2024-11-12T14:10:44.524Z | 2024-11-19T14:21:51.286Z |
5521237 | 5521237 | 20241110163239_GRj4t | AU0030 | 2024-11-12T14:10:39.537Z | 2024-11-19T14:21:50.583Z |
5521111 | 5521111 | 20241110160424_nqMxC | AU0030 | 2024-11-12T14:10:28.851Z | 2024-11-19T14:21:48.647Z |
5520935 | 5520935 | 20241110152933_xjrAx | AU0030 | 2024-11-12T14:09:51.286Z | 2024-11-19T14:21:46.316Z |
5520736 | 5520736 | 20241110140048_gnF4j | AU0030 | 2024-11-12T14:09:09.594Z | 2024-11-19T14:21:42.769Z |
5520686 | 5520686 | 20241110133248_n0ia7 | AU0030 | 2024-11-12T14:08:58.748Z | 2024-11-19T14:21:41.628Z |
5520620 | 5520620 | 20241110125452_9aHxJ | AU0030 | 2024-11-12T14:08:51.133Z | 2024-11-19T14:21:40.689Z |
5520576 | 5520576 | 20241110123007_5hTvN | AU0030 | 2024-11-12T14:08:42.305Z | 2024-11-19T14:21:38.679Z |
5520560 | 5520560 | 20241110121659_N40RD | AU0030 | 2024-11-12T14:08:32.753Z | 2024-11-19T14:21:37.405Z |
5519880 | 5519880 | 20241111134417_I2qUl | AU0030 | 2024-11-12T14:05:15.700Z | 2024-11-20T14:25:00.407Z |
5518184 | 5518184 | 20241108173643_jw20s | AU0030 | 2024-11-11T14:16:33.392Z | 2024-11-17T14:23:28.493Z |
5518182 | 5518182 | 20241108173422_5d937 | AU0030 | 2024-11-11T14:16:33.065Z | 2024-11-17T14:23:28.335Z |
5518180 | 5518180 | 20241108172225_JJoI6 | AU0030 | 2024-11-11T14:16:32.447Z | 2024-11-17T14:23:27.876Z |
5518177 | 5518177 | 20241108171402_nXZvI | AU0030 | 2024-11-11T14:16:31.858Z | 2024-11-17T14:23:27.325Z |
5515161 | 5515161 | 20241109194203_KqMPM | AU0030 | 2024-11-11T14:10:13.139Z | 2024-11-18T14:26:24.580Z |
5515062 | 5515062 | 20241109191233_20zkB | AU0030 | 2024-11-11T14:09:58.307Z | 2024-11-18T14:26:24.070Z |
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);