participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,799 rows where station_code = "AU002F" 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 |
---|---|---|---|---|---|
5097065 | 5097065 | 20240912141124_PosUE | AU002F | 2024-09-16T12:16:43.913Z | 2024-09-16T12:17:32.018Z |
5084370 | 5084370 | 20240912193032_RcsQs | AU002F | 2024-09-16T12:01:58.707Z | 2024-09-16T12:17:04.273Z |
5084311 | 5084311 | 20240912191713_tNZC5 | AU002F | 2024-09-16T12:01:51.047Z | 2024-09-16T12:17:04.242Z |
5084094 | 5084094 | 20240912180608_H3xqr | AU002F | 2024-09-16T12:01:08.279Z | 2024-09-16T12:17:04.093Z |
5072875 | 5072875 | 20240911204501_254Sw | AU002F | 2024-09-15T12:06:14.550Z | 2024-09-16T12:17:29.165Z |
5072851 | 5072851 | 20240911204356_udtx3 | AU002F | 2024-09-15T12:06:12.083Z | 2024-09-16T12:17:29.159Z |
5072756 | 5072756 | 20240911203934_VbTQ6 | AU002F | 2024-09-15T12:06:06.194Z | 2024-09-16T12:17:29.146Z |
5072667 | 5072667 | 20240911203603_ywQlk | AU002F | 2024-09-15T12:05:59.086Z | 2024-09-16T12:17:29.131Z |
5072131 | 5072131 | 20240911194028_SYpqR | AU002F | 2024-09-15T12:04:44.180Z | 2024-09-16T12:17:29.031Z |
5071992 | 5071992 | 20240911191737_Adgmx | AU002F | 2024-09-15T12:04:14.939Z | 2024-09-16T12:17:28.998Z |
5071820 | 5071820 | 20240911182809_vi4Ut | AU002F | 2024-09-15T12:03:46.518Z | 2024-09-16T12:17:28.950Z |
5071788 | 5071788 | 20240911181926_VlRth | AU002F | 2024-09-15T12:03:33.336Z | 2024-09-16T12:17:28.942Z |
5071686 | 5071686 | 20240911175007_U29mS | AU002F | 2024-09-15T12:03:15.069Z | 2024-09-16T12:17:28.896Z |
5068618 | 5068618 | 20240910115554_cZ3Yh | AU002F | 2024-09-14T12:19:19.548Z | 2024-09-16T12:20:14.490Z |
5060891 | 5060891 | 20240909131545_bieD3 | AU002F | 2024-09-14T12:09:53.718Z | 2024-09-16T12:19:28.046Z |
5060325 | 5060325 | 20240910201848_Zcq0c | AU002F | 2024-09-14T12:08:38.976Z | 2024-09-16T12:18:14.742Z |
5059812 | 5059812 | 20240910185844_PqxJX | AU002F | 2024-09-14T12:07:19.209Z | 2024-09-16T12:18:08.854Z |
5059771 | 5059771 | 20240910184637_of2bL | AU002F | 2024-09-14T12:07:09.889Z | 2024-09-16T12:18:08.296Z |
5059649 | 5059649 | 20240910182309_cXGq2 | AU002F | 2024-09-14T12:06:39.585Z | 2024-09-16T12:18:06.743Z |
5059591 | 5059591 | 20240910181442_PmC53 | AU002F | 2024-09-14T12:06:32.564Z | 2024-09-16T12:18:06.322Z |
5059493 | 5059493 | 20240910175145_P2utL | AU002F | 2024-09-14T12:06:13.720Z | 2024-09-16T12:18:05.399Z |
5059086 | 5059086 | 20240910171202_XOprz | AU002F | 2024-09-14T12:05:13.239Z | 2024-09-16T12:18:01.672Z |
5058749 | 5058749 | 20240910164101_EubdF | AU002F | 2024-09-14T12:04:26.423Z | 2024-09-16T12:17:57.547Z |
5058548 | 5058548 | 20240910162303_KxwfD | AU002F | 2024-09-14T12:03:55.585Z | 2024-09-16T12:17:55.904Z |
5057905 | 5057905 | 20240910152412_Nk21o | AU002F | 2024-09-14T12:02:22.567Z | 2024-09-16T12:17:48.269Z |
5057409 | 5057409 | 20240910142417_jIq3J | AU002F | 2024-09-14T12:01:00.818Z | 2024-09-16T12:17:43.639Z |
5044217 | 5044217 | 20240908142929_0O5qp | AU002F | 2024-09-13T12:01:41.966Z | 2024-09-16T12:20:20.570Z |
5044100 | 5044100 | 20240908141337_3fC06 | AU002F | 2024-09-13T12:01:27.964Z | 2024-09-16T12:20:19.905Z |
5038315 | 5038315 | 20240905191459_Zn2Pu | AU002F | 2024-09-12T12:14:32.905Z | 2024-09-14T12:22:55.570Z |
5036484 | 5036484 | 20240905133827_Rhmcn | AU002F | 2024-09-12T12:13:43.549Z | 2024-09-14T12:22:52.495Z |
5030318 | 5030318 | 20240906144904_H6oVB | AU002F | 2024-09-12T12:01:42.079Z | 2024-09-15T12:21:18.426Z |
5006633 | 5006633 | 20240903181113_Cm21V | AU002F | 2024-09-09T12:04:50.190Z | 2024-09-12T12:19:09.087Z |
5006541 | 5006541 | 20240903174857_0hQp1 | AU002F | 2024-09-09T12:04:44.874Z | 2024-09-12T12:19:08.565Z |
5005936 | 5005936 | 20240903163237_pNvD3 | AU002F | 2024-09-09T12:04:13.466Z | 2024-09-12T12:19:07.066Z |
5005634 | 5005634 | 20240903154805_OtbA7 | AU002F | 2024-09-09T12:03:52.421Z | 2024-09-12T12:19:06.332Z |
5004863 | 5004863 | 20240903130848_2ZAtN | AU002F | 2024-09-09T12:03:08.544Z | 2024-09-12T12:19:04.383Z |
5004830 | 5004830 | 20240903130029_iwtW7 | AU002F | 2024-09-09T12:03:05.009Z | 2024-09-12T12:19:04.281Z |
4996515 | 4996515 | 20240902195153_56Qsc | AU002F | 2024-09-08T12:04:53.519Z | 2024-09-11T12:20:55.377Z |
4996382 | 4996382 | 20240902193020_DzcDo | AU002F | 2024-09-08T12:04:45.759Z | 2024-09-11T12:20:53.444Z |
4996317 | 4996317 | 20240902191719_2HaZU | AU002F | 2024-09-08T12:04:41.726Z | 2024-09-11T12:20:52.922Z |
4996201 | 4996201 | 20240902185824_SGk6A | AU002F | 2024-09-08T12:04:30.033Z | 2024-09-11T12:20:51.816Z |
4995985 | 4995985 | 20240902182353_8psdn | AU002F | 2024-09-08T12:04:15.803Z | 2024-09-11T12:20:50.068Z |
4995853 | 4995853 | 20240902180034_qoYg3 | AU002F | 2024-09-08T12:04:07.797Z | 2024-09-11T12:20:48.950Z |
4995693 | 4995693 | 20240902173259_EbrWp | AU002F | 2024-09-08T12:03:55.563Z | 2024-09-11T12:20:47.438Z |
4995631 | 4995631 | 20240902172320_uY0ui | AU002F | 2024-09-08T12:03:50.472Z | 2024-09-11T12:20:47.020Z |
4995615 | 4995615 | 20240902172142_RoqEO | AU002F | 2024-09-08T12:03:49.611Z | 2024-09-11T12:20:46.888Z |
4995613 | 4995613 | 20240902172136_ykmgT | AU002F | 2024-09-08T12:03:49.436Z | 2024-09-11T12:20:46.861Z |
4995441 | 4995441 | 20240902165432_VoLzp | AU002F | 2024-09-08T12:03:39.710Z | 2024-09-11T12:20:45.453Z |
4994868 | 4994868 | 20240902152804_vxU4a | AU002F | 2024-09-08T12:03:03.498Z | 2024-09-11T12:20:39.904Z |
4993657 | 4993657 | 20240902110846_JMIPL | AU002F | 2024-09-08T12:01:46.609Z | 2024-09-11T12:20:25.779Z |
4988342 | 4988342 | 20240901203451_naAE7 | AU002F | 2024-09-07T12:07:16.186Z | 2024-09-10T12:19:13.586Z |
4987924 | 4987924 | 20240901192000_480oa | AU002F | 2024-09-07T12:06:28.989Z | 2024-09-10T12:19:11.828Z |
4963483 | 4963483 | 20240811201358_kkZjr | AU002F | 2024-09-04T12:05:36.930Z | 2024-09-06T12:04:41.197Z |
4962454 | 4962454 | 20240811185827_QYex2 | AU002F | 2024-09-04T12:04:31.235Z | 2024-09-06T12:03:46.793Z |
4913228 | 4913228 | 20240809214211_yrsqY | AU002F | 2024-08-29T12:09:02.060Z | 2024-09-02T12:22:46.593Z |
4912197 | 4912197 | 20240809210325_2KOZH | AU002F | 2024-08-29T12:08:16.126Z | 2024-09-02T12:22:16.551Z |
4911720 | 4911720 | 20240809202835_m3Cvp | AU002F | 2024-08-29T12:07:43.526Z | 2024-09-02T12:21:55.509Z |
4911592 | 4911592 | 20240809201844_z1gtD | AU002F | 2024-08-29T12:07:35.443Z | 2024-09-02T12:21:51.348Z |
4911450 | 4911450 | 20240809200704_wnWgh | AU002F | 2024-08-29T12:07:26.971Z | 2024-09-02T12:21:46.384Z |
4911431 | 4911431 | 20240809200511_ucitA | AU002F | 2024-08-29T12:07:24.822Z | 2024-09-02T12:21:43.061Z |
4908955 | 4908955 | 20240809162025_QBUPg | AU002F | 2024-08-29T12:04:38.574Z | 2024-09-02T12:19:34.347Z |
4908807 | 4908807 | 20240809160649_8iXqS | AU002F | 2024-08-29T12:04:27.752Z | 2024-09-02T12:19:27.348Z |
4908435 | 4908435 | 20240809153820_1hAw4 | AU002F | 2024-08-29T12:04:05.503Z | 2024-09-02T12:19:13.440Z |
4908082 | 4908082 | 20240809151526_3mJYL | AU002F | 2024-08-29T12:03:40.539Z | 2024-09-02T12:18:52.801Z |
4907803 | 4907803 | 20240809144924_Mc2l3 | AU002F | 2024-08-29T12:03:24.791Z | 2024-09-02T12:18:41.662Z |
4907089 | 4907089 | 20240809134430_Kg23Q | AU002F | 2024-08-29T12:02:38.838Z | 2024-09-02T12:18:07.831Z |
4905922 | 4905922 | 20240809113551_CzcB3 | AU002F | 2024-08-29T12:01:11.897Z | 2024-09-02T12:17:19.892Z |
4898052 | 4898052 | 20240807204305_1zW2J | AU002F | 2024-08-28T12:16:11.585Z | 2024-08-28T12:16:11.585Z |
4898007 | 4898007 | 20240807203308_m31VC | AU002F | 2024-08-28T12:16:09.551Z | 2024-08-28T12:16:09.551Z |
4897957 | 4897957 | 20240807201642_7R3yS | AU002F | 2024-08-28T12:16:07.406Z | 2024-08-28T12:16:07.406Z |
4897738 | 4897738 | 20240807191912_6QgYo | AU002F | 2024-08-28T12:15:50.128Z | 2024-08-28T12:15:50.128Z |
4897533 | 4897533 | 20240807182146_JzLSZ | AU002F | 2024-08-28T12:15:33.519Z | 2024-08-28T12:15:33.519Z |
4897449 | 4897449 | 20240807180510_SHYuB | AU002F | 2024-08-28T12:15:29.442Z | 2024-08-28T12:15:29.442Z |
4897201 | 4897201 | 20240807172622_zs41E | AU002F | 2024-08-28T12:15:19.247Z | 2024-08-28T12:15:19.247Z |
4896797 | 4896797 | 20240807162213_umlsk | AU002F | 2024-08-28T12:14:46.643Z | 2024-08-28T12:14:46.643Z |
4896721 | 4896721 | 20240807161012_lAwie | AU002F | 2024-08-28T12:14:42.583Z | 2024-08-28T12:14:42.583Z |
4896406 | 4896406 | 20240807150319_ymmsZ | AU002F | 2024-08-28T12:14:16.523Z | 2024-08-28T12:14:16.523Z |
4896365 | 4896365 | 20240807145753_3YU2L | AU002F | 2024-08-28T12:14:14.477Z | 2024-08-28T12:14:14.477Z |
4896304 | 4896304 | 20240807144911_d8R8S | AU002F | 2024-08-28T12:14:09.739Z | 2024-08-28T12:14:09.739Z |
4896159 | 4896159 | 20240807142454_t07zY | AU002F | 2024-08-28T12:14:02.522Z | 2024-08-28T12:14:02.522Z |
4895329 | 4895329 | 20240807120223_yG5Kv | AU002F | 2024-08-28T12:13:17.106Z | 2024-08-28T12:13:17.106Z |
4885942 | 4885942 | 20240808122926_y56za | AU002F | 2024-08-28T12:01:27.136Z | 2024-08-30T12:16:05.332Z |
4871186 | 4871186 | 20240806193332_lcYx5 | AU002F | 2024-08-19T12:08:37.611Z | 2024-08-27T12:09:23.858Z |
4871169 | 4871169 | 20240806192518_YJUle | AU002F | 2024-08-19T12:08:36.672Z | 2024-08-27T12:09:23.005Z |
4871106 | 4871106 | 20240806190916_3fc4x | AU002F | 2024-08-19T12:08:32.922Z | 2024-08-27T12:09:19.595Z |
4867496 | 4867496 | 20240806164727_D8ji0 | AU002F | 2024-08-18T12:08:47.352Z | 2024-08-27T12:07:40.076Z |
4867451 | 4867451 | 20240806164418_sya6p | AU002F | 2024-08-18T12:08:45.604Z | 2024-08-27T12:07:38.169Z |
4866753 | 4866753 | 20240806160447_d9a26 | AU002F | 2024-08-18T12:07:54.193Z | 2024-08-27T12:07:10.153Z |
4866024 | 4866024 | 20240806152621_8TL2U | AU002F | 2024-08-18T12:07:20.678Z | 2024-08-27T12:06:38.728Z |
4850928 | 4850928 | 20240805201312_EU2KQ | AU002F | 2024-08-17T12:13:57.966Z | 2024-08-19T12:23:33.939Z |
4830003 | 4830003 | 20240804210710_oEDbe | AU002F | 2024-08-15T12:09:51.686Z | 2024-08-17T12:29:30.228Z |
4829974 | 4829974 | 20240804210239_CMNgU | AU002F | 2024-08-15T12:09:49.501Z | 2024-08-17T12:29:29.516Z |
4829332 | 4829332 | 20240804193506_sbw3R | AU002F | 2024-08-15T12:08:26.366Z | 2024-08-17T12:28:54.112Z |
4829154 | 4829154 | 20240804190110_i4OW3 | AU002F | 2024-08-15T12:08:12.117Z | 2024-08-17T12:28:41.702Z |
4822986 | 4822986 | 20240803220026_YwAtm | AU002F | 2024-08-14T12:17:43.317Z | 2024-08-15T12:24:42.961Z |
4822699 | 4822699 | 20240803214527_vLZHT | AU002F | 2024-08-14T12:17:23.593Z | 2024-08-15T12:24:33.404Z |
4822395 | 4822395 | 20240803212617_Dze8J | AU002F | 2024-08-14T12:17:11.037Z | 2024-08-15T12:24:23.261Z |
4822379 | 4822379 | 20240803212525_Bl1eP | AU002F | 2024-08-14T12:17:09.914Z | 2024-08-15T12:24:22.639Z |
4822360 | 4822360 | 20240803212427_VG3Z8 | AU002F | 2024-08-14T12:17:08.675Z | 2024-08-15T12:24:21.925Z |
4822295 | 4822295 | 20240803211844_Su724 | AU002F | 2024-08-14T12:16:59.415Z | 2024-08-15T12:24:19.475Z |
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);