participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
448 rows where station_code = "AU004J" 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 |
---|---|---|---|---|---|
5097026 | 5097026 | 20240912135223_TA2R4 | AU004J | 2024-09-16T12:16:42.531Z | 2024-09-16T12:17:32.002Z |
5096941 | 5096941 | 20240912123200_5H4st | AU004J | 2024-09-16T12:16:38.547Z | 2024-09-16T12:17:31.970Z |
5096416 | 5096416 | 20240912104658_JuppE | AU004J | 2024-09-16T12:16:23.076Z | 2024-09-16T12:17:31.761Z |
5095960 | 5095960 | 20240912093405_zc7iO | AU004J | 2024-09-16T12:16:03.400Z | 2024-09-16T12:17:31.656Z |
5084028 | 5084028 | 20240912174022_loRGV | AU004J | 2024-09-16T12:00:57.530Z | 2024-09-16T12:17:04.045Z |
5083683 | 5083683 | 20240911141045_nWV29 | AU004J | 2024-09-15T12:18:45.482Z | 2024-09-16T12:19:20.128Z |
5083498 | 5083498 | 20240911133238_Bb7Xp | AU004J | 2024-09-15T12:18:42.645Z | 2024-09-16T12:19:18.722Z |
5082656 | 5082656 | 20240911104019_UUKDw | AU004J | 2024-09-15T12:18:21.758Z | 2024-09-16T12:19:13.852Z |
5071616 | 5071616 | 20240911172919_wvZkI | AU004J | 2024-09-15T12:03:04.994Z | 2024-09-16T12:17:28.877Z |
5071456 | 5071456 | 20240911165738_2m3XG | AU004J | 2024-09-15T12:02:35.997Z | 2024-09-16T12:17:28.834Z |
5071257 | 5071257 | 20240911162315_CwI9l | AU004J | 2024-09-15T12:02:02.341Z | 2024-09-16T12:17:28.770Z |
5071111 | 5071111 | 20240911160100_c7ikl | AU004J | 2024-09-15T12:01:42.835Z | 2024-09-16T12:17:28.738Z |
5071024 | 5071024 | 20240911154352_keT9X | AU004J | 2024-09-15T12:01:24.611Z | 2024-09-16T12:17:28.714Z |
5070954 | 5070954 | 20240911153459_yMaIr | AU004J | 2024-09-15T12:01:14.015Z | 2024-09-16T12:17:28.699Z |
5070822 | 5070822 | 20240911151324_WcSXH | AU004J | 2024-09-15T12:00:57.313Z | 2024-09-16T12:17:28.671Z |
5070727 | 5070727 | 20240911150135_P4Ey2 | AU004J | 2024-09-15T12:00:42.749Z | 2024-09-16T12:17:28.655Z |
5070678 | 5070678 | 20240911145347_B2KhV | AU004J | 2024-09-15T12:00:33.768Z | 2024-09-16T12:17:28.642Z |
5062975 | 5062975 | 20240909192429_ZDv42 | AU004J | 2024-09-14T12:13:12.192Z | 2024-09-16T12:19:40.686Z |
5051790 | 5051790 | 20240907183751_aB7me | AU004J | 2024-09-13T12:14:33.623Z | 2024-09-16T12:21:01.909Z |
5051603 | 5051603 | 20240907175012_CYMUG | AU004J | 2024-09-13T12:14:24.411Z | 2024-09-16T12:21:01.371Z |
5051217 | 5051217 | 20240907170351_v0w4a | AU004J | 2024-09-13T12:14:06.678Z | 2024-09-16T12:20:59.843Z |
5050539 | 5050539 | 20240907153617_PSmbc | AU004J | 2024-09-13T12:13:36.211Z | 2024-09-16T12:20:57.982Z |
5043685 | 5043685 | 20240908123939_iS5CY | AU004J | 2024-09-13T12:00:24.055Z | 2024-09-16T12:20:18.508Z |
5035546 | 5035546 | 20240907095001_CdXQy | AU004J | 2024-09-12T12:12:12.569Z | 2024-09-15T12:21:39.941Z |
5006360 | 5006360 | 20240903172815_xo1fy | AU004J | 2024-09-09T12:04:32.512Z | 2024-09-12T12:19:08.198Z |
5006098 | 5006098 | 20240903165409_c1ixp | AU004J | 2024-09-09T12:04:20.433Z | 2024-09-12T12:19:07.633Z |
5006030 | 5006030 | 20240903164549_Pl8SD | AU004J | 2024-09-09T12:04:17.373Z | 2024-09-12T12:19:07.243Z |
5005699 | 5005699 | 20240903155904_EbVU5 | AU004J | 2024-09-09T12:03:56.007Z | 2024-09-12T12:19:06.457Z |
5005335 | 5005335 | 20240903145555_hkSlm | AU004J | 2024-09-09T12:03:37.543Z | 2024-09-12T12:19:05.769Z |
5004659 | 5004659 | 20240903120339_bardS | AU004J | 2024-09-09T12:02:53.330Z | 2024-09-12T12:19:03.440Z |
5004101 | 5004101 | 20240903104207_BgEre | AU004J | 2024-09-09T12:02:22.097Z | 2024-09-12T12:19:00.790Z |
5003955 | 5003955 | 20240903101832_bZcAP | AU004J | 2024-09-09T12:02:14.367Z | 2024-09-12T12:19:00.212Z |
4994441 | 4994441 | 20240902140124_qJerV | AU004J | 2024-09-08T12:02:35.346Z | 2024-09-11T12:20:33.885Z |
4994363 | 4994363 | 20240902134446_UymFd | AU004J | 2024-09-08T12:02:31.042Z | 2024-09-11T12:20:33.263Z |
4994296 | 4994296 | 20240902132440_TSEt3 | AU004J | 2024-09-08T12:02:26.422Z | 2024-09-11T12:20:32.463Z |
4993607 | 4993607 | 20240902105744_t00eZ | AU004J | 2024-09-08T12:01:43.741Z | 2024-09-11T12:20:25.220Z |
4993564 | 4993564 | 20240902105434_oJXGy | AU004J | 2024-09-08T12:01:41.288Z | 2024-09-11T12:20:25.012Z |
4993493 | 4993493 | 20240902104436_4O5A5 | AU004J | 2024-09-08T12:01:38.082Z | 2024-09-11T12:20:24.446Z |
4992889 | 4992889 | 20240902091209_VRZZa | AU004J | 2024-09-08T12:00:58.960Z | 2024-09-11T12:20:18.427Z |
4987785 | 4987785 | 20240901185507_BkXLa | AU004J | 2024-09-07T12:06:16.698Z | 2024-09-10T12:19:11.346Z |
4987287 | 4987287 | 20240901170916_WVPvc | AU004J | 2024-09-07T12:05:33.261Z | 2024-09-10T12:19:10.379Z |
4984866 | 4984866 | 20240901110054_4ZI2a | AU004J | 2024-09-07T12:02:32.570Z | 2024-09-10T12:19:06.489Z |
4962535 | 4962535 | 20240811190619_JRxKX | AU004J | 2024-09-04T12:04:37.670Z | 2024-09-06T12:03:50.246Z |
4962015 | 4962015 | 20240811182623_H2v6C | AU004J | 2024-09-04T12:04:11.667Z | 2024-09-06T12:03:24.022Z |
4961925 | 4961925 | 20240811181755_wny6L | AU004J | 2024-09-04T12:04:04.271Z | 2024-09-06T12:03:20.680Z |
4961665 | 4961665 | 20240811175502_8WVlo | AU004J | 2024-09-04T12:03:49.442Z | 2024-09-06T12:03:09.300Z |
4961446 | 4961446 | 20240811174140_ZrOK2 | AU004J | 2024-09-04T12:03:40.101Z | 2024-09-06T12:03:00.882Z |
4960930 | 4960930 | 20240811170336_YfvKD | AU004J | 2024-09-04T12:03:06.433Z | 2024-09-06T12:02:33.727Z |
4959503 | 4959503 | 20240811151135_ZqC81 | AU004J | 2024-09-04T12:01:38.229Z | 2024-09-06T12:01:19.693Z |
4958991 | 4958991 | 20240811113108_ZTw5G | AU004J | 2024-09-03T12:22:46.984Z | 2024-09-06T12:32:32.103Z |
4958634 | 4958634 | 20240811105106_ExFOm | AU004J | 2024-09-03T12:22:31.026Z | 2024-09-06T12:32:15.324Z |
4957887 | 4957887 | 20240811093313_3ndeB | AU004J | 2024-09-03T12:21:51.163Z | 2024-09-06T12:31:42.042Z |
4957595 | 4957595 | 20240811090140_JjCyC | AU004J | 2024-09-03T12:21:31.065Z | 2024-09-06T12:31:28.056Z |
4951424 | 4951424 | 20240811134754_2OzVw | AU004J | 2024-09-03T12:01:01.232Z | 2024-09-06T12:00:43.751Z |
4951313 | 4951313 | 20240811132942_3M4fo | AU004J | 2024-09-03T12:00:50.197Z | 2024-09-06T12:00:37.684Z |
4951120 | 4951120 | 20240811130754_lnJWh | AU004J | 2024-09-03T12:00:29.991Z | 2024-09-06T12:00:24.617Z |
4950978 | 4950978 | 20240811124834_uLpHF | AU004J | 2024-09-03T12:00:15.803Z | 2024-09-06T12:00:14.308Z |
4934702 | 4934702 | 20240810185021_dU9BJ | AU004J | 2024-09-01T12:05:39.979Z | 2024-09-06T12:20:18.418Z |
4933449 | 4933449 | 20240810170352_ao4Oe | AU004J | 2024-09-01T12:04:19.778Z | 2024-09-06T12:19:14.155Z |
4933356 | 4933356 | 20240810165854_3Ot8I | AU004J | 2024-09-01T12:04:15.270Z | 2024-09-06T12:19:08.268Z |
4932717 | 4932717 | 20240810161614_oWX5E | AU004J | 2024-09-01T12:03:37.402Z | 2024-09-06T12:18:46.409Z |
4931358 | 4931358 | 20240810101909_Nx3YG | AU004J | 2024-08-31T12:24:32.201Z | 2024-09-02T12:30:49.580Z |
4925861 | 4925861 | 20240810152625_fQA7s | AU004J | 2024-08-31T12:03:52.621Z | 2024-09-06T12:18:13.652Z |
4925464 | 4925464 | 20240810145910_uGKXT | AU004J | 2024-08-31T12:03:22.996Z | 2024-09-06T12:17:44.795Z |
4925344 | 4925344 | 20240810145131_ejG1R | AU004J | 2024-08-31T12:03:14.009Z | 2024-09-06T12:17:36.684Z |
4925200 | 4925200 | 20240810144324_TWUDx | AU004J | 2024-08-31T12:03:05.713Z | 2024-09-06T12:17:28.168Z |
4923721 | 4923721 | 20240810123353_4E9t9 | AU004J | 2024-08-31T12:01:01.688Z | 2024-09-06T12:16:18.090Z |
4923698 | 4923698 | 20240810123009_1vuFS | AU004J | 2024-08-31T12:00:58.635Z | 2024-09-06T12:16:15.846Z |
4923356 | 4923356 | 20240810114819_S3Y2L | AU004J | 2024-08-31T12:00:20.081Z | 2024-09-06T12:15:44.491Z |
4909360 | 4909360 | 20240809165258_ef1o6 | AU004J | 2024-08-29T12:05:04.090Z | 2024-09-02T12:19:56.047Z |
4909350 | 4909350 | 20240809165220_3U8mU | AU004J | 2024-08-29T12:05:03.395Z | 2024-09-02T12:19:55.500Z |
4908773 | 4908773 | 20240809160245_fZOlD | AU004J | 2024-08-29T12:04:25.603Z | 2024-09-02T12:19:26.169Z |
4907982 | 4907982 | 20240809150836_WjZgI | AU004J | 2024-08-29T12:03:35.795Z | 2024-09-02T12:18:49.948Z |
4907627 | 4907627 | 20240809143627_4G30D | AU004J | 2024-08-29T12:03:13.984Z | 2024-09-02T12:18:36.186Z |
4907620 | 4907620 | 20240809143527_OSDn0 | AU004J | 2024-08-29T12:03:13.328Z | 2024-09-02T12:18:35.905Z |
4907452 | 4907452 | 20240809142113_RsaKN | AU004J | 2024-08-29T12:03:03.239Z | 2024-09-02T12:18:30.206Z |
4907166 | 4907166 | 20240809135146_Xm4SF | AU004J | 2024-08-29T12:02:44.007Z | 2024-09-02T12:18:10.676Z |
4907009 | 4907009 | 20240809133817_2SiX6 | AU004J | 2024-08-29T12:02:33.902Z | 2024-09-02T12:18:05.591Z |
4906394 | 4906394 | 20240809123607_y672k | AU004J | 2024-08-29T12:01:49.826Z | 2024-09-02T12:17:35.602Z |
4895383 | 4895383 | 20240807121645_7DI2b | AU004J | 2024-08-28T12:13:19.917Z | 2024-08-28T12:13:19.917Z |
4895372 | 4895372 | 20240807121554_wEQlW | AU004J | 2024-08-28T12:13:19.371Z | 2024-08-28T12:13:19.371Z |
4895366 | 4895366 | 20240807121425_fH666 | AU004J | 2024-08-28T12:13:19.005Z | 2024-08-28T12:13:19.005Z |
4895357 | 4895357 | 20240807120949_10S4c | AU004J | 2024-08-28T12:13:18.456Z | 2024-08-28T12:13:18.456Z |
4895264 | 4895264 | 20240807114651_9n8r1 | AU004J | 2024-08-28T12:13:14.233Z | 2024-08-28T12:13:14.233Z |
4895072 | 4895072 | 20240807111718_vTUSz | AU004J | 2024-08-28T12:12:58.361Z | 2024-08-28T12:12:58.361Z |
4894876 | 4894876 | 20240807105112_6SOVm | AU004J | 2024-08-28T12:12:47.559Z | 2024-08-28T12:12:47.559Z |
4894197 | 4894197 | 20240807093247_1yUPM | AU004J | 2024-08-28T12:12:10.682Z | 2024-08-28T12:12:10.682Z |
4893755 | 4893755 | 20240807084606_HHdJa | AU004J | 2024-08-28T12:11:43.509Z | 2024-08-28T12:11:43.509Z |
4893624 | 4893624 | 20240809101724_kq67T | AU004J | 2024-08-28T12:11:35.660Z | 2024-08-30T12:23:04.249Z |
4893245 | 4893245 | 20240809090525_ZozPe | AU004J | 2024-08-28T12:11:09.961Z | 2024-08-30T12:22:50.910Z |
4871291 | 4871291 | 20240806195559_p9deU | AU004J | 2024-08-19T12:08:44.512Z | 2024-08-27T12:09:30.036Z |
4871070 | 4871070 | 20240806185933_KOL2h | AU004J | 2024-08-19T12:08:30.315Z | 2024-08-27T12:09:17.370Z |
4871037 | 4871037 | 20240806185154_uhzoZ | AU004J | 2024-08-19T12:08:28.670Z | 2024-08-27T12:09:15.589Z |
4869361 | 4869361 | 20240806171346_G3sBE | AU004J | 2024-08-19T12:07:05.822Z | 2024-08-27T12:08:06.222Z |
4866883 | 4866883 | 20240806161052_59Nqz | AU004J | 2024-08-18T12:08:04.164Z | 2024-08-27T12:07:18.056Z |
4866115 | 4866115 | 20240806153023_Tb8aM | AU004J | 2024-08-18T12:07:23.549Z | 2024-08-27T12:06:43.315Z |
4865267 | 4865267 | 20240806145302_jWxiz | AU004J | 2024-08-18T12:06:40.571Z | 2024-08-27T12:06:09.741Z |
4865116 | 4865116 | 20240806144751_21Fj3 | AU004J | 2024-08-18T12:06:30.973Z | 2024-08-27T12:06:02.729Z |
4864537 | 4864537 | 20240806142122_ms5Yv | AU004J | 2024-08-18T12:06:08.939Z | 2024-08-27T12:05:41.652Z |
4863718 | 4863718 | 20240806133937_A3Z0c | AU004J | 2024-08-18T12:05:22.285Z | 2024-08-27T12:05:07.311Z |
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);