participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
901 rows where station_code = "AU004B" 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 |
---|---|---|---|---|---|
5314894 | 5314894 | 20241016182947_zEGqe | AU004B | 2024-10-17T12:03:11.287Z | 2024-10-18T12:04:36.389Z |
5314889 | 5314889 | 20241016180456_mLpV3 | AU004B | 2024-10-17T12:03:09.839Z | 2024-10-18T12:04:36.385Z |
5310427 | 5310427 | 20241014165035_9C0Wx | AU004B | 2024-10-16T12:06:56.119Z | 2024-10-18T12:09:35.711Z |
5310418 | 5310418 | 20241014164259_qXJW3 | AU004B | 2024-10-16T12:06:53.027Z | 2024-10-18T12:09:35.243Z |
5298826 | 5298826 | 20241012171920_eiqvi | AU004B | 2024-10-14T12:11:11.760Z | 2024-10-18T12:15:23.440Z |
5298665 | 5298665 | 20241012165206_NjqEB | AU004B | 2024-10-14T12:10:59.555Z | 2024-10-18T12:15:21.262Z |
5298625 | 5298625 | 20241012164821_CKuw6 | AU004B | 2024-10-14T12:10:56.414Z | 2024-10-18T12:15:20.812Z |
5298392 | 5298392 | 20241012161440_Rx84b | AU004B | 2024-10-14T12:10:17.473Z | 2024-10-18T12:15:14.559Z |
5298362 | 5298362 | 20241012161236_ys8Ax | AU004B | 2024-10-14T12:10:15.430Z | 2024-10-18T12:15:13.362Z |
5297647 | 5297647 | 20241012140355_QjzLE | AU004B | 2024-10-14T12:08:55.856Z | 2024-10-18T12:15:02.055Z |
5297358 | 5297358 | 20241012130051_ZNy2I | AU004B | 2024-10-14T12:08:11.875Z | 2024-10-18T12:14:58.550Z |
5297354 | 5297354 | 20241012130005_zpZ0i | AU004B | 2024-10-14T12:08:11.361Z | 2024-10-18T12:14:58.511Z |
5297344 | 5297344 | 20241012125559_OKYs0 | AU004B | 2024-10-14T12:08:10.470Z | 2024-10-18T12:14:58.316Z |
5296387 | 5296387 | 20241012101057_ItP4n | AU004B | 2024-10-14T12:05:56.821Z | 2024-10-18T12:14:37.338Z |
5290497 | 5290497 | 20241011180501_8DOgo | AU004B | 2024-10-13T12:12:37.550Z | 2024-10-18T12:19:11.556Z |
5290489 | 5290489 | 20241011180225_YN5tN | AU004B | 2024-10-13T12:12:36.266Z | 2024-10-18T12:19:11.521Z |
5290481 | 5290481 | 20241011175950_2z1po | AU004B | 2024-10-13T12:12:35.113Z | 2024-10-18T12:19:11.453Z |
5290152 | 5290152 | 20241011163705_kmIIR | AU004B | 2024-10-13T12:11:59.652Z | 2024-10-18T12:19:08.996Z |
5289300 | 5289300 | 20241011151722_zv2Ct | AU004B | 2024-10-13T12:10:34.681Z | 2024-10-18T12:19:04.290Z |
5288976 | 5288976 | 20241011144656_CeP89 | AU004B | 2024-10-13T12:10:17.329Z | 2024-10-18T12:19:01.161Z |
5281074 | 5281074 | 20241010173042_2s2Om | AU004B | 2024-10-12T12:13:27.233Z | 2024-10-18T12:20:56.490Z |
5280795 | 5280795 | 20241010164303_aUPHI | AU004B | 2024-10-12T12:12:51.653Z | 2024-10-18T12:20:53.737Z |
5280778 | 5280778 | 20241010164037_4fCQO | AU004B | 2024-10-12T12:12:50.602Z | 2024-10-18T12:20:53.628Z |
5280751 | 5280751 | 20241010163527_c2JuW | AU004B | 2024-10-12T12:12:49.393Z | 2024-10-18T12:20:53.472Z |
5280739 | 5280739 | 20241010163302_aczNo | AU004B | 2024-10-12T12:12:48.342Z | 2024-10-18T12:20:53.454Z |
5280550 | 5280550 | 20241010162022_sNtKG | AU004B | 2024-10-12T12:12:34.552Z | 2024-10-18T12:20:51.596Z |
5280174 | 5280174 | 20241010154741_A9W45 | AU004B | 2024-10-12T12:11:59.031Z | 2024-10-18T12:20:49.585Z |
5279910 | 5279910 | 20241010152904_Qrv8T | AU004B | 2024-10-12T12:11:33.115Z | 2024-10-18T12:20:48.095Z |
5278034 | 5278034 | 20241011093444_7Aq6B | AU004B | 2024-10-12T12:05:07.691Z | 2024-10-18T12:18:19.008Z |
5273817 | 5273817 | 20241009184107_6UsMq | AU004B | 2024-10-11T12:13:18.400Z | 2024-10-18T12:22:04.631Z |
5273531 | 5273531 | 20241009175020_paCLm | AU004B | 2024-10-11T12:12:38.827Z | 2024-10-18T12:22:02.437Z |
5273511 | 5273511 | 20241009174409_QolGg | AU004B | 2024-10-11T12:12:36.810Z | 2024-10-18T12:22:02.346Z |
5273377 | 5273377 | 20241009171624_2ANuq | AU004B | 2024-10-11T12:12:20.788Z | 2024-10-18T12:22:01.408Z |
5273367 | 5273367 | 20241009171419_9Aj3u | AU004B | 2024-10-11T12:12:19.587Z | 2024-10-18T12:22:01.400Z |
5273260 | 5273260 | 20241009164747_3opZM | AU004B | 2024-10-11T12:12:10.682Z | 2024-10-18T12:22:00.665Z |
5273086 | 5273086 | 20241009161859_YhUsE | AU004B | 2024-10-11T12:11:59.186Z | 2024-10-18T12:21:59.675Z |
5272946 | 5272946 | 20241009155549_klBgm | AU004B | 2024-10-11T12:11:44.729Z | 2024-10-18T12:21:59.094Z |
5272936 | 5272936 | 20241009155359_5u03H | AU004B | 2024-10-11T12:11:43.782Z | 2024-10-18T12:21:58.976Z |
5272818 | 5272818 | 20241009152841_Gwo11 | AU004B | 2024-10-11T12:11:25.948Z | 2024-10-18T12:21:58.424Z |
5272729 | 5272729 | 20241009151206_E2ifl | AU004B | 2024-10-11T12:11:13.842Z | 2024-10-18T12:21:58.006Z |
5272663 | 5272663 | 20241009150202_IT4d0 | AU004B | 2024-10-11T12:11:06.286Z | 2024-10-18T12:21:57.711Z |
5272377 | 5272377 | 20241009140732_9NARQ | AU004B | 2024-10-11T12:10:36.442Z | 2024-10-18T12:21:55.846Z |
5272361 | 5272361 | 20241009140328_E63BO | AU004B | 2024-10-11T12:10:34.944Z | 2024-10-18T12:21:55.758Z |
5272327 | 5272327 | 20241009135455_n6hNx | AU004B | 2024-10-11T12:10:31.979Z | 2024-10-18T12:21:55.524Z |
5272135 | 5272135 | 20241009131405_QHcHx | AU004B | 2024-10-11T12:10:11.089Z | 2024-10-18T12:21:54.801Z |
5271920 | 5271920 | 20241009122741_OFdFv | AU004B | 2024-10-11T12:09:40.238Z | 2024-10-18T12:21:53.502Z |
5271775 | 5271775 | 20241009114356_lt0SQ | AU004B | 2024-10-11T12:09:20.824Z | 2024-10-18T12:21:51.120Z |
5271620 | 5271620 | 20241010121735_WRwb1 | AU004B | 2024-10-11T12:07:20.184Z | 2024-10-18T12:20:31.141Z |
5271326 | 5271326 | 20241010114248_3xHki | AU004B | 2024-10-11T12:06:33.353Z | 2024-10-18T12:20:27.309Z |
5271000 | 5271000 | 20241010110012_cGd39 | AU004B | 2024-10-11T12:05:48.875Z | 2024-10-18T12:20:21.053Z |
5266889 | 5266889 | 20241008173945_XNTuP | AU004B | 2024-10-10T12:12:58.039Z | 2024-10-17T12:20:07.439Z |
5266860 | 5266860 | 20241008172729_h7d1P | AU004B | 2024-10-10T12:12:54.063Z | 2024-10-17T12:20:07.306Z |
5266851 | 5266851 | 20241008172424_dd6Fz | AU004B | 2024-10-10T12:12:53.164Z | 2024-10-17T12:20:07.286Z |
5266846 | 5266846 | 20241008172220_Wjmi4 | AU004B | 2024-10-10T12:12:52.599Z | 2024-10-17T12:20:07.247Z |
5266799 | 5266799 | 20241008165136_meAN9 | AU004B | 2024-10-10T12:12:43.731Z | 2024-10-17T12:20:06.440Z |
5266784 | 5266784 | 20241008164729_wGEwj | AU004B | 2024-10-10T12:12:42.628Z | 2024-10-17T12:20:06.354Z |
5266620 | 5266620 | 20241008160703_XklD3 | AU004B | 2024-10-10T12:12:17.745Z | 2024-10-17T12:20:05.553Z |
5266617 | 5266617 | 20241008160507_CVgvF | AU004B | 2024-10-10T12:12:17.235Z | 2024-10-17T12:20:05.548Z |
5266578 | 5266578 | 20241008155359_axSCl | AU004B | 2024-10-10T12:12:10.079Z | 2024-10-17T12:20:05.320Z |
5266533 | 5266533 | 20241008153828_o3s45 | AU004B | 2024-10-10T12:12:03.166Z | 2024-10-17T12:20:05.153Z |
5266462 | 5266462 | 20241008151512_Q6FFx | AU004B | 2024-10-10T12:11:50.791Z | 2024-10-17T12:20:04.652Z |
5266336 | 5266336 | 20241008143901_Mh8bV | AU004B | 2024-10-10T12:11:39.513Z | 2024-10-17T12:20:03.585Z |
5266275 | 5266275 | 20241008140836_3MsNa | AU004B | 2024-10-10T12:11:34.428Z | 2024-10-17T12:20:03.279Z |
5266249 | 5266249 | 20241008135451_huD0P | AU004B | 2024-10-10T12:11:32.514Z | 2024-10-17T12:20:03.143Z |
5266171 | 5266171 | 20241008132340_lHTve | AU004B | 2024-10-10T12:11:26.697Z | 2024-10-17T12:20:02.956Z |
5266156 | 5266156 | 20241008131712_36rTE | AU004B | 2024-10-10T12:11:25.302Z | 2024-10-17T12:20:02.940Z |
5266151 | 5266151 | 20241008131655_N2TaC | AU004B | 2024-10-10T12:11:24.262Z | 2024-10-17T12:20:02.913Z |
5266081 | 5266081 | 20241008124857_zWJoH | AU004B | 2024-10-10T12:11:09.787Z | 2024-10-17T12:20:02.784Z |
5266037 | 5266037 | 20241008123045_gryYw | AU004B | 2024-10-10T12:11:03.509Z | 2024-10-17T12:20:02.705Z |
5265947 | 5265947 | 20241008113726_9DKvK | AU004B | 2024-10-10T12:10:35.615Z | 2024-10-17T12:20:01.853Z |
5265312 | 5265312 | 20241009113816_piwLX | AU004B | 2024-10-10T12:06:38.717Z | 2024-10-18T12:21:50.513Z |
5265193 | 5265193 | 20241009111954_QhOp2 | AU004B | 2024-10-10T12:06:20.167Z | 2024-10-18T12:21:49.837Z |
5265085 | 5265085 | 20241009105445_Cy2Ke | AU004B | 2024-10-10T12:06:06.353Z | 2024-10-18T12:21:48.951Z |
5264745 | 5264745 | 20241009094449_FT1oW | AU004B | 2024-10-10T12:04:56.785Z | 2024-10-18T12:21:45.964Z |
5264692 | 5264692 | 20241009092828_ka2Qd | AU004B | 2024-10-10T12:04:46.449Z | 2024-10-18T12:21:45.633Z |
5261061 | 5261061 | 20241007183649_h185i | AU004B | 2024-10-09T12:13:30.124Z | 2024-10-16T12:21:12.867Z |
5260816 | 5260816 | 20241007175141_DAOxu | AU004B | 2024-10-09T12:12:59.370Z | 2024-10-16T12:21:12.209Z |
5260634 | 5260634 | 20241007170323_EgO2v | AU004B | 2024-10-09T12:12:46.703Z | 2024-10-16T12:21:11.683Z |
5260272 | 5260272 | 20241007160252_Er3S3 | AU004B | 2024-10-09T12:12:13.511Z | 2024-10-16T12:21:10.668Z |
5260066 | 5260066 | 20241007152857_RQ0F4 | AU004B | 2024-10-09T12:11:46.253Z | 2024-10-16T12:21:10.258Z |
5259331 | 5259331 | 20241007134510_UPp4Y | AU004B | 2024-10-09T12:10:36.117Z | 2024-10-16T12:21:08.500Z |
5259220 | 5259220 | 20241007132949_eOQlM | AU004B | 2024-10-09T12:10:28.588Z | 2024-10-16T12:21:08.400Z |
5251842 | 5251842 | 20241006152826_ktdLv | AU004B | 2024-10-08T12:10:40.682Z | 2024-10-15T12:28:55.085Z |
5251494 | 5251494 | 20241006122247_q3Wes | AU004B | 2024-10-08T12:10:05.719Z | 2024-10-15T12:28:53.338Z |
5242427 | 5242427 | 20241005140457_dodwO | AU004B | 2024-10-07T12:12:09.499Z | 2024-10-14T12:24:28.917Z |
5242346 | 5242346 | 20241005135417_qUtZY | AU004B | 2024-10-07T12:12:04.831Z | 2024-10-14T12:24:28.858Z |
5242313 | 5242313 | 20241005134614_7kZfW | AU004B | 2024-10-07T12:12:01.527Z | 2024-10-14T12:24:28.796Z |
5232977 | 5232977 | 20241004184037_w7zid | AU004B | 2024-10-06T12:12:46.733Z | 2024-10-13T12:26:20.075Z |
5232962 | 5232962 | 20241004183845_fOONV | AU004B | 2024-10-06T12:12:45.447Z | 2024-10-13T12:26:20.025Z |
5232663 | 5232663 | 20241004173939_1wRG6 | AU004B | 2024-10-06T12:12:11.262Z | 2024-10-13T12:26:19.565Z |
5232544 | 5232544 | 20241004171405_U9cj3 | AU004B | 2024-10-06T12:12:02.876Z | 2024-10-13T12:26:19.316Z |
5232538 | 5232538 | 20241004171249_ib22E | AU004B | 2024-10-06T12:12:02.012Z | 2024-10-13T12:26:19.310Z |
5230507 | 5230507 | 20241004120526_oa0rP | AU004B | 2024-10-06T12:08:49.090Z | 2024-10-13T12:26:16.504Z |
5221721 | 5221721 | 20241003110057_WApZq | AU004B | 2024-10-05T12:14:25.942Z | 2024-10-12T12:25:02.313Z |
5221550 | 5221550 | 20241003103205_gRN2r | AU004B | 2024-10-05T12:14:00.116Z | 2024-10-12T12:25:01.819Z |
5221503 | 5221503 | 20241003101401_konRp | AU004B | 2024-10-05T12:13:52.584Z | 2024-10-12T12:25:01.609Z |
5209683 | 5209683 | 20241001163625_S5G9h | AU004B | 2024-10-03T12:13:38.845Z | 2024-10-10T12:24:43.625Z |
5209646 | 5209646 | 20241001161944_0ZK7m | AU004B | 2024-10-03T12:13:36.538Z | 2024-10-10T12:24:43.447Z |
5209629 | 5209629 | 20241001160946_HELpt | AU004B | 2024-10-03T12:13:35.183Z | 2024-10-10T12:24:43.398Z |
5209561 | 5209561 | 20241001154126_j2r2Q | AU004B | 2024-10-03T12:13:30.443Z | 2024-10-10T12:24:43.184Z |
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);