participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,086 rows where station_code = "AU003E" 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 |
---|---|---|---|---|---|
5097132 | 5097132 | 20240912150205_6Eq2j | AU003E | 2024-09-16T12:16:46.127Z | 2024-09-16T12:17:32.042Z |
5097129 | 5097129 | 20240912145538_g6YsQ | AU003E | 2024-09-16T12:16:45.937Z | 2024-09-16T12:17:32.042Z |
5096996 | 5096996 | 20240912132327_yvRhg | AU003E | 2024-09-16T12:16:41.834Z | 2024-09-16T12:17:31.991Z |
5096931 | 5096931 | 20240912123055_RZv11 | AU003E | 2024-09-16T12:16:38.315Z | 2024-09-16T12:17:31.967Z |
5096889 | 5096889 | 20240912120258_iSV8m | AU003E | 2024-09-16T12:16:36.803Z | 2024-09-16T12:17:31.949Z |
5084746 | 5084746 | 20240912200958_KkxrK | AU003E | 2024-09-16T12:02:52.025Z | 2024-09-16T12:17:04.444Z |
5084394 | 5084394 | 20240912193226_lqlpq | AU003E | 2024-09-16T12:02:00.901Z | 2024-09-16T12:17:04.288Z |
5084376 | 5084376 | 20240912193054_IRw8n | AU003E | 2024-09-16T12:01:59.120Z | 2024-09-16T12:17:04.274Z |
5084371 | 5084371 | 20240912193032_RcsQs | AU003E | 2024-09-16T12:01:58.707Z | 2024-09-16T12:17:04.273Z |
5084366 | 5084366 | 20240912192958_JEgrI | AU003E | 2024-09-16T12:01:58.001Z | 2024-09-16T12:17:04.270Z |
5084298 | 5084298 | 20240912191256_SxFuH | AU003E | 2024-09-16T12:01:49.643Z | 2024-09-16T12:17:04.236Z |
5084249 | 5084249 | 20240912190300_lBG0A | AU003E | 2024-09-16T12:01:41.452Z | 2024-09-16T12:17:04.201Z |
5084204 | 5084204 | 20240912185528_QPrj7 | AU003E | 2024-09-16T12:01:34.220Z | 2024-09-16T12:17:04.173Z |
5084201 | 5084201 | 20240912185425_x2QKH | AU003E | 2024-09-16T12:01:33.916Z | 2024-09-16T12:17:04.172Z |
5084095 | 5084095 | 20240912180608_H3xqr | AU003E | 2024-09-16T12:01:08.293Z | 2024-09-16T12:17:04.093Z |
5084060 | 5084060 | 20240912175549_hlLRI | AU003E | 2024-09-16T12:01:02.289Z | 2024-09-16T12:17:04.069Z |
5083789 | 5083789 | 20240912153432_Z2nP2 | AU003E | 2024-09-16T12:00:22.505Z | 2024-09-16T12:17:03.908Z |
5083542 | 5083542 | 20240911134607_fuYtS | AU003E | 2024-09-15T12:18:43.509Z | 2024-09-16T12:19:19.415Z |
5073239 | 5073239 | 20240911210827_ljVoH | AU003E | 2024-09-15T12:06:57.072Z | 2024-09-16T12:17:29.218Z |
5073119 | 5073119 | 20240911210008_zrmuR | AU003E | 2024-09-15T12:06:41.955Z | 2024-09-16T12:17:29.198Z |
5072886 | 5072886 | 20240911204532_srANT | AU003E | 2024-09-15T12:06:15.895Z | 2024-09-16T12:17:29.167Z |
5072864 | 5072864 | 20240911204429_VdLKK | AU003E | 2024-09-15T12:06:13.518Z | 2024-09-16T12:17:29.162Z |
5072852 | 5072852 | 20240911204356_udtx3 | AU003E | 2024-09-15T12:06:12.083Z | 2024-09-16T12:17:29.159Z |
5072757 | 5072757 | 20240911203934_VbTQ6 | AU003E | 2024-09-15T12:06:06.194Z | 2024-09-16T12:17:29.146Z |
5072740 | 5072740 | 20240911203910_jjE8W | AU003E | 2024-09-15T12:06:05.262Z | 2024-09-16T12:17:29.144Z |
5072629 | 5072629 | 20240911203101_ttcR4 | AU003E | 2024-09-15T12:05:52.618Z | 2024-09-16T12:17:29.123Z |
5072600 | 5072600 | 20240911202750_AphWo | AU003E | 2024-09-15T12:05:43.370Z | 2024-09-16T12:17:29.116Z |
5072593 | 5072593 | 20240911202650_lgXC3 | AU003E | 2024-09-15T12:05:42.570Z | 2024-09-16T12:17:29.115Z |
5072566 | 5072566 | 20240911202346_wtt2g | AU003E | 2024-09-15T12:05:38.456Z | 2024-09-16T12:17:29.111Z |
5072486 | 5072486 | 20240911201304_Q24j4 | AU003E | 2024-09-15T12:05:28.737Z | 2024-09-16T12:17:29.094Z |
5072432 | 5072432 | 20240911200842_N8x5g | AU003E | 2024-09-15T12:05:22.171Z | 2024-09-16T12:17:29.083Z |
5072411 | 5072411 | 20240911200502_0gdTw | AU003E | 2024-09-15T12:05:19.368Z | 2024-09-16T12:17:29.078Z |
5072180 | 5072180 | 20240911194453_ZuNGh | AU003E | 2024-09-15T12:04:49.956Z | 2024-09-16T12:17:29.041Z |
5071985 | 5071985 | 20240911191712_v7bLS | AU003E | 2024-09-15T12:04:12.039Z | 2024-09-16T12:17:28.996Z |
5071923 | 5071923 | 20240911190406_5zNvX | AU003E | 2024-09-15T12:04:02.140Z | 2024-09-16T12:17:28.980Z |
5071870 | 5071870 | 20240911184250_DDBNB | AU003E | 2024-09-15T12:03:53.340Z | 2024-09-16T12:17:28.963Z |
5071821 | 5071821 | 20240911182809_vi4Ut | AU003E | 2024-09-15T12:03:46.518Z | 2024-09-16T12:17:28.950Z |
5071751 | 5071751 | 20240911181032_2pAMl | AU003E | 2024-09-15T12:03:24.795Z | 2024-09-16T12:17:28.920Z |
5071732 | 5071732 | 20240911180323_IzPRb | AU003E | 2024-09-15T12:03:21.421Z | 2024-09-16T12:17:28.915Z |
5071682 | 5071682 | 20240911174832_suR6O | AU003E | 2024-09-15T12:03:14.116Z | 2024-09-16T12:17:28.895Z |
5071671 | 5071671 | 20240911174209_g0s7b | AU003E | 2024-09-15T12:03:12.763Z | 2024-09-16T12:17:28.892Z |
5070540 | 5070540 | 20240911143011_FQeL7 | AU003E | 2024-09-15T12:00:16.592Z | 2024-09-16T12:17:28.614Z |
5069051 | 5069051 | 20240910133054_3woqS | AU003E | 2024-09-14T12:19:24.824Z | 2024-09-16T12:20:16.258Z |
5068144 | 5068144 | 20240910110117_NPiUx | AU003E | 2024-09-14T12:19:09.736Z | 2024-09-16T12:20:12.968Z |
5061123 | 5061123 | 20240909141844_3shEq | AU003E | 2024-09-14T12:10:18.221Z | 2024-09-16T12:19:29.328Z |
5060831 | 5060831 | 20240910212525_rezCp | AU003E | 2024-09-14T12:09:39.574Z | 2024-09-16T12:18:20.685Z |
5060753 | 5060753 | 20240910210241_jNm88 | AU003E | 2024-09-14T12:09:29.094Z | 2024-09-16T12:18:18.531Z |
5060601 | 5060601 | 20240910204106_V6skG | AU003E | 2024-09-14T12:09:10.902Z | 2024-09-16T12:18:16.682Z |
5060559 | 5060559 | 20240910203801_Izdop | AU003E | 2024-09-14T12:09:08.358Z | 2024-09-16T12:18:16.578Z |
5060488 | 5060488 | 20240910203401_JJNVB | AU003E | 2024-09-14T12:08:52.988Z | 2024-09-16T12:18:16.142Z |
5060439 | 5060439 | 20240910203100_u8amR | AU003E | 2024-09-14T12:08:49.201Z | 2024-09-16T12:18:15.647Z |
5060400 | 5060400 | 20240910202717_W27Gt | AU003E | 2024-09-14T12:08:44.802Z | 2024-09-16T12:18:15.235Z |
5060367 | 5060367 | 20240910202342_XGDBQ | AU003E | 2024-09-14T12:08:41.943Z | 2024-09-16T12:18:14.977Z |
5060326 | 5060326 | 20240910201848_Zcq0c | AU003E | 2024-09-14T12:08:38.976Z | 2024-09-16T12:18:14.742Z |
5060261 | 5060261 | 20240910201316_uHkcu | AU003E | 2024-09-14T12:08:33.896Z | 2024-09-16T12:18:14.225Z |
5060253 | 5060253 | 20240910201100_JBoZo | AU003E | 2024-09-14T12:08:32.920Z | 2024-09-16T12:18:14.178Z |
5060072 | 5060072 | 20240910194713_uurOV | AU003E | 2024-09-14T12:08:09.252Z | 2024-09-16T12:18:12.565Z |
5060059 | 5060059 | 20240910194418_lz1XN | AU003E | 2024-09-14T12:08:06.646Z | 2024-09-16T12:18:12.420Z |
5060025 | 5060025 | 20240910193513_vScxP | AU003E | 2024-09-14T12:07:58.881Z | 2024-09-16T12:18:11.586Z |
5059902 | 5059902 | 20240910191530_H0O8D | AU003E | 2024-09-14T12:07:35.132Z | 2024-09-16T12:18:09.959Z |
5059813 | 5059813 | 20240910185844_PqxJX | AU003E | 2024-09-14T12:07:19.209Z | 2024-09-16T12:18:08.854Z |
5059792 | 5059792 | 20240910185332_xr6HN | AU003E | 2024-09-14T12:07:12.507Z | 2024-09-16T12:18:08.447Z |
5059585 | 5059585 | 20240910181222_4c58F | AU003E | 2024-09-14T12:06:31.505Z | 2024-09-16T12:18:06.217Z |
5059578 | 5059578 | 20240910181001_6DayQ | AU003E | 2024-09-14T12:06:30.217Z | 2024-09-16T12:18:06.191Z |
5059566 | 5059566 | 20240910180859_an66o | AU003E | 2024-09-14T12:06:28.090Z | 2024-09-16T12:18:06.084Z |
5059494 | 5059494 | 20240910175145_P2utL | AU003E | 2024-09-14T12:06:13.720Z | 2024-09-16T12:18:05.399Z |
5059488 | 5059488 | 20240910175040_273Pc | AU003E | 2024-09-14T12:06:12.882Z | 2024-09-16T12:18:05.339Z |
5059455 | 5059455 | 20240910174552_7ig1s | AU003E | 2024-09-14T12:06:07.999Z | 2024-09-16T12:18:05.056Z |
5059440 | 5059440 | 20240910174230_sA7Lx | AU003E | 2024-09-14T12:06:04.666Z | 2024-09-16T12:18:04.992Z |
5059434 | 5059434 | 20240910174217_N8Y2m | AU003E | 2024-09-14T12:06:02.917Z | 2024-09-16T12:18:04.914Z |
5059318 | 5059318 | 20240910173044_7VwJ4 | AU003E | 2024-09-14T12:05:43.232Z | 2024-09-16T12:18:03.817Z |
5059302 | 5059302 | 20240910172925_YOFYk | AU003E | 2024-09-14T12:05:38.965Z | 2024-09-16T12:18:03.473Z |
5059173 | 5059173 | 20240910171941_Eco38 | AU003E | 2024-09-14T12:05:23.609Z | 2024-09-16T12:18:02.495Z |
5059147 | 5059147 | 20240910171653_Kol8i | AU003E | 2024-09-14T12:05:19.375Z | 2024-09-16T12:18:02.242Z |
5059084 | 5059084 | 20240910171202_h7I2K | AU003E | 2024-09-14T12:05:12.978Z | 2024-09-16T12:18:01.670Z |
5059066 | 5059066 | 20240910171004_VUSrc | AU003E | 2024-09-14T12:05:10.714Z | 2024-09-16T12:18:01.428Z |
5059061 | 5059061 | 20240910170955_ekWkO | AU003E | 2024-09-14T12:05:09.855Z | 2024-09-16T12:18:01.376Z |
5058864 | 5058864 | 20240910165307_2nm28 | AU003E | 2024-09-14T12:04:41.077Z | 2024-09-16T12:17:59.184Z |
5058566 | 5058566 | 20240910162750_pbT3e | AU003E | 2024-09-14T12:04:00.788Z | 2024-09-16T12:17:56.080Z |
5058333 | 5058333 | 20240910160516_1ljyO | AU003E | 2024-09-14T12:03:32.078Z | 2024-09-16T12:17:52.972Z |
5057788 | 5057788 | 20240910151322_ouw5M | AU003E | 2024-09-14T12:02:02.307Z | 2024-09-16T12:17:47.675Z |
5057762 | 5057762 | 20240910151041_dgXTD | AU003E | 2024-09-14T12:01:54.081Z | 2024-09-16T12:17:47.130Z |
5057700 | 5057700 | 20240910150557_AuLNH | AU003E | 2024-09-14T12:01:46.301Z | 2024-09-16T12:17:46.320Z |
5057658 | 5057658 | 20240910150101_CK7ae | AU003E | 2024-09-14T12:01:39.839Z | 2024-09-16T12:17:46.074Z |
5057602 | 5057602 | 20240910145439_UXCs1 | AU003E | 2024-09-14T12:01:30.884Z | 2024-09-16T12:17:45.267Z |
5057579 | 5057579 | 20240910145114_b6Xfd | AU003E | 2024-09-14T12:01:27.914Z | 2024-09-16T12:17:45.057Z |
5057557 | 5057557 | 20240910144900_ljcC3 | AU003E | 2024-09-14T12:01:25.885Z | 2024-09-16T12:17:44.942Z |
5057378 | 5057378 | 20240910141816_1KFrs | AU003E | 2024-09-14T12:00:56.954Z | 2024-09-16T12:17:43.411Z |
5057083 | 5057083 | 20240908120913_oVojP | AU003E | 2024-09-13T12:17:44.544Z | 2024-09-16T12:21:28.744Z |
5049934 | 5049934 | 20240909115951_ff5BN | AU003E | 2024-09-13T12:12:32.447Z | 2024-09-16T12:20:44.847Z |
5043601 | 5043601 | 20240908121846_EC0q1 | AU003E | 2024-09-13T12:00:11.617Z | 2024-09-16T12:20:18.203Z |
5042704 | 5042704 | 20240907122711_rHiRO | AU003E | 2024-09-12T12:17:16.907Z | 2024-09-16T12:20:53.959Z |
5038705 | 5038705 | 20240905212820_pys5M | AU003E | 2024-09-12T12:14:55.420Z | 2024-09-14T12:22:57.281Z |
5038684 | 5038684 | 20240905212422_uMyDN | AU003E | 2024-09-12T12:14:54.700Z | 2024-09-14T12:22:57.159Z |
5038682 | 5038682 | 20240905212409_AesJY | AU003E | 2024-09-12T12:14:54.645Z | 2024-09-14T12:22:57.157Z |
5038648 | 5038648 | 20240905211807_3Y82S | AU003E | 2024-09-12T12:14:52.977Z | 2024-09-14T12:22:57.022Z |
5038646 | 5038646 | 20240905211754_BAarY | AU003E | 2024-09-12T12:14:52.969Z | 2024-09-14T12:22:57.017Z |
5038605 | 5038605 | 20240905210642_ohB4u | AU003E | 2024-09-12T12:14:50.238Z | 2024-09-14T12:22:56.563Z |
5038593 | 5038593 | 20240905210411_yEA9x | AU003E | 2024-09-12T12:14:49.787Z | 2024-09-14T12:22:56.553Z |
5038582 | 5038582 | 20240905210255_6N6TB | AU003E | 2024-09-12T12:14:49.358Z | 2024-09-14T12:22:56.532Z |
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);