participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,205 rows where station_code = "AU002A" 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 |
---|---|---|---|---|---|
5097105 | 5097105 | 20240912143753_2pU7R | AU002A | 2024-09-16T12:16:45.140Z | 2024-09-16T12:17:32.033Z |
5097042 | 5097042 | 20240912140133_43LZg | AU002A | 2024-09-16T12:16:43.242Z | 2024-09-16T12:17:32.011Z |
5097002 | 5097002 | 20240912132753_rttOO | AU002A | 2024-09-16T12:16:41.965Z | 2024-09-16T12:17:31.993Z |
5096974 | 5096974 | 20240912131510_nevom | AU002A | 2024-09-16T12:16:41.045Z | 2024-09-16T12:17:31.985Z |
5096956 | 5096956 | 20240912125229_6O714 | AU002A | 2024-09-16T12:16:40.308Z | 2024-09-16T12:17:31.977Z |
5096936 | 5096936 | 20240912123115_Ds5uB | AU002A | 2024-09-16T12:16:38.465Z | 2024-09-16T12:17:31.969Z |
5096587 | 5096587 | 20240912111805_qhxpR | AU002A | 2024-09-16T12:16:28.117Z | 2024-09-16T12:17:31.803Z |
5085239 | 5085239 | 20240912210216_GyniH | AU002A | 2024-09-16T12:03:46.535Z | 2024-09-16T12:17:04.660Z |
5085191 | 5085191 | 20240912205626_wbg3j | AU002A | 2024-09-16T12:03:40.887Z | 2024-09-16T12:17:04.637Z |
5084421 | 5084421 | 20240912193712_1Xx3V | AU002A | 2024-09-16T12:02:03.650Z | 2024-09-16T12:17:04.299Z |
5083989 | 5083989 | 20240912172032_afNPg | AU002A | 2024-09-16T12:00:48.763Z | 2024-09-16T12:17:04.017Z |
5083911 | 5083911 | 20240912164102_mkZ1Z | AU002A | 2024-09-16T12:00:38.006Z | 2024-09-16T12:17:03.972Z |
5083868 | 5083868 | 20240912162651_vR6Au | AU002A | 2024-09-16T12:00:33.702Z | 2024-09-16T12:17:03.955Z |
5083865 | 5083865 | 20240912162607_vWQ32 | AU002A | 2024-09-16T12:00:32.943Z | 2024-09-16T12:17:03.952Z |
5083860 | 5083860 | 20240912162035_Ev8sw | AU002A | 2024-09-16T12:00:32.585Z | 2024-09-16T12:17:03.952Z |
5083832 | 5083832 | 20240912160654_Hbd2W | AU002A | 2024-09-16T12:00:28.692Z | 2024-09-16T12:17:03.933Z |
5083737 | 5083737 | 20240911141456_QrJde | AU002A | 2024-09-15T12:18:45.863Z | 2024-09-16T12:19:20.411Z |
5083187 | 5083187 | 20240911122107_QEC3O | AU002A | 2024-09-15T12:18:36.639Z | 2024-09-16T12:19:17.163Z |
5083155 | 5083155 | 20240911121526_czfOD | AU002A | 2024-09-15T12:18:36.235Z | 2024-09-16T12:19:16.943Z |
5083111 | 5083111 | 20240911120545_IXKFN | AU002A | 2024-09-15T12:18:35.848Z | 2024-09-16T12:19:16.682Z |
5082908 | 5082908 | 20240911112510_a94IB | AU002A | 2024-09-15T12:18:29.586Z | 2024-09-16T12:19:15.686Z |
5073518 | 5073518 | 20240911212849_qYwuo | AU002A | 2024-09-15T12:07:14.924Z | 2024-09-16T12:17:29.255Z |
5072982 | 5072982 | 20240911205059_bikva | AU002A | 2024-09-15T12:06:23.266Z | 2024-09-16T12:17:29.179Z |
5072679 | 5072679 | 20240911203625_NhaV8 | AU002A | 2024-09-15T12:06:00.596Z | 2024-09-16T12:17:29.134Z |
5072597 | 5072597 | 20240911202750_8pmLm | AU002A | 2024-09-15T12:05:43.066Z | 2024-09-16T12:17:29.116Z |
5072562 | 5072562 | 20240911202339_SHxg3 | AU002A | 2024-09-15T12:05:38.103Z | 2024-09-16T12:17:29.110Z |
5072353 | 5072353 | 20240911195756_gNSXj | AU002A | 2024-09-15T12:05:13.651Z | 2024-09-16T12:17:29.066Z |
5072306 | 5072306 | 20240911195500_HFPEm | AU002A | 2024-09-15T12:05:07.391Z | 2024-09-16T12:17:29.060Z |
5072249 | 5072249 | 20240911195117_sFyro | AU002A | 2024-09-15T12:04:58.791Z | 2024-09-16T12:17:29.053Z |
5072137 | 5072137 | 20240911194048_rniJn | AU002A | 2024-09-15T12:04:44.817Z | 2024-09-16T12:17:29.033Z |
5072074 | 5072074 | 20240911192934_6EsOe | AU002A | 2024-09-15T12:04:36.164Z | 2024-09-16T12:17:29.019Z |
5072055 | 5072055 | 20240911192708_yWXM9 | AU002A | 2024-09-15T12:04:33.163Z | 2024-09-16T12:17:29.013Z |
5072044 | 5072044 | 20240911192635_SDqkh | AU002A | 2024-09-15T12:04:31.809Z | 2024-09-16T12:17:29.011Z |
5071991 | 5071991 | 20240911191737_Adgmx | AU002A | 2024-09-15T12:04:14.939Z | 2024-09-16T12:17:28.998Z |
5071883 | 5071883 | 20240911184718_Hb2sH | AU002A | 2024-09-15T12:03:55.243Z | 2024-09-16T12:17:28.967Z |
5071819 | 5071819 | 20240911182809_vi4Ut | AU002A | 2024-09-15T12:03:46.518Z | 2024-09-16T12:17:28.950Z |
5071801 | 5071801 | 20240911182338_nZwxl | AU002A | 2024-09-15T12:03:38.759Z | 2024-09-16T12:17:28.945Z |
5071784 | 5071784 | 20240911181906_03u0y | AU002A | 2024-09-15T12:03:32.554Z | 2024-09-16T12:17:28.940Z |
5071628 | 5071628 | 20240911173112_Uaozf | AU002A | 2024-09-15T12:03:06.643Z | 2024-09-16T12:17:28.880Z |
5071558 | 5071558 | 20240911171559_sXbbN | AU002A | 2024-09-15T12:02:56.060Z | 2024-09-16T12:17:28.862Z |
5071362 | 5071362 | 20240911163919_ekajK | AU002A | 2024-09-15T12:02:22.416Z | 2024-09-16T12:17:28.792Z |
5071235 | 5071235 | 20240911161940_jjVOu | AU002A | 2024-09-15T12:01:59.282Z | 2024-09-16T12:17:28.765Z |
5071062 | 5071062 | 20240911155337_lWQIK | AU002A | 2024-09-15T12:01:34.621Z | 2024-09-16T12:17:28.723Z |
5071038 | 5071038 | 20240911154824_qRyTW | AU002A | 2024-09-15T12:01:28.094Z | 2024-09-16T12:17:28.717Z |
5070967 | 5070967 | 20240911153611_6HzsZ | AU002A | 2024-09-15T12:01:15.565Z | 2024-09-16T12:17:28.702Z |
5070776 | 5070776 | 20240911151032_R1EtO | AU002A | 2024-09-15T12:00:47.672Z | 2024-09-16T12:17:28.663Z |
5070713 | 5070713 | 20240911145737_AHcax | AU002A | 2024-09-15T12:00:39.939Z | 2024-09-16T12:17:28.651Z |
5070693 | 5070693 | 20240911145536_ozVcF | AU002A | 2024-09-15T12:00:36.141Z | 2024-09-16T12:17:28.646Z |
5070662 | 5070662 | 20240911144609_lftT5 | AU002A | 2024-09-15T12:00:28.770Z | 2024-09-16T12:17:28.637Z |
5070539 | 5070539 | 20240911143011_FQeL7 | AU002A | 2024-09-15T12:00:16.592Z | 2024-09-16T12:17:28.614Z |
5063208 | 5063208 | 20240909201742_R8CL4 | AU002A | 2024-09-14T12:13:41.872Z | 2024-09-16T12:19:42.674Z |
5063173 | 5063173 | 20240909201003_NWGqf | AU002A | 2024-09-14T12:13:37.132Z | 2024-09-16T12:19:42.456Z |
5060837 | 5060837 | 20240910212859_xgMbJ | AU002A | 2024-09-14T12:09:43.558Z | 2024-09-16T12:18:21.420Z |
5060815 | 5060815 | 20240910211416_aq2us | AU002A | 2024-09-14T12:09:35.858Z | 2024-09-16T12:18:19.649Z |
5060813 | 5060813 | 20240910211321_zsSCC | AU002A | 2024-09-14T12:09:35.610Z | 2024-09-16T12:18:19.496Z |
5060542 | 5060542 | 20240910203722_ZLHA4 | AU002A | 2024-09-14T12:09:06.386Z | 2024-09-16T12:18:16.354Z |
5060406 | 5060406 | 20240910202720_Katw8 | AU002A | 2024-09-14T12:08:45.850Z | 2024-09-16T12:18:15.412Z |
5060398 | 5060398 | 20240910202716_SHsg6 | AU002A | 2024-09-14T12:08:44.646Z | 2024-09-16T12:18:15.226Z |
5060183 | 5060183 | 20240910200335_QTEcx | AU002A | 2024-09-14T12:08:27.267Z | 2024-09-16T12:18:13.799Z |
5060169 | 5060169 | 20240910200042_Jn8AP | AU002A | 2024-09-14T12:08:25.893Z | 2024-09-16T12:18:13.773Z |
5060076 | 5060076 | 20240910194714_0jecS | AU002A | 2024-09-14T12:08:09.603Z | 2024-09-16T12:18:12.678Z |
5059934 | 5059934 | 20240910192016_2bwrn | AU002A | 2024-09-14T12:07:44.629Z | 2024-09-16T12:18:10.213Z |
5059928 | 5059928 | 20240910192012_Sb1uz | AU002A | 2024-09-14T12:07:42.053Z | 2024-09-16T12:18:10.208Z |
5059804 | 5059804 | 20240910185719_x5yfc | AU002A | 2024-09-14T12:07:16.094Z | 2024-09-16T12:18:08.689Z |
5059781 | 5059781 | 20240910185240_xSrLM | AU002A | 2024-09-14T12:07:11.163Z | 2024-09-16T12:18:08.353Z |
5059779 | 5059779 | 20240910185208_cE24o | AU002A | 2024-09-14T12:07:10.953Z | 2024-09-16T12:18:08.351Z |
5059737 | 5059737 | 20240910183923_zE1G1 | AU002A | 2024-09-14T12:06:56.623Z | 2024-09-16T12:18:07.990Z |
5059726 | 5059726 | 20240910183806_XBR0O | AU002A | 2024-09-14T12:06:53.865Z | 2024-09-16T12:18:07.906Z |
5059690 | 5059690 | 20240910183304_Dywhr | AU002A | 2024-09-14T12:06:46.545Z | 2024-09-16T12:18:07.666Z |
5059659 | 5059659 | 20240910182618_P2zmG | AU002A | 2024-09-14T12:06:41.582Z | 2024-09-16T12:18:06.983Z |
5059648 | 5059648 | 20240910182309_cXGq2 | AU002A | 2024-09-14T12:06:39.585Z | 2024-09-16T12:18:06.743Z |
5059628 | 5059628 | 20240910182058_kHQNV | AU002A | 2024-09-14T12:06:37.745Z | 2024-09-16T12:18:06.630Z |
5059564 | 5059564 | 20240910180820_N5Fcd | AU002A | 2024-09-14T12:06:27.795Z | 2024-09-16T12:18:06.080Z |
5059141 | 5059141 | 20240910171618_uGR5G | AU002A | 2024-09-14T12:05:18.575Z | 2024-09-16T12:18:02.185Z |
5059052 | 5059052 | 20240910170910_n282z | AU002A | 2024-09-14T12:05:09.185Z | 2024-09-16T12:18:01.302Z |
5058956 | 5058956 | 20240910170324_ndM9C | AU002A | 2024-09-14T12:05:00.326Z | 2024-09-16T12:18:00.082Z |
5058767 | 5058767 | 20240910164302_uzMOD | AU002A | 2024-09-14T12:04:28.551Z | 2024-09-16T12:17:57.684Z |
5058568 | 5058568 | 20240910162751_c03Cs | AU002A | 2024-09-14T12:04:01.403Z | 2024-09-16T12:17:56.081Z |
5058384 | 5058384 | 20240910160831_TxXde | AU002A | 2024-09-14T12:03:38.355Z | 2024-09-16T12:17:53.801Z |
5058111 | 5058111 | 20240910154537_2L90y | AU002A | 2024-09-14T12:02:58.277Z | 2024-09-16T12:17:50.192Z |
5057044 | 5057044 | 20240908120024_nvsX4 | AU002A | 2024-09-13T12:17:44.168Z | 2024-09-16T12:21:28.556Z |
5056745 | 5056745 | 20240908111806_VAZPV | AU002A | 2024-09-13T12:17:38.869Z | 2024-09-16T12:21:27.090Z |
5052410 | 5052410 | 20240907203434_K1Vl0 | AU002A | 2024-09-13T12:15:08.076Z | 2024-09-16T12:21:05.459Z |
5052311 | 5052311 | 20240907201520_NPls2 | AU002A | 2024-09-13T12:15:03.735Z | 2024-09-16T12:21:05.100Z |
5052272 | 5052272 | 20240907200746_13ZUy | AU002A | 2024-09-13T12:15:02.362Z | 2024-09-16T12:21:04.846Z |
5050120 | 5050120 | 20240909125044_6Uy0C | AU002A | 2024-09-13T12:12:41.356Z | 2024-09-16T12:20:45.541Z |
5050063 | 5050063 | 20240909123823_6k7HP | AU002A | 2024-09-13T12:12:38.424Z | 2024-09-16T12:20:45.309Z |
5049969 | 5049969 | 20240909120902_okvCD | AU002A | 2024-09-13T12:12:34.123Z | 2024-09-16T12:20:44.964Z |
5049932 | 5049932 | 20240909115951_ff5BN | AU002A | 2024-09-13T12:12:32.447Z | 2024-09-16T12:20:44.847Z |
5049774 | 5049774 | 20240909113828_Whsni | AU002A | 2024-09-13T12:12:25.796Z | 2024-09-16T12:20:44.136Z |
5044216 | 5044216 | 20240908142929_0O5qp | AU002A | 2024-09-13T12:01:41.966Z | 2024-09-16T12:20:20.570Z |
5044080 | 5044080 | 20240908141125_35nhF | AU002A | 2024-09-13T12:01:25.404Z | 2024-09-16T12:20:19.875Z |
5038413 | 5038413 | 20240905200654_h302y | AU002A | 2024-09-12T12:14:39.010Z | 2024-09-14T12:22:55.960Z |
5036814 | 5036814 | 20240905142910_6hGyH | AU002A | 2024-09-12T12:13:55.200Z | 2024-09-14T12:22:53.285Z |
5031223 | 5031223 | 20240906205532_S5gPZ | AU002A | 2024-09-12T12:04:19.886Z | 2024-09-15T12:21:21.765Z |
5031091 | 5031091 | 20240906202524_jrcfz | AU002A | 2024-09-12T12:03:53.715Z | 2024-09-15T12:21:21.392Z |
5031046 | 5031046 | 20240906201337_KkFyq | AU002A | 2024-09-12T12:03:47.825Z | 2024-09-15T12:21:21.233Z |
5030615 | 5030615 | 20240906171131_oUu1T | AU002A | 2024-09-12T12:02:28.909Z | 2024-09-15T12:21:19.259Z |
5030587 | 5030587 | 20240906170237_c1U86 | AU002A | 2024-09-12T12:02:25.146Z | 2024-09-15T12:21:19.186Z |
5030289 | 5030289 | 20240906143033_K9Q38 | AU002A | 2024-09-12T12:01:38.936Z | 2024-09-15T12:21:18.400Z |
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);