participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
919 rows where station_code = "AU0048" 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 |
---|---|---|---|---|---|
5097025 | 5097025 | 20240912135223_TA2R4 | AU0048 | 2024-09-16T12:16:42.531Z | 2024-09-16T12:17:32.002Z |
5096940 | 5096940 | 20240912123200_5H4st | AU0048 | 2024-09-16T12:16:38.547Z | 2024-09-16T12:17:31.970Z |
5096415 | 5096415 | 20240912104658_JuppE | AU0048 | 2024-09-16T12:16:23.076Z | 2024-09-16T12:17:31.761Z |
5095959 | 5095959 | 20240912093405_zc7iO | AU0048 | 2024-09-16T12:16:03.400Z | 2024-09-16T12:17:31.656Z |
5084027 | 5084027 | 20240912174022_loRGV | AU0048 | 2024-09-16T12:00:57.530Z | 2024-09-16T12:17:04.045Z |
5083993 | 5083993 | 20240912172128_EgERu | AU0048 | 2024-09-16T12:00:51.467Z | 2024-09-16T12:17:04.021Z |
5083682 | 5083682 | 20240911141045_nWV29 | AU0048 | 2024-09-15T12:18:45.482Z | 2024-09-16T12:19:20.128Z |
5083497 | 5083497 | 20240911133238_Bb7Xp | AU0048 | 2024-09-15T12:18:42.645Z | 2024-09-16T12:19:18.722Z |
5082655 | 5082655 | 20240911104019_UUKDw | AU0048 | 2024-09-15T12:18:21.758Z | 2024-09-16T12:19:13.852Z |
5071989 | 5071989 | 20240911191727_U7Vws | AU0048 | 2024-09-15T12:04:14.290Z | 2024-09-16T12:17:28.997Z |
5071615 | 5071615 | 20240911172919_wvZkI | AU0048 | 2024-09-15T12:03:04.994Z | 2024-09-16T12:17:28.877Z |
5071455 | 5071455 | 20240911165738_2m3XG | AU0048 | 2024-09-15T12:02:35.997Z | 2024-09-16T12:17:28.834Z |
5071256 | 5071256 | 20240911162315_CwI9l | AU0048 | 2024-09-15T12:02:02.341Z | 2024-09-16T12:17:28.770Z |
5071110 | 5071110 | 20240911160100_c7ikl | AU0048 | 2024-09-15T12:01:42.835Z | 2024-09-16T12:17:28.738Z |
5071023 | 5071023 | 20240911154352_keT9X | AU0048 | 2024-09-15T12:01:24.611Z | 2024-09-16T12:17:28.714Z |
5070953 | 5070953 | 20240911153459_yMaIr | AU0048 | 2024-09-15T12:01:14.015Z | 2024-09-16T12:17:28.699Z |
5070821 | 5070821 | 20240911151324_WcSXH | AU0048 | 2024-09-15T12:00:57.313Z | 2024-09-16T12:17:28.671Z |
5070726 | 5070726 | 20240911150135_P4Ey2 | AU0048 | 2024-09-15T12:00:42.749Z | 2024-09-16T12:17:28.655Z |
5070677 | 5070677 | 20240911145347_B2KhV | AU0048 | 2024-09-15T12:00:33.753Z | 2024-09-16T12:17:28.642Z |
5062974 | 5062974 | 20240909192429_ZDv42 | AU0048 | 2024-09-14T12:13:12.192Z | 2024-09-16T12:19:40.686Z |
5062909 | 5062909 | 20240909185928_H8ew7 | AU0048 | 2024-09-14T12:13:02.229Z | 2024-09-16T12:19:40.220Z |
5059599 | 5059599 | 20240910181602_FuM6A | AU0048 | 2024-09-14T12:06:33.864Z | 2024-09-16T12:18:06.443Z |
5058097 | 5058097 | 20240910154343_I2UXH | AU0048 | 2024-09-14T12:02:55.171Z | 2024-09-16T12:17:50.099Z |
5051789 | 5051789 | 20240907183751_aB7me | AU0048 | 2024-09-13T12:14:33.623Z | 2024-09-16T12:21:01.909Z |
5051616 | 5051616 | 20240907175226_MAEBM | AU0048 | 2024-09-13T12:14:24.681Z | 2024-09-16T12:21:01.391Z |
5051602 | 5051602 | 20240907175012_CYMUG | AU0048 | 2024-09-13T12:14:24.411Z | 2024-09-16T12:21:01.371Z |
5051216 | 5051216 | 20240907170351_v0w4a | AU0048 | 2024-09-13T12:14:06.678Z | 2024-09-16T12:20:59.843Z |
5050845 | 5050845 | 20240907161456_rhDVy | AU0048 | 2024-09-13T12:13:48.555Z | 2024-09-16T12:20:58.773Z |
5050538 | 5050538 | 20240907153617_PSmbc | AU0048 | 2024-09-13T12:13:36.211Z | 2024-09-16T12:20:57.982Z |
5045739 | 5045739 | 20240908184440_kfO60 | AU0048 | 2024-09-13T12:04:49.975Z | 2024-09-16T12:20:27.217Z |
5043684 | 5043684 | 20240908123939_iS5CY | AU0048 | 2024-09-13T12:00:24.055Z | 2024-09-16T12:20:18.508Z |
5035545 | 5035545 | 20240907095001_CdXQy | AU0048 | 2024-09-12T12:12:12.569Z | 2024-09-15T12:21:39.941Z |
5030859 | 5030859 | 20240906191051_jvkxe | AU0048 | 2024-09-12T12:03:15.670Z | 2024-09-15T12:21:20.172Z |
5030751 | 5030751 | 20240906181907_Gtj8D | AU0048 | 2024-09-12T12:02:54.822Z | 2024-09-15T12:21:19.548Z |
5030607 | 5030607 | 20240906170951_68T25 | AU0048 | 2024-09-12T12:02:27.698Z | 2024-09-15T12:21:19.244Z |
5030256 | 5030256 | 20240906140819_vBd3w | AU0048 | 2024-09-12T12:01:34.569Z | 2024-09-15T12:21:18.356Z |
5030197 | 5030197 | 20240906133910_axLB8 | AU0048 | 2024-09-12T12:01:24.474Z | 2024-09-15T12:21:18.220Z |
5030129 | 5030129 | 20240906130335_oGd0g | AU0048 | 2024-09-12T12:01:13.190Z | 2024-09-15T12:21:18.137Z |
5023116 | 5023116 | 20240905152621_zavEe | AU0048 | 2024-09-10T12:16:39.196Z | 2024-09-11T12:16:31.537Z |
5018065 | 5018065 | 20240904170826_KCIv2 | AU0048 | 2024-09-10T12:09:57.007Z | 2024-09-13T12:19:47.180Z |
5006901 | 5006901 | 20240903192533_AQSMw | AU0048 | 2024-09-09T12:05:11.922Z | 2024-09-12T12:19:10.829Z |
5006795 | 5006795 | 20240903185917_yOaAd | AU0048 | 2024-09-09T12:05:04.964Z | 2024-09-12T12:19:09.532Z |
5006618 | 5006618 | 20240903180814_BUbgx | AU0048 | 2024-09-09T12:04:49.316Z | 2024-09-12T12:19:09.056Z |
5006359 | 5006359 | 20240903172815_xo1fy | AU0048 | 2024-09-09T12:04:32.512Z | 2024-09-12T12:19:08.198Z |
5006097 | 5006097 | 20240903165409_c1ixp | AU0048 | 2024-09-09T12:04:20.433Z | 2024-09-12T12:19:07.633Z |
5006061 | 5006061 | 20240903165000_T9Ofm | AU0048 | 2024-09-09T12:04:18.592Z | 2024-09-12T12:19:07.570Z |
5006029 | 5006029 | 20240903164549_Pl8SD | AU0048 | 2024-09-09T12:04:17.373Z | 2024-09-12T12:19:07.243Z |
5005879 | 5005879 | 20240903162636_woitI | AU0048 | 2024-09-09T12:04:10.826Z | 2024-09-12T12:19:06.991Z |
5005698 | 5005698 | 20240903155904_EbVU5 | AU0048 | 2024-09-09T12:03:56.007Z | 2024-09-12T12:19:06.457Z |
5005462 | 5005462 | 20240903151703_p05Fq | AU0048 | 2024-09-09T12:03:43.830Z | 2024-09-12T12:19:05.970Z |
5005334 | 5005334 | 20240903145555_hkSlm | AU0048 | 2024-09-09T12:03:37.543Z | 2024-09-12T12:19:05.769Z |
5005277 | 5005277 | 20240903144558_6DPeH | AU0048 | 2024-09-09T12:03:33.171Z | 2024-09-12T12:19:05.622Z |
5004990 | 5004990 | 20240903134229_mw6mJ | AU0048 | 2024-09-09T12:03:15.037Z | 2024-09-12T12:19:04.701Z |
5004658 | 5004658 | 20240903120339_bardS | AU0048 | 2024-09-09T12:02:53.330Z | 2024-09-12T12:19:03.440Z |
5004100 | 5004100 | 20240903104207_BgEre | AU0048 | 2024-09-09T12:02:22.097Z | 2024-09-12T12:19:00.790Z |
5003954 | 5003954 | 20240903101832_bZcAP | AU0048 | 2024-09-09T12:02:14.361Z | 2024-09-12T12:19:00.212Z |
4995580 | 4995580 | 20240902171859_6Lddg | AU0048 | 2024-09-08T12:03:47.483Z | 2024-09-11T12:20:46.580Z |
4995512 | 4995512 | 20240902171113_Xoi0h | AU0048 | 2024-09-08T12:03:43.658Z | 2024-09-11T12:20:45.978Z |
4994440 | 4994440 | 20240902140124_qJerV | AU0048 | 2024-09-08T12:02:35.346Z | 2024-09-11T12:20:33.885Z |
4994400 | 4994400 | 20240902135136_wJDN5 | AU0048 | 2024-09-08T12:02:32.886Z | 2024-09-11T12:20:33.532Z |
4994362 | 4994362 | 20240902134446_UymFd | AU0048 | 2024-09-08T12:02:31.042Z | 2024-09-11T12:20:33.263Z |
4994295 | 4994295 | 20240902132440_TSEt3 | AU0048 | 2024-09-08T12:02:26.421Z | 2024-09-11T12:20:32.463Z |
4993606 | 4993606 | 20240902105744_t00eZ | AU0048 | 2024-09-08T12:01:43.741Z | 2024-09-11T12:20:25.220Z |
4993563 | 4993563 | 20240902105434_oJXGy | AU0048 | 2024-09-08T12:01:41.288Z | 2024-09-11T12:20:25.012Z |
4993492 | 4993492 | 20240902104436_4O5A5 | AU0048 | 2024-09-08T12:01:38.076Z | 2024-09-11T12:20:24.446Z |
4993211 | 4993211 | 20240902100213_JkpNT | AU0048 | 2024-09-08T12:01:17.637Z | 2024-09-11T12:20:21.026Z |
4992888 | 4992888 | 20240902091209_VRZZa | AU0048 | 2024-09-08T12:00:58.958Z | 2024-09-11T12:20:18.427Z |
4987784 | 4987784 | 20240901185507_BkXLa | AU0048 | 2024-09-07T12:06:16.698Z | 2024-09-10T12:19:11.346Z |
4987706 | 4987706 | 20240901183509_pClNd | AU0048 | 2024-09-07T12:06:08.490Z | 2024-09-10T12:19:11.191Z |
4987286 | 4987286 | 20240901170916_WVPvc | AU0048 | 2024-09-07T12:05:33.259Z | 2024-09-10T12:19:10.379Z |
4985347 | 4985347 | 20240901120412_wAgVF | AU0048 | 2024-09-07T12:03:10.334Z | 2024-09-10T12:19:07.625Z |
4984865 | 4984865 | 20240901110054_4ZI2a | AU0048 | 2024-09-07T12:02:32.561Z | 2024-09-10T12:19:06.489Z |
4963123 | 4963123 | 20240811194530_ni3io | AU0048 | 2024-09-04T12:05:12.747Z | 2024-09-06T12:04:19.173Z |
4962804 | 4962804 | 20240811192421_DhIGK | AU0048 | 2024-09-04T12:04:53.391Z | 2024-09-06T12:04:04.134Z |
4962574 | 4962574 | 20240811190953_rgQL7 | AU0048 | 2024-09-04T12:04:39.496Z | 2024-09-06T12:03:51.827Z |
4962534 | 4962534 | 20240811190619_JRxKX | AU0048 | 2024-09-04T12:04:37.670Z | 2024-09-06T12:03:50.246Z |
4962014 | 4962014 | 20240811182623_H2v6C | AU0048 | 2024-09-04T12:04:11.667Z | 2024-09-06T12:03:24.022Z |
4961924 | 4961924 | 20240811181755_wny6L | AU0048 | 2024-09-04T12:04:04.271Z | 2024-09-06T12:03:20.680Z |
4961859 | 4961859 | 20240811181053_73WXi | AU0048 | 2024-09-04T12:03:59.044Z | 2024-09-06T12:03:17.610Z |
4961664 | 4961664 | 20240811175502_8WVlo | AU0048 | 2024-09-04T12:03:49.442Z | 2024-09-06T12:03:09.300Z |
4961445 | 4961445 | 20240811174140_ZrOK2 | AU0048 | 2024-09-04T12:03:40.101Z | 2024-09-06T12:03:00.882Z |
4960929 | 4960929 | 20240811170336_YfvKD | AU0048 | 2024-09-04T12:03:06.433Z | 2024-09-06T12:02:33.727Z |
4960824 | 4960824 | 20240811165134_RfsP1 | AU0048 | 2024-09-04T12:02:57.218Z | 2024-09-06T12:02:28.158Z |
4960602 | 4960602 | 20240811163653_Usmjr | AU0048 | 2024-09-04T12:02:45.236Z | 2024-09-06T12:02:17.493Z |
4959502 | 4959502 | 20240811151135_ZqC81 | AU0048 | 2024-09-04T12:01:38.229Z | 2024-09-06T12:01:19.693Z |
4958990 | 4958990 | 20240811113108_ZTw5G | AU0048 | 2024-09-03T12:22:46.984Z | 2024-09-06T12:32:32.103Z |
4958633 | 4958633 | 20240811105106_ExFOm | AU0048 | 2024-09-03T12:22:31.026Z | 2024-09-06T12:32:15.324Z |
4957886 | 4957886 | 20240811093313_3ndeB | AU0048 | 2024-09-03T12:21:51.163Z | 2024-09-06T12:31:42.042Z |
4957594 | 4957594 | 20240811090140_JjCyC | AU0048 | 2024-09-03T12:21:31.065Z | 2024-09-06T12:31:28.056Z |
4951953 | 4951953 | 20240811144845_sPwyK | AU0048 | 2024-09-03T12:01:39.215Z | 2024-09-06T12:01:08.233Z |
4951456 | 4951456 | 20240811134942_BqITx | AU0048 | 2024-09-03T12:01:02.908Z | 2024-09-06T12:00:44.736Z |
4951423 | 4951423 | 20240811134754_2OzVw | AU0048 | 2024-09-03T12:01:01.223Z | 2024-09-06T12:00:43.751Z |
4951312 | 4951312 | 20240811132942_3M4fo | AU0048 | 2024-09-03T12:00:50.197Z | 2024-09-06T12:00:37.684Z |
4951119 | 4951119 | 20240811130754_lnJWh | AU0048 | 2024-09-03T12:00:29.991Z | 2024-09-06T12:00:24.617Z |
4950977 | 4950977 | 20240811124834_uLpHF | AU0048 | 2024-09-03T12:00:15.798Z | 2024-09-06T12:00:14.308Z |
4935167 | 4935167 | 20240810194634_k0893 | AU0048 | 2024-09-01T12:06:09.896Z | 2024-09-06T12:20:29.358Z |
4934733 | 4934733 | 20240810185321_E7Yxg | AU0048 | 2024-09-01T12:05:44.360Z | 2024-09-06T12:20:19.382Z |
4934701 | 4934701 | 20240810185021_dU9BJ | AU0048 | 2024-09-01T12:05:39.979Z | 2024-09-06T12:20:18.418Z |
4933923 | 4933923 | 20240810173346_aG5Ui | AU0048 | 2024-09-01T12:04:46.439Z | 2024-09-06T12:19:42.229Z |
4933448 | 4933448 | 20240810170352_ao4Oe | AU0048 | 2024-09-01T12:04:19.778Z | 2024-09-06T12:19:14.155Z |
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);