participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
394 rows where station_code = "AU0045" 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 |
---|---|---|---|---|---|
5084149 | 5084149 | 20240912183142_KOOG6 | AU0045 | 2024-09-16T12:01:16.331Z | 2024-09-16T12:17:04.138Z |
5083933 | 5083933 | 20240912165710_24xYY | AU0045 | 2024-09-16T12:00:41.164Z | 2024-09-16T12:17:03.989Z |
5083884 | 5083884 | 20240912163457_JY7z1 | AU0045 | 2024-09-16T12:00:35.575Z | 2024-09-16T12:17:03.963Z |
5067712 | 5067712 | 20240910100429_mD2JB | AU0045 | 2024-09-14T12:18:54.789Z | 2024-09-16T12:20:11.325Z |
5062618 | 5062618 | 20240909174949_MtgbE | AU0045 | 2024-09-14T12:12:37.925Z | 2024-09-16T12:19:38.201Z |
5062003 | 5062003 | 20240909163233_i12B5 | AU0045 | 2024-09-14T12:11:43.573Z | 2024-09-16T12:19:35.051Z |
5061312 | 5061312 | 20240909144513_Y3AkD | AU0045 | 2024-09-14T12:10:41.643Z | 2024-09-16T12:19:30.569Z |
5060922 | 5060922 | 20240909132446_rUptL | AU0045 | 2024-09-14T12:09:55.911Z | 2024-09-16T12:19:28.264Z |
5059874 | 5059874 | 20240910191134_2yI37 | AU0045 | 2024-09-14T12:07:30.462Z | 2024-09-16T12:18:09.630Z |
5058261 | 5058261 | 20240910155932_cb8SA | AU0045 | 2024-09-14T12:03:17.539Z | 2024-09-16T12:17:52.151Z |
5051847 | 5051847 | 20240907185309_zhHng | AU0045 | 2024-09-13T12:14:37.746Z | 2024-09-16T12:21:02.146Z |
5049935 | 5049935 | 20240909120101_ckVHV | AU0045 | 2024-09-13T12:12:32.644Z | 2024-09-16T12:20:44.848Z |
5043659 | 5043659 | 20240908123253_Q34Xt | AU0045 | 2024-09-13T12:00:20.429Z | 2024-09-16T12:20:18.437Z |
5035871 | 5035871 | 20240907104137_Q7jQE | AU0045 | 2024-09-12T12:12:36.550Z | 2024-09-15T12:21:41.447Z |
5035685 | 5035685 | 20240907100526_eMdB5 | AU0045 | 2024-09-12T12:12:21.821Z | 2024-09-15T12:21:40.510Z |
5030847 | 5030847 | 20240906190507_oO2re | AU0045 | 2024-09-12T12:03:14.007Z | 2024-09-15T12:21:20.148Z |
5030729 | 5030729 | 20240906180046_4bE6D | AU0045 | 2024-09-12T12:02:47.559Z | 2024-09-15T12:21:19.522Z |
5030670 | 5030670 | 20240906173101_vh35p | AU0045 | 2024-09-12T12:02:36.746Z | 2024-09-15T12:21:19.445Z |
5030626 | 5030626 | 20240906172034_eHVlS | AU0045 | 2024-09-12T12:02:30.353Z | 2024-09-15T12:21:19.284Z |
5006974 | 5006974 | 20240903193727_qEJkG | AU0045 | 2024-09-09T12:05:16.890Z | 2024-09-12T12:19:10.992Z |
5006911 | 5006911 | 20240903192656_4qws8 | AU0045 | 2024-09-09T12:05:12.664Z | 2024-09-12T12:19:10.856Z |
5006646 | 5006646 | 20240903181628_rZoJp | AU0045 | 2024-09-09T12:04:51.079Z | 2024-09-12T12:19:09.126Z |
5006546 | 5006546 | 20240903175020_ZAu7I | AU0045 | 2024-09-09T12:04:45.378Z | 2024-09-12T12:19:08.732Z |
5006463 | 5006463 | 20240903173702_63mTh | AU0045 | 2024-09-09T12:04:40.597Z | 2024-09-12T12:19:08.292Z |
5006361 | 5006361 | 20240903172849_ie7el | AU0045 | 2024-09-09T12:04:32.649Z | 2024-09-12T12:19:08.202Z |
5006312 | 5006312 | 20240903172031_Nisix | AU0045 | 2024-09-09T12:04:30.445Z | 2024-09-12T12:19:08.101Z |
5005777 | 5005777 | 20240903161022_E1PTl | AU0045 | 2024-09-09T12:04:03.935Z | 2024-09-12T12:19:06.643Z |
5005694 | 5005694 | 20240903155743_23Eez | AU0045 | 2024-09-09T12:03:55.659Z | 2024-09-12T12:19:06.452Z |
5005669 | 5005669 | 20240903155258_foGdV | AU0045 | 2024-09-09T12:03:54.259Z | 2024-09-12T12:19:06.416Z |
5005557 | 5005557 | 20240903153334_PFMMa | AU0045 | 2024-09-09T12:03:48.728Z | 2024-09-12T12:19:06.170Z |
5005498 | 5005498 | 20240903152124_Gtf1v | AU0045 | 2024-09-09T12:03:45.914Z | 2024-09-12T12:19:06.037Z |
5005133 | 5005133 | 20240903140806_PfQSV | AU0045 | 2024-09-09T12:03:22.054Z | 2024-09-12T12:19:05.353Z |
5005107 | 5005107 | 20240903135917_15FfJ | AU0045 | 2024-09-09T12:03:20.266Z | 2024-09-12T12:19:05.278Z |
5004991 | 5004991 | 20240903134420_I1WhO | AU0045 | 2024-09-09T12:03:15.161Z | 2024-09-12T12:19:04.704Z |
5004648 | 5004648 | 20240903120019_4B37j | AU0045 | 2024-09-09T12:02:52.790Z | 2024-09-12T12:19:03.377Z |
5004279 | 5004279 | 20240903111251_ASDJg | AU0045 | 2024-09-09T12:02:33.577Z | 2024-09-12T12:19:01.473Z |
4996380 | 4996380 | 20240902192908_vH9p5 | AU0045 | 2024-09-08T12:04:45.583Z | 2024-09-11T12:20:53.390Z |
4995950 | 4995950 | 20240902181912_UCFgM | AU0045 | 2024-09-08T12:04:13.624Z | 2024-09-11T12:20:49.830Z |
4995856 | 4995856 | 20240902180110_uVV3f | AU0045 | 2024-09-08T12:04:08.095Z | 2024-09-11T12:20:48.975Z |
4995662 | 4995662 | 20240902172629_RtdR0 | AU0045 | 2024-09-08T12:03:53.326Z | 2024-09-11T12:20:47.232Z |
4995459 | 4995459 | 20240902170311_i2Qp9 | AU0045 | 2024-09-08T12:03:40.602Z | 2024-09-11T12:20:45.543Z |
4995143 | 4995143 | 20240902162103_xl8aR | AU0045 | 2024-09-08T12:03:17.746Z | 2024-09-11T12:20:42.406Z |
4994968 | 4994968 | 20240902154642_ZQxNh | AU0045 | 2024-09-08T12:03:08.468Z | 2024-09-11T12:20:40.685Z |
4993723 | 4993723 | 20240902111708_UbRru | AU0045 | 2024-09-08T12:01:50.099Z | 2024-09-11T12:20:26.237Z |
4986428 | 4986428 | 20240901150718_urwRz | AU0045 | 2024-09-07T12:04:34.531Z | 2024-09-10T12:19:09.299Z |
4986391 | 4986391 | 20240901145813_eQbje | AU0045 | 2024-09-07T12:04:31.713Z | 2024-09-10T12:19:09.279Z |
4986372 | 4986372 | 20240901145338_6JWAh | AU0045 | 2024-09-07T12:04:29.189Z | 2024-09-10T12:19:09.230Z |
4986328 | 4986328 | 20240901144341_6uW5j | AU0045 | 2024-09-07T12:04:26.103Z | 2024-09-10T12:19:09.162Z |
4986059 | 4986059 | 20240901141140_ZLdCa | AU0045 | 2024-09-07T12:04:05.425Z | 2024-09-10T12:19:08.869Z |
4985970 | 4985970 | 20240901135730_nsyIO | AU0045 | 2024-09-07T12:03:57.318Z | 2024-09-10T12:19:08.691Z |
4985744 | 4985744 | 20240901132807_jSlFb | AU0045 | 2024-09-07T12:03:42.766Z | 2024-09-10T12:19:08.313Z |
4985617 | 4985617 | 20240901130448_lhpFU | AU0045 | 2024-09-07T12:03:31.418Z | 2024-09-10T12:19:08.084Z |
4985241 | 4985241 | 20240901114753_No9e1 | AU0045 | 2024-09-07T12:03:01.776Z | 2024-09-10T12:19:07.347Z |
4962757 | 4962757 | 20240811192107_twiXQ | AU0045 | 2024-09-04T12:04:50.446Z | 2024-09-06T12:04:01.351Z |
4962063 | 4962063 | 20240811183327_aCWtz | AU0045 | 2024-09-04T12:04:14.523Z | 2024-09-06T12:03:26.389Z |
4961835 | 4961835 | 20240811180833_pJRdp | AU0045 | 2024-09-04T12:03:57.758Z | 2024-09-06T12:03:16.543Z |
4961757 | 4961757 | 20240811180109_nQxEY | AU0045 | 2024-09-04T12:03:53.855Z | 2024-09-06T12:03:13.369Z |
4961207 | 4961207 | 20240811172406_y6BkD | AU0045 | 2024-09-04T12:03:22.876Z | 2024-09-06T12:02:47.585Z |
4960894 | 4960894 | 20240811170006_cDVq5 | AU0045 | 2024-09-04T12:03:04.035Z | 2024-09-06T12:02:31.760Z |
4960481 | 4960481 | 20240811162727_5PbXy | AU0045 | 2024-09-04T12:02:34.956Z | 2024-09-06T12:02:12.565Z |
4960469 | 4960469 | 20240811162650_xUyLK | AU0045 | 2024-09-04T12:02:34.171Z | 2024-09-06T12:02:10.660Z |
4960080 | 4960080 | 20240811155951_D7GGC | AU0045 | 2024-09-04T12:02:10.663Z | 2024-09-06T12:01:51.481Z |
4959841 | 4959841 | 20240811154126_TpeSA | AU0045 | 2024-09-04T12:01:58.685Z | 2024-09-06T12:01:39.797Z |
4959450 | 4959450 | 20240811150538_8PT0a | AU0045 | 2024-09-04T12:01:35.531Z | 2024-09-06T12:01:17.333Z |
4959397 | 4959397 | 20240811150121_8QXFE | AU0045 | 2024-09-04T12:01:31.390Z | 2024-09-06T12:01:14.858Z |
4959326 | 4959326 | 20240811145335_CdEir | AU0045 | 2024-09-04T12:01:25.434Z | 2024-09-06T12:01:10.977Z |
4959277 | 4959277 | 20240811122846_rDNZN | AU0045 | 2024-09-03T12:23:14.931Z | 2024-09-06T12:32:38.647Z |
4959229 | 4959229 | 20240811122134_RrBt1 | AU0045 | 2024-09-03T12:23:11.085Z | 2024-09-06T12:32:37.430Z |
4958657 | 4958657 | 20240811105509_v9egI | AU0045 | 2024-09-03T12:22:32.269Z | 2024-09-06T12:32:17.054Z |
4958360 | 4958360 | 20240811102441_UeUnG | AU0045 | 2024-09-03T12:22:22.462Z | 2024-09-06T12:32:02.668Z |
4958065 | 4958065 | 20240811095336_Gvl3j | AU0045 | 2024-09-03T12:22:06.879Z | 2024-09-06T12:31:50.290Z |
4957882 | 4957882 | 20240811093141_XBogX | AU0045 | 2024-09-03T12:21:50.681Z | 2024-09-06T12:31:41.376Z |
4951914 | 4951914 | 20240811144452_BtTNg | AU0045 | 2024-09-03T12:01:35.158Z | 2024-09-06T12:01:05.876Z |
4951293 | 4951293 | 20240811132736_XVptv | AU0045 | 2024-09-03T12:00:48.049Z | 2024-09-06T12:00:36.299Z |
4935319 | 4935319 | 20240810200501_mDhPB | AU0045 | 2024-09-01T12:06:22.430Z | 2024-09-06T12:20:34.586Z |
4935297 | 4935297 | 20240810200344_K409h | AU0045 | 2024-09-01T12:06:21.265Z | 2024-09-06T12:20:34.155Z |
4935234 | 4935234 | 20240810195707_mC3Na | AU0045 | 2024-09-01T12:06:17.614Z | 2024-09-06T12:20:32.628Z |
4935027 | 4935027 | 20240810192913_h1cbf | AU0045 | 2024-09-01T12:06:01.661Z | 2024-09-06T12:20:25.900Z |
4934938 | 4934938 | 20240810191926_NvbbL | AU0045 | 2024-09-01T12:05:56.842Z | 2024-09-06T12:20:23.974Z |
4934762 | 4934762 | 20240810185613_3aWEo | AU0045 | 2024-09-01T12:05:46.062Z | 2024-09-06T12:20:19.920Z |
4934481 | 4934481 | 20240810182139_Pr7T8 | AU0045 | 2024-09-01T12:05:25.985Z | 2024-09-06T12:20:12.833Z |
4934437 | 4934437 | 20240810181629_NS4WO | AU0045 | 2024-09-01T12:05:21.729Z | 2024-09-06T12:20:11.925Z |
4934429 | 4934429 | 20240810181512_31GQ3 | AU0045 | 2024-09-01T12:05:20.525Z | 2024-09-06T12:20:11.718Z |
4934369 | 4934369 | 20240810180856_B7Es7 | AU0045 | 2024-09-01T12:05:13.296Z | 2024-09-06T12:20:09.960Z |
4934095 | 4934095 | 20240810174458_V22SY | AU0045 | 2024-09-01T12:04:56.622Z | 2024-09-06T12:19:56.179Z |
4933825 | 4933825 | 20240810172903_x6P78 | AU0045 | 2024-09-01T12:04:40.332Z | 2024-09-06T12:19:37.950Z |
4933583 | 4933583 | 20240810171404_bSTrG | AU0045 | 2024-09-01T12:04:27.775Z | 2024-09-06T12:19:23.876Z |
4933173 | 4933173 | 20240810164740_WN1pd | AU0045 | 2024-09-01T12:04:01.187Z | 2024-09-06T12:19:00.921Z |
4933152 | 4933152 | 20240810164449_aUw7H | AU0045 | 2024-09-01T12:03:59.148Z | 2024-09-06T12:19:00.318Z |
4933066 | 4933066 | 20240810164025_x4mG4 | AU0045 | 2024-09-01T12:03:55.354Z | 2024-09-06T12:18:55.813Z |
4932875 | 4932875 | 20240810162539_TPZCM | AU0045 | 2024-09-01T12:03:46.011Z | 2024-09-06T12:18:50.486Z |
4932471 | 4932471 | 20240810155958_g33nh | AU0045 | 2024-09-01T12:03:23.521Z | 2024-09-06T12:18:39.943Z |
4932175 | 4932175 | 20240810154329_5T8un | AU0045 | 2024-09-01T12:03:06.340Z | 2024-09-06T12:18:28.902Z |
4931993 | 4931993 | 20240810113657_f0lOE | AU0045 | 2024-08-31T12:25:12.767Z | 2024-09-02T12:31:19.107Z |
4931581 | 4931581 | 20240810104445_jLedb | AU0045 | 2024-08-31T12:24:43.105Z | 2024-09-02T12:31:01.912Z |
4931365 | 4931365 | 20240810102005_2su0o | AU0045 | 2024-08-31T12:24:32.787Z | 2024-09-02T12:30:50.128Z |
4925602 | 4925602 | 20240810150857_JIVh3 | AU0045 | 2024-08-31T12:03:33.130Z | 2024-09-06T12:17:55.770Z |
4925085 | 4925085 | 20240810143644_Qbv3O | AU0045 | 2024-08-31T12:02:57.613Z | 2024-09-06T12:17:23.524Z |
4924968 | 4924968 | 20240810142837_S1ZRQ | AU0045 | 2024-08-31T12:02:47.631Z | 2024-09-06T12:17:18.253Z |
4924927 | 4924927 | 20240810142422_bMR9G | AU0045 | 2024-08-31T12:02:43.747Z | 2024-09-06T12:17:16.901Z |
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);