participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
662 rows where station_code = "AU000T" 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 |
---|---|---|---|---|---|
5084159 | 5084159 | 20240912183828_upufC | AU000T | 2024-09-16T12:01:19.691Z | 2024-09-16T12:17:04.145Z |
5084151 | 5084151 | 20240912183316_NM4sf | AU000T | 2024-09-16T12:01:16.640Z | 2024-09-16T12:17:04.140Z |
5084123 | 5084123 | 20240912182003_wMg5Q | AU000T | 2024-09-16T12:01:12.560Z | 2024-09-16T12:17:04.107Z |
5084070 | 5084070 | 20240912175939_zjm3T | AU000T | 2024-09-16T12:01:04.608Z | 2024-09-16T12:17:04.077Z |
5084002 | 5084002 | 20240912173356_sza7F | AU000T | 2024-09-16T12:00:54.087Z | 2024-09-16T12:17:04.026Z |
4961497 | 4961497 | 20240811174404_0lAps | AU000T | 2024-09-04T12:03:42.921Z | 2024-09-06T12:03:03.221Z |
4961269 | 4961269 | 20240811172800_I3JJp | AU000T | 2024-09-04T12:03:25.946Z | 2024-09-06T12:02:50.156Z |
4958477 | 4958477 | 20240811103430_Wl50Y | AU000T | 2024-09-03T12:22:25.700Z | 2024-09-06T12:32:07.090Z |
4958259 | 4958259 | 20240811100901_pF3PD | AU000T | 2024-09-03T12:22:18.755Z | 2024-09-06T12:31:58.428Z |
4958144 | 4958144 | 20240811095841_Fuy9x | AU000T | 2024-09-03T12:22:11.044Z | 2024-09-06T12:31:53.904Z |
4957759 | 4957759 | 20240811091727_IV76S | AU000T | 2024-09-03T12:21:42.046Z | 2024-09-06T12:31:35.187Z |
4957400 | 4957400 | 20240811083743_pMBIh | AU000T | 2024-09-03T12:21:11.066Z | 2024-09-06T12:31:17.587Z |
4934831 | 4934831 | 20240810190850_3CGkG | AU000T | 2024-09-01T12:05:51.649Z | 2024-09-06T12:20:21.693Z |
4934642 | 4934642 | 20240810184253_I98PN | AU000T | 2024-09-01T12:05:36.644Z | 2024-09-06T12:20:17.108Z |
4934601 | 4934601 | 20240810183727_w5qF3 | AU000T | 2024-09-01T12:05:33.992Z | 2024-09-06T12:20:16.131Z |
4934588 | 4934588 | 20240810183556_KR3cO | AU000T | 2024-09-01T12:05:33.175Z | 2024-09-06T12:20:15.813Z |
4934578 | 4934578 | 20240810183351_V44Dy | AU000T | 2024-09-01T12:05:32.011Z | 2024-09-06T12:20:15.217Z |
4934405 | 4934405 | 20240810181106_E2MMJ | AU000T | 2024-09-01T12:05:16.750Z | 2024-09-06T12:20:11.108Z |
4934252 | 4934252 | 20240810175930_v0Wsl | AU000T | 2024-09-01T12:05:05.767Z | 2024-09-06T12:20:06.352Z |
4934224 | 4934224 | 20240810175602_Pfn5F | AU000T | 2024-09-01T12:05:03.950Z | 2024-09-06T12:20:04.402Z |
4934108 | 4934108 | 20240810174624_hg5Vm | AU000T | 2024-09-01T12:04:57.567Z | 2024-09-06T12:19:58.425Z |
4934052 | 4934052 | 20240810174037_DqcsS | AU000T | 2024-09-01T12:04:54.419Z | 2024-09-06T12:19:53.249Z |
4933999 | 4933999 | 20240810173842_ZN4sW | AU000T | 2024-09-01T12:04:51.284Z | 2024-09-06T12:19:48.496Z |
4931594 | 4931594 | 20240810104527_WxJr8 | AU000T | 2024-08-31T12:24:43.668Z | 2024-09-02T12:31:02.683Z |
4931421 | 4931421 | 20240810102814_oHBmX | AU000T | 2024-08-31T12:24:36.272Z | 2024-09-02T12:30:53.906Z |
4931300 | 4931300 | 20240810101151_bjzYQ | AU000T | 2024-08-31T12:24:29.164Z | 2024-09-02T12:30:47.446Z |
4931175 | 4931175 | 20240810095549_PjS9o | AU000T | 2024-08-31T12:24:19.169Z | 2024-09-02T12:30:42.969Z |
4924065 | 4924065 | 20240810130528_5P3ud | AU000T | 2024-08-31T12:01:35.373Z | 2024-09-06T12:16:42.412Z |
4923969 | 4923969 | 20240810125703_GJ2Ji | AU000T | 2024-08-31T12:01:25.774Z | 2024-09-06T12:16:36.219Z |
4923892 | 4923892 | 20240810124939_7fLGb | AU000T | 2024-08-31T12:01:14.785Z | 2024-09-06T12:16:29.669Z |
4911279 | 4911279 | 20240809194430_zrPhX | AU000T | 2024-08-29T12:07:13.514Z | 2024-09-02T12:21:28.114Z |
4911227 | 4911227 | 20240809193641_xd2lc | AU000T | 2024-08-29T12:07:09.229Z | 2024-09-02T12:21:26.348Z |
4911138 | 4911138 | 20240809192654_XeMqt | AU000T | 2024-08-29T12:07:02.093Z | 2024-09-02T12:21:20.112Z |
4911093 | 4911093 | 20240809192406_kbzYn | AU000T | 2024-08-29T12:06:59.083Z | 2024-09-02T12:21:17.264Z |
4911074 | 4911074 | 20240809192245_5S4Qd | AU000T | 2024-08-29T12:06:57.959Z | 2024-09-02T12:21:16.331Z |
4911002 | 4911002 | 20240809191059_6i33w | AU000T | 2024-08-29T12:06:52.115Z | 2024-09-02T12:21:13.784Z |
4910958 | 4910958 | 20240809190423_wi2rA | AU000T | 2024-08-29T12:06:49.688Z | 2024-09-02T12:21:12.627Z |
4910794 | 4910794 | 20240809184106_m7Fzv | AU000T | 2024-08-29T12:06:39.827Z | 2024-09-02T12:21:07.388Z |
4910792 | 4910792 | 20240809184105_ni6G8 | AU000T | 2024-08-29T12:06:39.661Z | 2024-09-02T12:21:07.284Z |
4910689 | 4910689 | 20240809182922_hd7Yt | AU000T | 2024-08-29T12:06:31.584Z | 2024-09-02T12:21:03.421Z |
4910615 | 4910615 | 20240809182116_MqsVN | AU000T | 2024-08-29T12:06:24.564Z | 2024-09-02T12:21:00.487Z |
4910452 | 4910452 | 20240809180747_6Y4IP | AU000T | 2024-08-29T12:06:13.843Z | 2024-09-02T12:20:45.761Z |
4910433 | 4910433 | 20240809180614_0Hjs3 | AU000T | 2024-08-29T12:06:12.734Z | 2024-09-02T12:20:42.686Z |
4910048 | 4910048 | 20240809173832_h2A0F | AU000T | 2024-08-29T12:05:46.027Z | 2024-09-02T12:20:29.547Z |
4909639 | 4909639 | 20240809171142_2lHbE | AU000T | 2024-08-29T12:05:21.121Z | 2024-09-02T12:20:07.084Z |
4909429 | 4909429 | 20240809165734_h99sO | AU000T | 2024-08-29T12:05:09.339Z | 2024-09-02T12:19:58.314Z |
4909126 | 4909126 | 20240809163258_CKGvQ | AU000T | 2024-08-29T12:04:48.140Z | 2024-09-02T12:19:46.274Z |
4908965 | 4908965 | 20240809162058_AKL8S | AU000T | 2024-08-29T12:04:39.142Z | 2024-09-02T12:19:34.950Z |
4907285 | 4907285 | 20240809140447_RjTC4 | AU000T | 2024-08-29T12:02:51.143Z | 2024-09-02T12:18:17.456Z |
4906931 | 4906931 | 20240809133002_aiwz8 | AU000T | 2024-08-29T12:02:26.992Z | 2024-09-02T12:18:02.628Z |
4906897 | 4906897 | 20240809132552_Y5yRj | AU000T | 2024-08-29T12:02:24.478Z | 2024-09-02T12:18:01.532Z |
4906400 | 4906400 | 20240809123616_s2S7y | AU000T | 2024-08-29T12:01:50.591Z | 2024-09-02T12:17:36.132Z |
4906110 | 4906110 | 20240809120048_2L9c2 | AU000T | 2024-08-29T12:01:28.006Z | 2024-09-02T12:17:26.760Z |
4906068 | 4906068 | 20240809115532_y8ox7 | AU000T | 2024-08-29T12:01:24.232Z | 2024-09-02T12:17:25.336Z |
4905923 | 4905923 | 20240809113631_8KXFf | AU000T | 2024-08-29T12:01:12.130Z | 2024-09-02T12:17:19.995Z |
4905702 | 4905702 | 20240809111637_tD9D3 | AU000T | 2024-08-29T12:00:49.509Z | 2024-09-02T12:17:00.735Z |
4897778 | 4897778 | 20240807192732_zkjlj | AU000T | 2024-08-28T12:15:52.282Z | 2024-08-28T12:15:52.282Z |
4897766 | 4897766 | 20240807192442_sqfGC | AU000T | 2024-08-28T12:15:51.618Z | 2024-08-28T12:15:51.618Z |
4897593 | 4897593 | 20240807184226_efBH2 | AU000T | 2024-08-28T12:15:36.780Z | 2024-08-28T12:15:36.780Z |
4897324 | 4897324 | 20240807174601_bm30A | AU000T | 2024-08-28T12:15:24.191Z | 2024-08-28T12:15:24.191Z |
4896830 | 4896830 | 20240807162922_66eCp | AU000T | 2024-08-28T12:14:48.480Z | 2024-08-28T12:14:48.480Z |
4896493 | 4896493 | 20240807152010_XfDt4 | AU000T | 2024-08-28T12:14:25.877Z | 2024-08-28T12:14:25.877Z |
4896445 | 4896445 | 20240807151037_BAVZw | AU000T | 2024-08-28T12:14:18.439Z | 2024-08-28T12:14:18.439Z |
4896383 | 4896383 | 20240807145911_zcDQA | AU000T | 2024-08-28T12:14:15.388Z | 2024-08-28T12:14:15.388Z |
4896131 | 4896131 | 20240807142237_dYLpG | AU000T | 2024-08-28T12:14:01.475Z | 2024-08-28T12:14:01.475Z |
4895961 | 4895961 | 20240807135030_KyAzq | AU000T | 2024-08-28T12:13:53.174Z | 2024-08-28T12:13:53.174Z |
4895437 | 4895437 | 20240807122720_3mwpX | AU000T | 2024-08-28T12:13:23.018Z | 2024-08-28T12:13:23.018Z |
4893661 | 4893661 | 20240809102717_k4h52 | AU000T | 2024-08-28T12:11:37.559Z | 2024-08-30T12:23:06.382Z |
4893651 | 4893651 | 20240809102626_JZg4y | AU000T | 2024-08-28T12:11:37.065Z | 2024-08-30T12:23:06.044Z |
4893640 | 4893640 | 20240809102340_u6oq0 | AU000T | 2024-08-28T12:11:36.623Z | 2024-08-30T12:23:05.641Z |
4893489 | 4893489 | 20240809094253_lCUS7 | AU000T | 2024-08-28T12:11:29.592Z | 2024-08-30T12:22:58.983Z |
4893093 | 4893093 | 20240809082848_QjXGL | AU000T | 2024-08-28T12:11:00.913Z | 2024-08-30T12:22:46.200Z |
4888502 | 4888502 | 20240808180144_EyTpC | AU000T | 2024-08-28T12:04:44.108Z | 2024-08-30T12:18:16.939Z |
4817402 | 4817402 | 20240803191145_RQ91p | AU000T | 2024-08-13T12:15:03.890Z | 2024-08-15T12:23:26.051Z |
4817314 | 4817314 | 20240803190137_91oL1 | AU000T | 2024-08-13T12:14:59.426Z | 2024-08-15T12:23:21.135Z |
4816803 | 4816803 | 20240803181657_pIP7K | AU000T | 2024-08-13T12:14:34.893Z | 2024-08-15T12:23:06.563Z |
4816577 | 4816577 | 20240803180511_WyaZN | AU000T | 2024-08-13T12:14:23.992Z | 2024-08-15T12:23:01.153Z |
4815578 | 4815578 | 20240803171350_NA1lZ | AU000T | 2024-08-13T12:13:40.390Z | 2024-08-15T12:22:46.747Z |
4811874 | 4811874 | 20240803143134_7ask2 | AU000T | 2024-08-13T12:10:19.603Z | 2024-08-15T12:21:02.391Z |
4810551 | 4810551 | 20240803131957_gDjCB | AU000T | 2024-08-13T12:08:41.518Z | 2024-08-15T12:20:04.013Z |
4809657 | 4809657 | 20240803122239_4LQuF | AU000T | 2024-08-13T12:07:25.454Z | 2024-08-15T12:19:44.501Z |
4778112 | 4778112 | 20240801190426_NvwRl | AU000T | 2024-08-07T12:11:08.625Z | 2024-08-11T12:13:31.837Z |
4778091 | 4778091 | 20240801185341_hwZCc | AU000T | 2024-08-07T12:11:07.609Z | 2024-08-11T12:13:30.648Z |
4778054 | 4778054 | 20240801183614_puiqc | AU000T | 2024-08-07T12:11:05.821Z | 2024-08-11T12:13:28.378Z |
4777675 | 4777675 | 20240801173317_tnRHb | AU000T | 2024-08-07T12:10:51.091Z | 2024-08-11T12:13:16.665Z |
4777640 | 4777640 | 20240801172808_ODye6 | AU000T | 2024-08-07T12:10:50.405Z | 2024-08-11T12:13:16.209Z |
4776946 | 4776946 | 20240801155537_1TO1Z | AU000T | 2024-08-07T12:10:02.876Z | 2024-08-11T12:13:00.662Z |
4776920 | 4776920 | 20240801155256_RzfQ3 | AU000T | 2024-08-07T12:10:00.542Z | 2024-08-11T12:13:00.212Z |
4776667 | 4776667 | 20240801152023_hCkbE | AU000T | 2024-08-07T12:09:37.205Z | 2024-08-11T12:12:53.355Z |
4776646 | 4776646 | 20240801151826_QhmjJ | AU000T | 2024-08-07T12:09:35.769Z | 2024-08-11T12:12:53.009Z |
4776425 | 4776425 | 20240801145457_qpxe6 | AU000T | 2024-08-07T12:09:23.057Z | 2024-08-11T12:12:50.065Z |
4776132 | 4776132 | 20240801142154_23VHN | AU000T | 2024-08-07T12:09:05.299Z | 2024-08-11T12:12:47.051Z |
4775487 | 4775487 | 20240801131952_3Sgpp | AU000T | 2024-08-07T12:08:40.471Z | 2024-08-11T12:12:40.608Z |
4775134 | 4775134 | 20240801125158_Ayfm1 | AU000T | 2024-08-07T12:08:15.348Z | 2024-08-11T12:12:35.027Z |
4773629 | 4773629 | 20240801101837_BGPQJ | AU000T | 2024-08-07T12:06:10.890Z | 2024-08-11T12:12:03.601Z |
4773187 | 4773187 | 20240801092529_w1JIJ | AU000T | 2024-08-07T12:05:21.555Z | 2024-08-11T12:11:52.445Z |
4768655 | 4768655 | 20240731180403_7pc1o | AU000T | 2024-08-06T12:10:10.211Z | 2024-08-10T12:20:12.795Z |
4768533 | 4768533 | 20240731174449_yerwI | AU000T | 2024-08-06T12:10:03.950Z | 2024-08-10T12:20:09.787Z |
4767817 | 4767817 | 20240731155250_sCOp0 | AU000T | 2024-08-06T12:09:31.920Z | 2024-08-10T12:19:54.390Z |
4767552 | 4767552 | 20240731151900_oLJrR | AU000T | 2024-08-06T12:09:17.879Z | 2024-08-10T12:19:48.109Z |
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);