participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,282 rows where station_code = "AU0006" 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 |
---|---|---|---|---|---|
4850729 | 4850729 | 20240805194628_N1gCl | AU0006 | 2024-08-17T12:13:36.998Z | 2024-08-19T12:23:21.600Z |
4800621 | 4800621 | 20240802170706_v8fG4 | AU0006 | 2024-08-12T12:11:47.755Z | 2024-08-13T12:16:24.674Z |
4739548 | 4739548 | 20240729164151_KDNvJ | AU0006 | 2024-08-03T12:10:41.166Z | 2024-08-06T12:15:13.628Z |
4739449 | 4739449 | 20240729162648_BIRmU | AU0006 | 2024-08-03T12:10:30.765Z | 2024-08-06T12:15:13.113Z |
4739236 | 4739236 | 20240729153738_11ubC | AU0006 | 2024-08-03T12:10:01.078Z | 2024-08-06T12:15:12.467Z |
4738613 | 4738613 | 20240729114959_hsS93 | AU0006 | 2024-08-03T12:08:47.879Z | 2024-08-06T12:15:10.544Z |
4703888 | 4703888 | 20240726182146_6kI4F | AU0006 | 2024-07-28T12:12:02.173Z | 2024-08-03T12:21:54.692Z |
4703822 | 4703822 | 20240726181339_AIfEz | AU0006 | 2024-07-28T12:11:59.704Z | 2024-08-03T12:21:54.523Z |
4703383 | 4703383 | 20240726171522_pH6g9 | AU0006 | 2024-07-28T12:11:45.335Z | 2024-08-03T12:21:52.214Z |
4703229 | 4703229 | 20240726165037_IHkrY | AU0006 | 2024-07-28T12:11:38.851Z | 2024-08-03T12:21:51.704Z |
4703006 | 4703006 | 20240726162634_8Ad0q | AU0006 | 2024-07-28T12:11:32.802Z | 2024-08-03T12:21:50.221Z |
4702357 | 4702357 | 20240726150218_19mD9 | AU0006 | 2024-07-28T12:11:08.463Z | 2024-08-03T12:21:47.689Z |
4701832 | 4701832 | 20240726141546_7nUWy | AU0006 | 2024-07-28T12:10:51.730Z | 2024-08-03T12:21:46.629Z |
4701662 | 4701662 | 20240726135545_Z6LUA | AU0006 | 2024-07-28T12:10:43.282Z | 2024-08-03T12:21:46.173Z |
4701658 | 4701658 | 20240726135543_R38Er | AU0006 | 2024-07-28T12:10:43.254Z | 2024-08-03T12:21:46.172Z |
4701605 | 4701605 | 20240726134939_KIkiH | AU0006 | 2024-07-28T12:10:41.087Z | 2024-08-03T12:21:45.884Z |
4701113 | 4701113 | 20240726130846_YHxni | AU0006 | 2024-07-28T12:10:17.643Z | 2024-08-03T12:21:43.686Z |
4694385 | 4694385 | 20240725164212_aSSGT | AU0006 | 2024-07-27T12:11:51.242Z | 2024-08-02T12:25:19.582Z |
4683520 | 4683520 | 20240724183859_vATR6 | AU0006 | 2024-07-26T12:00:10.859Z | 2024-08-02T12:23:42.469Z |
4683177 | 4683177 | 20240723161916_PPAJP | AU0006 | 2024-07-25T12:07:35.523Z | 2024-07-31T12:18:08.143Z |
4683040 | 4683040 | 20240723155336_sREX1 | AU0006 | 2024-07-25T12:07:25.229Z | 2024-07-31T12:18:07.325Z |
4682935 | 4682935 | 20240723144849_QvxL9 | AU0006 | 2024-07-25T12:07:12.371Z | 2024-07-31T12:18:06.055Z |
4679732 | 4679732 | 20240723174442_Xr3i1 | AU0006 | 2024-07-25T12:00:20.214Z | 2024-08-01T12:11:59.959Z |
4677264 | 4677264 | 20240721125908_qO78w | AU0006 | 2024-07-23T12:04:04.103Z | 2024-07-29T12:17:17.942Z |
4675039 | 4675039 | 20240721154929_2Ui3J | AU0006 | 2024-07-23T12:00:39.528Z | 2024-07-30T12:18:03.017Z |
4674648 | 4674648 | 20240721122759_eNC7U | AU0006 | 2024-07-22T12:02:10.725Z | 2024-07-29T12:17:17.939Z |
4674646 | 4674646 | 20240721114805_F2UJM | AU0006 | 2024-07-22T12:02:10.486Z | 2024-07-29T12:17:17.939Z |
4674644 | 4674644 | 20240721114420_6OPT2 | AU0006 | 2024-07-22T12:02:10.246Z | 2024-07-29T12:17:17.937Z |
4661202 | 4661202 | 20240717215203_3AqIs | AU0006 | 2024-07-19T12:02:54.782Z | 2024-07-26T12:17:26.016Z |
4657124 | 4657124 | 20240715221400_GHSPe | AU0006 | 2024-07-18T12:08:16.864Z | 2024-07-24T12:17:01.883Z |
4657054 | 4657054 | 20240715220438_ZE0wZ | AU0006 | 2024-07-18T12:08:13.673Z | 2024-07-24T12:17:01.037Z |
4656879 | 4656879 | 20240715214144_0yxlm | AU0006 | 2024-07-18T12:08:06.411Z | 2024-07-24T12:16:59.851Z |
4656801 | 4656801 | 20240715213317_EpLtE | AU0006 | 2024-07-18T12:08:03.863Z | 2024-07-24T12:16:59.309Z |
4656780 | 4656780 | 20240715213209_m0nz6 | AU0006 | 2024-07-18T12:08:03.241Z | 2024-07-24T12:16:59.270Z |
4656721 | 4656721 | 20240715211349_In96J | AU0006 | 2024-07-18T12:08:00.757Z | 2024-07-24T12:16:58.758Z |
4656549 | 4656549 | 20240715204555_M8bjW | AU0006 | 2024-07-18T12:07:46.864Z | 2024-07-24T12:16:56.421Z |
4656317 | 4656317 | 20240715200436_sesN3 | AU0006 | 2024-07-18T12:07:26.949Z | 2024-07-24T12:16:54.740Z |
4653828 | 4653828 | 20240716185629_BoXPk | AU0006 | 2024-07-18T12:03:34.662Z | 2024-07-25T12:13:46.701Z |
4653590 | 4653590 | 20240716180335_1V89V | AU0006 | 2024-07-18T12:03:18.359Z | 2024-07-25T12:13:45.430Z |
4653476 | 4653476 | 20240716173947_ayNLh | AU0006 | 2024-07-18T12:03:12.099Z | 2024-07-25T12:13:45.005Z |
4653375 | 4653375 | 20240716171956_nnOYI | AU0006 | 2024-07-18T12:03:05.770Z | 2024-07-25T12:13:44.582Z |
4653234 | 4653234 | 20240716165301_bO5U2 | AU0006 | 2024-07-18T12:02:49.917Z | 2024-07-25T12:13:44.065Z |
4652954 | 4652954 | 20240716160313_6uFyZ | AU0006 | 2024-07-18T12:02:23.093Z | 2024-07-25T12:13:42.152Z |
4652761 | 4652761 | 20240716151138_1GVL2 | AU0006 | 2024-07-18T12:02:10.924Z | 2024-07-25T12:13:41.475Z |
4652686 | 4652686 | 20240716145125_hdPsO | AU0006 | 2024-07-18T12:02:02.406Z | 2024-07-25T12:13:40.890Z |
4652010 | 4652010 | 20240716112408_bl9lS | AU0006 | 2024-07-18T12:00:55.873Z | 2024-07-25T12:13:37.545Z |
3497363 | 3497363 | 20231201165850_HR0Et | AU0006 | 2024-01-06T00:04:52.194Z | 2024-01-06T00:04:52.194Z |
3497048 | 3497048 | 20231201153115_VpqIA | AU0006 | 2024-01-06T00:04:52.160Z | 2024-01-06T00:04:52.160Z |
3497029 | 3497029 | 20231201152857_6yYbq | AU0006 | 2024-01-06T00:04:52.158Z | 2024-01-06T00:04:52.158Z |
3496832 | 3496832 | 20231201144512_263eV | AU0006 | 2024-01-06T00:04:52.138Z | 2024-01-06T00:04:52.138Z |
3496776 | 3496776 | 20231201143036_dF3HT | AU0006 | 2024-01-06T00:04:52.131Z | 2024-01-06T00:04:52.131Z |
3496614 | 3496614 | 20231201135014_NHYJL | AU0006 | 2024-01-06T00:04:52.115Z | 2024-01-06T00:04:52.115Z |
3496554 | 3496554 | 20231201133632_6HYAr | AU0006 | 2024-01-06T00:04:52.109Z | 2024-01-06T00:04:52.109Z |
3496519 | 3496519 | 20231201133438_u33wD | AU0006 | 2024-01-06T00:04:52.106Z | 2024-01-06T00:04:52.106Z |
3496506 | 3496506 | 20231201133235_4lGj5 | AU0006 | 2024-01-06T00:04:52.104Z | 2024-01-06T00:04:52.104Z |
3492571 | 3492571 | 20231130194918_MDp20 | AU0006 | 2024-01-06T00:04:51.762Z | 2024-01-06T00:04:51.762Z |
3492557 | 3492557 | 20231130194832_Va44y | AU0006 | 2024-01-06T00:04:51.761Z | 2024-01-06T00:04:51.761Z |
3492521 | 3492521 | 20231130194211_W8bV4 | AU0006 | 2024-01-06T00:04:51.757Z | 2024-01-06T00:04:51.757Z |
3491796 | 3491796 | 20231130174046_gXguQ | AU0006 | 2024-01-06T00:04:50.492Z | 2024-01-06T00:04:50.492Z |
3491668 | 3491668 | 20231130172228_wdxoK | AU0006 | 2024-01-06T00:04:50.480Z | 2024-01-06T00:04:50.480Z |
3491652 | 3491652 | 20231130171945_X4K1t | AU0006 | 2024-01-06T00:04:50.478Z | 2024-01-06T00:04:50.478Z |
3491636 | 3491636 | 20231130171556_3xgpM | AU0006 | 2024-01-06T00:04:50.476Z | 2024-01-06T00:04:50.476Z |
3491605 | 3491605 | 20231130170734_g6PFv | AU0006 | 2024-01-06T00:04:50.473Z | 2024-01-06T00:04:50.473Z |
3491465 | 3491465 | 20231130163613_A9d50 | AU0006 | 2024-01-06T00:04:50.462Z | 2024-01-06T00:04:50.462Z |
3491400 | 3491400 | 20231130161527_bcCTI | AU0006 | 2024-01-06T00:04:50.457Z | 2024-01-06T00:04:50.457Z |
3491153 | 3491153 | 20231130142601_Ep32l | AU0006 | 2024-01-06T00:04:50.434Z | 2024-01-06T00:04:50.434Z |
3491144 | 3491144 | 20231130141149_NRIq1 | AU0006 | 2024-01-06T00:04:50.433Z | 2024-01-06T00:04:50.433Z |
3490982 | 3490982 | 20231130131735_krGmB | AU0006 | 2024-01-06T00:04:50.418Z | 2024-01-06T00:04:50.418Z |
3490855 | 3490855 | 20231130123640_i1xWv | AU0006 | 2024-01-06T00:04:50.405Z | 2024-01-06T00:04:50.405Z |
3490832 | 3490832 | 20231130123125_WU4jT | AU0006 | 2024-01-06T00:04:50.402Z | 2024-01-06T00:04:50.402Z |
3490818 | 3490818 | 20231130122123_cBzkf | AU0006 | 2024-01-06T00:04:50.401Z | 2024-01-06T00:04:50.401Z |
3488200 | 3488200 | 20231129185545_lmxD6 | AU0006 | 2024-01-06T00:04:48.913Z | 2024-01-06T00:04:48.913Z |
3488174 | 3488174 | 20231129184949_Ubp1C | AU0006 | 2024-01-06T00:04:48.910Z | 2024-01-06T00:04:48.910Z |
3488128 | 3488128 | 20231129183928_LLSYK | AU0006 | 2024-01-06T00:04:48.905Z | 2024-01-06T00:04:48.905Z |
3488110 | 3488110 | 20231129182841_lJ3K2 | AU0006 | 2024-01-06T00:04:48.903Z | 2024-01-06T00:04:48.903Z |
3488034 | 3488034 | 20231129180725_rZjEd | AU0006 | 2024-01-06T00:04:48.895Z | 2024-01-06T00:04:48.895Z |
3487824 | 3487824 | 20231129161001_EbIcm | AU0006 | 2024-01-06T00:04:48.871Z | 2024-01-06T00:04:48.871Z |
3487710 | 3487710 | 20231129140627_PGMJJ | AU0006 | 2024-01-06T00:04:48.857Z | 2024-01-06T00:04:48.857Z |
3487562 | 3487562 | 20231129121026_bIMuZ | AU0006 | 2024-01-06T00:04:48.838Z | 2024-01-06T00:04:48.838Z |
3452786 | 3452786 | 20231121165925_Nq75C | AU0006 | 2024-01-06T00:04:35.789Z | 2024-01-06T00:04:35.789Z |
3452329 | 3452329 | 20231121161002_JfBVo | AU0006 | 2024-01-06T00:04:35.754Z | 2024-01-06T00:04:35.754Z |
3451775 | 3451775 | 20231121143604_U4v3Q | AU0006 | 2024-01-06T00:04:35.704Z | 2024-01-06T00:04:35.704Z |
3451638 | 3451638 | 20231121141239_JdUVM | AU0006 | 2024-01-06T00:04:35.691Z | 2024-01-06T00:04:35.691Z |
3451623 | 3451623 | 20231121140618_ylavG | AU0006 | 2024-01-06T00:04:35.689Z | 2024-01-06T00:04:35.689Z |
3451583 | 3451583 | 20231121140333_3AUEa | AU0006 | 2024-01-06T00:04:35.686Z | 2024-01-06T00:04:35.686Z |
3451452 | 3451452 | 20231121132908_SKwg3 | AU0006 | 2024-01-06T00:04:35.672Z | 2024-01-06T00:04:35.672Z |
3446770 | 3446770 | 20231120195409_fCMpP | AU0006 | 2024-01-06T00:04:33.826Z | 2024-01-06T00:04:33.826Z |
3446404 | 3446404 | 20231120192659_C36ub | AU0006 | 2024-01-06T00:04:33.798Z | 2024-01-06T00:04:33.798Z |
3446152 | 3446152 | 20231120191127_2IhG8 | AU0006 | 2024-01-06T00:04:33.781Z | 2024-01-06T00:04:33.781Z |
3445962 | 3445962 | 20231120185357_IkO2K | AU0006 | 2024-01-06T00:04:33.765Z | 2024-01-06T00:04:33.765Z |
3445899 | 3445899 | 20231120184619_BWcym | AU0006 | 2024-01-06T00:04:33.760Z | 2024-01-06T00:04:33.760Z |
3445604 | 3445604 | 20231120181721_4mqJ9 | AU0006 | 2024-01-06T00:04:33.737Z | 2024-01-06T00:04:33.737Z |
3445366 | 3445366 | 20231120175454_MkZ5x | AU0006 | 2024-01-06T00:04:33.719Z | 2024-01-06T00:04:33.719Z |
3445333 | 3445333 | 20231120175211_isr8u | AU0006 | 2024-01-06T00:04:33.717Z | 2024-01-06T00:04:33.717Z |
3445302 | 3445302 | 20231120174742_TCdXD | AU0006 | 2024-01-06T00:04:33.714Z | 2024-01-06T00:04:33.714Z |
3445113 | 3445113 | 20231120173427_ZJ4l3 | AU0006 | 2024-01-06T00:04:33.702Z | 2024-01-06T00:04:33.702Z |
3444955 | 3444955 | 20231120171755_Vj4n1 | AU0006 | 2024-01-06T00:04:33.689Z | 2024-01-06T00:04:33.689Z |
3444894 | 3444894 | 20231120171345_w38tw | AU0006 | 2024-01-06T00:04:33.684Z | 2024-01-06T00:04:33.684Z |
3444683 | 3444683 | 20231120164957_JFuXo | AU0006 | 2024-01-06T00:04:33.667Z | 2024-01-06T00:04:33.667Z |
3444039 | 3444039 | 20231120155106_Zkp5z | AU0006 | 2024-01-06T00:04:33.621Z | 2024-01-06T00:04:33.621Z |
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);