participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "UK002F" 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 |
---|---|---|---|---|---|
5453823 | 5453823 | 20241031030543_mIjY1 | UK002F | 2024-11-02T12:22:43.330Z | 2024-11-08T14:23:19.244Z |
5453696 | 5453696 | 20241031024630_flTNr | UK002F | 2024-11-02T12:22:40.717Z | 2024-11-08T14:23:18.865Z |
5453444 | 5453444 | 20241031021249_lrTYY | UK002F | 2024-11-02T12:22:33.781Z | 2024-11-08T14:23:17.413Z |
5453155 | 5453155 | 20241031014541_JbXG3 | UK002F | 2024-11-02T12:22:28.253Z | 2024-11-08T14:23:16.102Z |
5430231 | 5430231 | 20241028213856_QC18F | UK002F | 2024-10-31T12:17:55.543Z | 2024-11-06T14:27:19.400Z |
5430084 | 5430084 | 20241028210101_aRVWJ | UK002F | 2024-10-31T12:17:35.494Z | 2024-11-06T14:27:18.799Z |
5428902 | 5428902 | 20241028182032_ntlqa | UK002F | 2024-10-31T12:15:39.342Z | 2024-11-06T14:27:14.753Z |
5407843 | 5407843 | 20241027025517_nXNAb | UK002F | 2024-10-29T12:15:48.501Z | 2024-11-04T14:28:58.242Z |
5407792 | 5407792 | 20241027025259_wtpJD | UK002F | 2024-10-29T12:15:42.036Z | 2024-11-04T14:28:58.156Z |
5407770 | 5407770 | 20241027025204_lUWIS | UK002F | 2024-10-29T12:15:40.168Z | 2024-11-04T14:28:58.140Z |
5407683 | 5407683 | 20241027024710_jJ6dn | UK002F | 2024-10-29T12:15:34.137Z | 2024-11-04T14:28:58.042Z |
5407588 | 5407588 | 20241027024338_B4c2o | UK002F | 2024-10-29T12:15:30.902Z | 2024-11-04T14:28:57.906Z |
5406178 | 5406178 | 20241027012013_ViZe0 | UK002F | 2024-10-29T12:13:55.760Z | 2024-11-04T14:28:55.190Z |
5406128 | 5406128 | 20241027011826_AwXPw | UK002F | 2024-10-29T12:13:52.957Z | 2024-11-04T14:28:55.153Z |
5406006 | 5406006 | 20241027011202_lpyJm | UK002F | 2024-10-29T12:13:47.561Z | 2024-11-04T14:28:54.843Z |
5405990 | 5405990 | 20241027011156_4fZZZ | UK002F | 2024-10-29T12:13:45.289Z | 2024-11-04T14:28:54.829Z |
5405957 | 5405957 | 20241027011023_tutN1 | UK002F | 2024-10-29T12:13:39.422Z | 2024-11-04T14:28:54.767Z |
5405926 | 5405926 | 20241027010849_WtxI4 | UK002F | 2024-10-29T12:13:34.531Z | 2024-11-04T14:28:54.620Z |
5405910 | 5405910 | 20241027010720_Zw4Tl | UK002F | 2024-10-29T12:13:32.374Z | 2024-11-04T14:28:54.601Z |
5405889 | 5405889 | 20241027010600_tDQVE | UK002F | 2024-10-29T12:13:27.982Z | 2024-11-04T14:28:54.564Z |
5405671 | 5405671 | 20241027005237_6cjxi | UK002F | 2024-10-29T12:13:09.035Z | 2024-11-04T14:28:53.887Z |
5405598 | 5405598 | 20241027004754_a9jpq | UK002F | 2024-10-29T12:13:04.347Z | 2024-11-04T14:28:53.698Z |
5405392 | 5405392 | 20241027003209_JIK2R | UK002F | 2024-10-29T12:12:54.384Z | 2024-11-04T14:28:53.437Z |
5405250 | 5405250 | 20241027002547_lNBYz | UK002F | 2024-10-29T12:12:46.320Z | 2024-11-04T14:28:53.176Z |
5405182 | 5405182 | 20241027002058_8IYXN | UK002F | 2024-10-29T12:12:39.932Z | 2024-11-04T14:28:52.762Z |
5405150 | 5405150 | 20241027001630_dKs5J | UK002F | 2024-10-29T12:12:32.990Z | 2024-11-04T14:28:52.727Z |
5404907 | 5404907 | 20241027000030_kqAoN | UK002F | 2024-10-29T12:12:06.753Z | 2024-11-04T14:28:52.402Z |
5404799 | 5404799 | 20241026235242_nVJXB | UK002F | 2024-10-29T12:11:58.248Z | 2024-11-04T14:28:51.970Z |
5404443 | 5404443 | 20241026232650_31hau | UK002F | 2024-10-29T12:11:27.911Z | 2024-11-04T14:28:51.056Z |
5404268 | 5404268 | 20241026231312_2dMb8 | UK002F | 2024-10-29T12:11:04.002Z | 2024-11-04T14:28:50.571Z |
5404166 | 5404166 | 20241026230351_UeIko | UK002F | 2024-10-29T12:10:57.482Z | 2024-11-04T14:28:50.393Z |
5404084 | 5404084 | 20241026225640_Mx9Bw | UK002F | 2024-10-29T12:10:52.615Z | 2024-11-04T14:28:50.320Z |
5403925 | 5403925 | 20241026224603_CQNbt | UK002F | 2024-10-29T12:10:29.101Z | 2024-11-04T14:28:50.026Z |
5403895 | 5403895 | 20241026224356_mtjeC | UK002F | 2024-10-29T12:10:25.445Z | 2024-11-04T14:28:49.952Z |
5403732 | 5403732 | 20241026222636_tlNb2 | UK002F | 2024-10-29T12:10:10.593Z | 2024-11-04T14:28:49.527Z |
5403718 | 5403718 | 20241026222438_cNPbV | UK002F | 2024-10-29T12:10:09.578Z | 2024-11-04T14:28:49.519Z |
5403628 | 5403628 | 20241026221838_IxpdU | UK002F | 2024-10-29T12:10:03.126Z | 2024-11-04T14:28:49.363Z |
5403619 | 5403619 | 20241026221633_TxrGX | UK002F | 2024-10-29T12:10:02.407Z | 2024-11-04T14:28:49.339Z |
5403606 | 5403606 | 20241026221548_wu8lY | UK002F | 2024-10-29T12:10:01.816Z | 2024-11-04T14:28:49.325Z |
5403243 | 5403243 | 20241026213213_9WQcF | UK002F | 2024-10-29T12:09:15.643Z | 2024-11-04T14:28:48.088Z |
5403021 | 5403021 | 20241026210501_0hl4E | UK002F | 2024-10-29T12:08:45.092Z | 2024-11-04T14:28:47.385Z |
5402979 | 5402979 | 20241026205724_0uW0d | UK002F | 2024-10-29T12:08:42.014Z | 2024-11-04T14:28:47.253Z |
5402745 | 5402745 | 20241026201918_PXVF6 | UK002F | 2024-10-29T12:08:04.947Z | 2024-11-04T14:28:46.433Z |
5402728 | 5402728 | 20241026201716_i6UHU | UK002F | 2024-10-29T12:08:01.482Z | 2024-11-04T14:28:46.384Z |
5402700 | 5402700 | 20241026201529_DEP2K | UK002F | 2024-10-29T12:07:58.721Z | 2024-11-04T14:28:46.257Z |
5402374 | 5402374 | 20241026192444_MS5ox | UK002F | 2024-10-29T12:07:07.006Z | 2024-11-04T14:28:44.162Z |
5402354 | 5402354 | 20241026192204_DqKGZ | UK002F | 2024-10-29T12:07:04.266Z | 2024-11-04T14:28:43.945Z |
5402003 | 5402003 | 20241026182338_ydLlA | UK002F | 2024-10-29T12:06:03.268Z | 2024-11-04T14:28:41.538Z |
5401874 | 5401874 | 20241026175537_2Opq8 | UK002F | 2024-10-29T12:05:40.986Z | 2024-11-04T14:28:40.520Z |
5398514 | 5398514 | 20241026030503_WBrxE | UK002F | 2024-10-28T12:19:20.721Z | 2024-11-03T14:27:36.687Z |
5398072 | 5398072 | 20241026022220_sB5N3 | UK002F | 2024-10-28T12:18:59.511Z | 2024-11-03T14:27:35.264Z |
5396773 | 5396773 | 20241026003225_7UVY2 | UK002F | 2024-10-28T12:17:55.413Z | 2024-11-03T14:27:30.867Z |
5396642 | 5396642 | 20241026001938_dm3er | UK002F | 2024-10-28T12:17:52.039Z | 2024-11-03T14:27:30.545Z |
5396620 | 5396620 | 20241026001707_BgtW8 | UK002F | 2024-10-28T12:17:51.479Z | 2024-11-03T14:27:30.482Z |
5396504 | 5396504 | 20241026000908_BXYAC | UK002F | 2024-10-28T12:17:47.574Z | 2024-11-03T14:27:30.039Z |
5396427 | 5396427 | 20241026000343_f2NJv | UK002F | 2024-10-28T12:17:41.716Z | 2024-11-03T14:27:29.826Z |
5396376 | 5396376 | 20241026000033_D50Kw | UK002F | 2024-10-28T12:17:37.194Z | 2024-11-03T14:27:29.648Z |
5396330 | 5396330 | 20241025235604_3R421 | UK002F | 2024-10-28T12:17:34.106Z | 2024-11-03T14:27:29.534Z |
5396177 | 5396177 | 20241025234604_exnnS | UK002F | 2024-10-28T12:17:24.409Z | 2024-11-03T14:27:28.830Z |
5385227 | 5385227 | 20241024221037_Qpjxj | UK002F | 2024-10-27T12:18:35.872Z | 2024-11-02T12:28:29.293Z |
5378113 | 5378113 | 20241024052729_nWSLp | UK002F | 2024-10-26T12:22:54.558Z | 2024-11-01T12:27:03.290Z |
5377954 | 5377954 | 20241024051937_918K6 | UK002F | 2024-10-26T12:22:50.896Z | 2024-11-01T12:27:03.200Z |
5377770 | 5377770 | 20241024050923_2pBoi | UK002F | 2024-10-26T12:22:46.807Z | 2024-11-01T12:27:02.813Z |
5377614 | 5377614 | 20241024050005_NgBXv | UK002F | 2024-10-26T12:22:42.663Z | 2024-11-01T12:27:02.679Z |
5377372 | 5377372 | 20241024044759_uqEd1 | UK002F | 2024-10-26T12:22:35.427Z | 2024-11-01T12:27:02.411Z |
5377365 | 5377365 | 20241024044723_GEQrg | UK002F | 2024-10-26T12:22:35.312Z | 2024-11-01T12:27:02.408Z |
5377168 | 5377168 | 20241024043726_Hyg3l | UK002F | 2024-10-26T12:22:29.824Z | 2024-11-01T12:27:02.252Z |
5377129 | 5377129 | 20241024043446_836up | UK002F | 2024-10-26T12:22:27.829Z | 2024-11-01T12:27:02.206Z |
5377038 | 5377038 | 20241024042950_KsDHO | UK002F | 2024-10-26T12:22:24.789Z | 2024-11-01T12:27:02.156Z |
5376576 | 5376576 | 20241024040236_3V73z | UK002F | 2024-10-26T12:22:05.268Z | 2024-11-01T12:27:01.605Z |
5376223 | 5376223 | 20241024034600_ZpLqH | UK002F | 2024-10-26T12:21:53.772Z | 2024-11-01T12:27:01.463Z |
5375972 | 5375972 | 20241024033702_m73UA | UK002F | 2024-10-26T12:21:45.417Z | 2024-11-01T12:27:01.301Z |
5375839 | 5375839 | 20241024033229_nKCCg | UK002F | 2024-10-26T12:21:41.625Z | 2024-11-01T12:27:01.219Z |
5375555 | 5375555 | 20241024031944_IEoTM | UK002F | 2024-10-26T12:21:31.225Z | 2024-11-01T12:27:00.774Z |
5375184 | 5375184 | 20241024030121_5d27L | UK002F | 2024-10-26T12:21:16.222Z | 2024-11-01T12:27:00.434Z |
5374587 | 5374587 | 20241024023607_67m4j | UK002F | 2024-10-26T12:20:54.339Z | 2024-11-01T12:26:59.514Z |
5374391 | 5374391 | 20241024022519_giMIj | UK002F | 2024-10-26T12:20:47.255Z | 2024-11-01T12:26:59.356Z |
5374103 | 5374103 | 20241024021042_HOMDd | UK002F | 2024-10-26T12:20:37.259Z | 2024-11-01T12:26:58.702Z |
5373355 | 5373355 | 20241024013422_30UCm | UK002F | 2024-10-26T12:20:08.815Z | 2024-11-01T12:26:58.233Z |
5372910 | 5372910 | 20241024011343_DSdbL | UK002F | 2024-10-26T12:19:47.864Z | 2024-11-01T12:26:58.025Z |
5372420 | 5372420 | 20241024004706_dydDR | UK002F | 2024-10-26T12:19:23.809Z | 2024-11-01T12:26:57.446Z |
5372129 | 5372129 | 20241024003421_s4uh5 | UK002F | 2024-10-26T12:19:10.805Z | 2024-11-01T12:26:57.157Z |
5367139 | 5367139 | 20241023053605_Gx4A8 | UK002F | 2024-10-25T12:21:46.760Z | 2024-10-31T12:30:11.553Z |
5365690 | 5365690 | 20241023234323_Q5N68 | UK002F | 2024-10-25T12:18:05.114Z | 2024-11-01T12:26:56.355Z |
5365670 | 5365670 | 20241023234220_BNk0u | UK002F | 2024-10-25T12:18:04.620Z | 2024-11-01T12:26:56.333Z |
5365535 | 5365535 | 20241023233627_jGoDH | UK002F | 2024-10-25T12:18:00.089Z | 2024-11-01T12:26:56.189Z |
5365528 | 5365528 | 20241023233626_gnTTt | UK002F | 2024-10-25T12:18:00.006Z | 2024-11-01T12:26:56.188Z |
5365416 | 5365416 | 20241023233058_X352t | UK002F | 2024-10-25T12:17:57.553Z | 2024-11-01T12:26:56.086Z |
5365341 | 5365341 | 20241023232639_i3yr5 | UK002F | 2024-10-25T12:17:56.149Z | 2024-11-01T12:26:56.058Z |
5364986 | 5364986 | 20241023230909_sS6uO | UK002F | 2024-10-25T12:17:42.910Z | 2024-11-01T12:26:55.820Z |
5364703 | 5364703 | 20241023224810_zhjvG | UK002F | 2024-10-25T12:17:31.362Z | 2024-11-01T12:26:55.594Z |
5364480 | 5364480 | 20241023223159_r8h2B | UK002F | 2024-10-25T12:17:22.530Z | 2024-11-01T12:26:55.116Z |
5364401 | 5364401 | 20241023222624_px9XB | UK002F | 2024-10-25T12:17:19.641Z | 2024-11-01T12:26:55.036Z |
5364224 | 5364224 | 20241023221432_RUfUc | UK002F | 2024-10-25T12:17:12.835Z | 2024-11-01T12:26:54.613Z |
5364167 | 5364167 | 20241023221129_lpCVC | UK002F | 2024-10-25T12:17:11.154Z | 2024-11-01T12:26:54.593Z |
5363974 | 5363974 | 20241023220040_Iwjoz | UK002F | 2024-10-25T12:17:04.290Z | 2024-11-01T12:26:54.234Z |
5363943 | 5363943 | 20241023215911_QPQyr | UK002F | 2024-10-25T12:17:02.727Z | 2024-11-01T12:26:54.211Z |
5363874 | 5363874 | 20241023215441_78MY3 | UK002F | 2024-10-25T12:16:57.470Z | 2024-11-01T12:26:54.020Z |
5363867 | 5363867 | 20241023215420_ZIlOn | UK002F | 2024-10-25T12:16:57.160Z | 2024-11-01T12:26:54.018Z |
5363839 | 5363839 | 20241023214958_E7UXZ | UK002F | 2024-10-25T12:16:52.694Z | 2024-11-01T12:26:53.889Z |
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);