participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
291 rows where station_code = "AU001G" 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 |
---|---|---|---|---|---|
5059166 | 5059166 | 20240910171902_HaATC | AU001G | 2024-09-14T12:05:22.875Z | 2024-09-16T12:18:02.467Z |
5058542 | 5058542 | 20240910162242_L88X4 | AU001G | 2024-09-14T12:03:54.671Z | 2024-09-16T12:17:55.872Z |
5051853 | 5051853 | 20240907185454_nnRzn | AU001G | 2024-09-13T12:14:38.011Z | 2024-09-16T12:21:02.154Z |
5051117 | 5051117 | 20240907165028_7UjKT | AU001G | 2024-09-13T12:14:02.781Z | 2024-09-16T12:20:59.613Z |
5050228 | 5050228 | 20240907145238_E6G8a | AU001G | 2024-09-13T12:13:19.169Z | 2024-09-16T12:20:56.789Z |
5050206 | 5050206 | 20240907144841_in384 | AU001G | 2024-09-13T12:13:17.293Z | 2024-09-16T12:20:56.716Z |
5036240 | 5036240 | 20240905130137_3nCVl | AU001G | 2024-09-12T12:13:30.605Z | 2024-09-14T12:22:52.131Z |
5030689 | 5030689 | 20240906174209_LiJaG | AU001G | 2024-09-12T12:02:40.432Z | 2024-09-15T12:21:19.471Z |
5030668 | 5030668 | 20240906173049_oOWBq | AU001G | 2024-09-12T12:02:36.510Z | 2024-09-15T12:21:19.435Z |
5030210 | 5030210 | 20240906134319_aqzvX | AU001G | 2024-09-12T12:01:27.722Z | 2024-09-15T12:21:18.265Z |
5014563 | 5014563 | 20240905130137_b9mow | AU001G | 2024-09-10T12:03:28.154Z | 2024-09-11T12:16:31.205Z |
5006686 | 5006686 | 20240903182606_litnl | AU001G | 2024-09-09T12:04:55.008Z | 2024-09-12T12:19:09.240Z |
5006580 | 5006580 | 20240903175537_S5Snx | AU001G | 2024-09-09T12:04:47.321Z | 2024-09-12T12:19:08.955Z |
5006469 | 5006469 | 20240903173816_e9pO6 | AU001G | 2024-09-09T12:04:40.911Z | 2024-09-12T12:19:08.297Z |
5005741 | 5005741 | 20240903160311_xOYMp | AU001G | 2024-09-09T12:04:01.323Z | 2024-09-12T12:19:06.547Z |
4996070 | 4996070 | 20240902183608_k7ZBj | AU001G | 2024-09-08T12:04:20.578Z | 2024-09-11T12:20:50.903Z |
4987459 | 4987459 | 20240901173348_FV3Mu | AU001G | 2024-09-07T12:05:49.534Z | 2024-09-10T12:19:10.805Z |
4987276 | 4987276 | 20240901170859_zk7Wb | AU001G | 2024-09-07T12:05:32.305Z | 2024-09-10T12:19:10.353Z |
4985020 | 4985020 | 20240901112021_62izV | AU001G | 2024-09-07T12:02:44.229Z | 2024-09-10T12:19:06.774Z |
4934753 | 4934753 | 20240810185529_3b9Ei | AU001G | 2024-09-01T12:05:45.668Z | 2024-09-06T12:20:19.744Z |
4925270 | 4925270 | 20240810144702_v1Tta | AU001G | 2024-08-31T12:03:10.639Z | 2024-09-06T12:17:31.558Z |
4924949 | 4924949 | 20240810142630_qLClE | AU001G | 2024-08-31T12:02:45.304Z | 2024-09-06T12:17:17.611Z |
4907287 | 4907287 | 20240809140509_tMcgY | AU001G | 2024-08-29T12:02:51.429Z | 2024-09-02T12:18:17.592Z |
4905441 | 4905441 | 20240809104713_SDSru | AU001G | 2024-08-29T12:00:19.587Z | 2024-09-02T12:16:45.139Z |
4897546 | 4897546 | 20240807183101_eGhv3 | AU001G | 2024-08-28T12:15:34.348Z | 2024-08-28T12:15:34.348Z |
4897505 | 4897505 | 20240807181438_t08KR | AU001G | 2024-08-28T12:15:32.156Z | 2024-08-28T12:15:32.156Z |
4897057 | 4897057 | 20240807170319_9AGNA | AU001G | 2024-08-28T12:15:02.047Z | 2024-08-28T12:15:02.047Z |
4896773 | 4896773 | 20240807161745_8Gn38 | AU001G | 2024-08-28T12:14:45.455Z | 2024-08-28T12:14:45.455Z |
4896604 | 4896604 | 20240807154205_XnOox | AU001G | 2024-08-28T12:14:36.690Z | 2024-08-28T12:14:36.690Z |
4895847 | 4895847 | 20240807133303_8pMlD | AU001G | 2024-08-28T12:13:42.456Z | 2024-08-28T12:13:42.456Z |
4871146 | 4871146 | 20240806191907_JwCCm | AU001G | 2024-08-19T12:08:35.161Z | 2024-08-27T12:09:21.638Z |
4871088 | 4871088 | 20240806190538_tlm4H | AU001G | 2024-08-19T12:08:31.232Z | 2024-08-27T12:09:18.336Z |
4817033 | 4817033 | 20240803183144_2AVh3 | AU001G | 2024-08-13T12:14:45.244Z | 2024-08-15T12:23:09.785Z |
4816499 | 4816499 | 20240803180039_FWiTy | AU001G | 2024-08-13T12:14:20.849Z | 2024-08-15T12:23:00.109Z |
4816046 | 4816046 | 20240803173631_Ohnwe | AU001G | 2024-08-13T12:14:01.986Z | 2024-08-15T12:22:53.679Z |
4815279 | 4815279 | 20240803170035_HttHE | AU001G | 2024-08-13T12:13:27.348Z | 2024-08-15T12:22:37.805Z |
4811543 | 4811543 | 20240803141546_YvoiB | AU001G | 2024-08-13T12:09:54.033Z | 2024-08-15T12:20:52.392Z |
4808048 | 4808048 | 20240803104047_tvXwN | AU001G | 2024-08-13T12:04:40.250Z | 2024-08-15T12:18:51.818Z |
4802484 | 4802484 | 20240802185426_w9IQF | AU001G | 2024-08-12T12:13:53.540Z | 2024-08-13T12:16:34.166Z |
4802368 | 4802368 | 20240802183916_DndwI | AU001G | 2024-08-12T12:13:40.752Z | 2024-08-13T12:16:33.744Z |
4802349 | 4802349 | 20240802183757_MWcNK | AU001G | 2024-08-12T12:13:39.523Z | 2024-08-13T12:16:33.714Z |
4802304 | 4802304 | 20240802183332_8P227 | AU001G | 2024-08-12T12:13:34.399Z | 2024-08-13T12:16:33.558Z |
4801677 | 4801677 | 20240802175142_2YA2Q | AU001G | 2024-08-12T12:12:54.558Z | 2024-08-13T12:16:28.613Z |
4800172 | 4800172 | 20240802164756_TAFOo | AU001G | 2024-08-12T12:11:10.418Z | 2024-08-13T12:16:23.134Z |
4799921 | 4799921 | 20240802163802_Hj0ge | AU001G | 2024-08-12T12:10:39.759Z | 2024-08-13T12:16:22.330Z |
4798730 | 4798730 | 20240802154948_fwG3Y | AU001G | 2024-08-12T12:08:50.720Z | 2024-08-13T12:16:18.779Z |
4794455 | 4794455 | 20240802151517_58bJj | AU001G | 2024-08-11T12:10:17.791Z | 2024-08-13T12:16:16.247Z |
4793741 | 4793741 | 20240802144258_THQ61 | AU001G | 2024-08-11T12:09:49.497Z | 2024-08-13T12:16:13.687Z |
4793337 | 4793337 | 20240802142548_lD893 | AU001G | 2024-08-11T12:09:25.137Z | 2024-08-13T12:16:12.470Z |
4793151 | 4793151 | 20240802141746_azjWo | AU001G | 2024-08-11T12:09:14.510Z | 2024-08-13T12:16:12.013Z |
4791600 | 4791600 | 20240802131219_JQCnr | AU001G | 2024-08-11T12:08:17.418Z | 2024-08-13T12:16:08.004Z |
4789047 | 4789047 | 20240802101806_Epj5R | AU001G | 2024-08-11T12:05:27.519Z | 2024-08-13T12:15:56.785Z |
4778154 | 4778154 | 20240801193534_vUMJh | AU001G | 2024-08-07T12:11:11.017Z | 2024-08-11T12:13:36.323Z |
4778122 | 4778122 | 20240801190946_0J7Mj | AU001G | 2024-08-07T12:11:09.163Z | 2024-08-11T12:13:33.783Z |
4778101 | 4778101 | 20240801185852_w4pMM | AU001G | 2024-08-07T12:11:08.023Z | 2024-08-11T12:13:31.144Z |
4777991 | 4777991 | 20240801181703_AXUJs | AU001G | 2024-08-07T12:11:01.459Z | 2024-08-11T12:13:26.666Z |
4777827 | 4777827 | 20240801175616_2jN19 | AU001G | 2024-08-07T12:10:55.968Z | 2024-08-11T12:13:22.458Z |
4777699 | 4777699 | 20240801173757_lVdre | AU001G | 2024-08-07T12:10:51.754Z | 2024-08-11T12:13:17.922Z |
4777457 | 4777457 | 20240801165942_4cJU5 | AU001G | 2024-08-07T12:10:45.539Z | 2024-08-11T12:13:12.903Z |
4777264 | 4777264 | 20240801163208_jdjjY | AU001G | 2024-08-07T12:10:31.142Z | 2024-08-11T12:13:06.907Z |
4777190 | 4777190 | 20240801162409_YMYnX | AU001G | 2024-08-07T12:10:22.213Z | 2024-08-11T12:13:04.908Z |
4777099 | 4777099 | 20240801161528_H3x43 | AU001G | 2024-08-07T12:10:15.410Z | 2024-08-11T12:13:03.195Z |
4776369 | 4776369 | 20240801144812_XjOpg | AU001G | 2024-08-07T12:09:20.707Z | 2024-08-11T12:12:49.616Z |
4776340 | 4776340 | 20240801144518_0OvSS | AU001G | 2024-08-07T12:09:17.372Z | 2024-08-11T12:12:49.139Z |
4776074 | 4776074 | 20240801141603_YNdTL | AU001G | 2024-08-07T12:09:02.076Z | 2024-08-11T12:12:46.516Z |
4768958 | 4768958 | 20240731185230_L1oMb | AU001G | 2024-08-06T12:10:24.395Z | 2024-08-10T12:20:19.690Z |
4768770 | 4768770 | 20240731182055_T7e4E | AU001G | 2024-08-06T12:10:14.638Z | 2024-08-10T12:20:15.218Z |
4768347 | 4768347 | 20240731171221_Lb20C | AU001G | 2024-08-06T12:09:54.889Z | 2024-08-10T12:20:05.119Z |
4768165 | 4768165 | 20240731164846_xD3MT | AU001G | 2024-08-06T12:09:49.673Z | 2024-08-10T12:20:02.702Z |
4767666 | 4767666 | 20240731153017_naHnz | AU001G | 2024-08-06T12:09:23.356Z | 2024-08-10T12:19:50.147Z |
4767652 | 4767652 | 20240731152918_cUeEl | AU001G | 2024-08-06T12:09:22.751Z | 2024-08-10T12:19:49.730Z |
4766826 | 4766826 | 20240731135721_VtrEn | AU001G | 2024-08-06T12:08:51.372Z | 2024-08-10T12:19:32.987Z |
4766310 | 4766310 | 20240731124819_fEbAC | AU001G | 2024-08-06T12:08:24.790Z | 2024-08-10T12:19:21.760Z |
4766111 | 4766111 | 20240731121644_r4aWh | AU001G | 2024-08-06T12:08:10.037Z | 2024-08-10T12:19:17.103Z |
4766040 | 4766040 | 20240731120228_ySqT0 | AU001G | 2024-08-06T12:08:05.985Z | 2024-08-10T12:19:15.819Z |
4765639 | 4765639 | 20240731105858_lWboT | AU001G | 2024-08-06T12:07:35.512Z | 2024-08-10T12:19:08.843Z |
4756657 | 4756657 | 20240730185330_RSj1Z | AU001G | 2024-08-05T12:12:19.684Z | 2024-08-08T12:22:13.295Z |
4756322 | 4756322 | 20240730175550_LVLGc | AU001G | 2024-08-05T12:11:48.308Z | 2024-08-08T12:21:54.329Z |
4756185 | 4756185 | 20240730174245_Sgd9J | AU001G | 2024-08-05T12:11:41.955Z | 2024-08-08T12:21:49.333Z |
4755579 | 4755579 | 20240730165141_2TCKt | AU001G | 2024-08-05T12:11:18.563Z | 2024-08-08T12:21:23.259Z |
4755480 | 4755480 | 20240730164641_LcdKy | AU001G | 2024-08-05T12:11:14.431Z | 2024-08-08T12:21:19.074Z |
4755464 | 4755464 | 20240730164338_WqxPA | AU001G | 2024-08-05T12:11:13.834Z | 2024-08-08T12:21:18.629Z |
4755178 | 4755178 | 20240730161355_JiOQ2 | AU001G | 2024-08-05T12:10:47.349Z | 2024-08-08T12:21:10.773Z |
4754996 | 4754996 | 20240730155501_KVBhw | AU001G | 2024-08-05T12:10:36.186Z | 2024-08-08T12:21:07.122Z |
4752588 | 4752588 | 20240730104736_KBz3T | AU001G | 2024-08-05T12:06:10.687Z | 2024-08-08T12:20:03.419Z |
4740308 | 4740308 | 20240729193300_xcrgb | AU001G | 2024-08-03T12:12:01.483Z | 2024-08-06T12:15:16.601Z |
4740208 | 4740208 | 20240729191509_lL5ys | AU001G | 2024-08-03T12:11:49.968Z | 2024-08-06T12:15:16.283Z |
4740183 | 4740183 | 20240729191133_MOBdt | AU001G | 2024-08-03T12:11:47.132Z | 2024-08-06T12:15:16.215Z |
4739964 | 4739964 | 20240729181859_9sBnm | AU001G | 2024-08-03T12:11:19.809Z | 2024-08-06T12:15:14.863Z |
4739780 | 4739780 | 20240729173241_W913i | AU001G | 2024-08-03T12:11:02.671Z | 2024-08-06T12:15:14.348Z |
4739765 | 4739765 | 20240729172535_3F4ng | AU001G | 2024-08-03T12:11:01.897Z | 2024-08-06T12:15:14.264Z |
4739593 | 4739593 | 20240729164814_8Yclh | AU001G | 2024-08-03T12:10:45.868Z | 2024-08-06T12:15:13.775Z |
4739471 | 4739471 | 20240729163002_3M6H1 | AU001G | 2024-08-03T12:10:33.339Z | 2024-08-06T12:15:13.161Z |
4739395 | 4739395 | 20240729161607_bFRwy | AU001G | 2024-08-03T12:10:24.421Z | 2024-08-06T12:15:12.997Z |
4739234 | 4739234 | 20240729153706_pG6GP | AU001G | 2024-08-03T12:10:00.615Z | 2024-08-06T12:15:12.456Z |
4739164 | 4739164 | 20240729151605_lqoAS | AU001G | 2024-08-03T12:09:52.150Z | 2024-08-06T12:15:12.160Z |
4739127 | 4739127 | 20240729150701_Z8lA8 | AU001G | 2024-08-03T12:09:50.612Z | 2024-08-06T12:15:12.115Z |
4738815 | 4738815 | 20240729133504_xDqL6 | AU001G | 2024-08-03T12:09:20.432Z | 2024-08-06T12:15:11.379Z |
4726755 | 4726755 | 20240728184210_3F72p | AU001G | 2024-07-31T12:12:38.019Z | 2024-08-05T12:20:24.214Z |
4726727 | 4726727 | 20240728183401_e0ReK | AU001G | 2024-07-31T12:12:37.282Z | 2024-08-05T12:20:24.122Z |
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);