participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "USL00D" 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 |
---|---|---|---|---|---|
5505612 | 5505612 | 20241108062409_F97CL | USL00D | 2024-11-09T14:16:25.301Z | 2024-11-09T14:16:28.827Z |
5505570 | 5505570 | 20241108061153_ayqzt | USL00D | 2024-11-09T14:16:23.679Z | 2024-11-09T14:16:28.817Z |
5505567 | 5505567 | 20241108061051_x5xV2 | USL00D | 2024-11-09T14:16:23.602Z | 2024-11-09T14:16:28.816Z |
5505559 | 5505559 | 20241108060841_viytc | USL00D | 2024-11-09T14:16:23.381Z | 2024-11-09T14:16:28.815Z |
5505411 | 5505411 | 20241108050918_11ltS | USL00D | 2024-11-09T14:16:16.503Z | 2024-11-09T14:16:28.777Z |
5505202 | 5505202 | 20241108040721_LoO2A | USL00D | 2024-11-09T14:15:55.198Z | 2024-11-09T14:16:28.724Z |
5505129 | 5505129 | 20241108035642_y9K82 | USL00D | 2024-11-09T14:15:46.550Z | 2024-11-09T14:16:28.707Z |
5504952 | 5504952 | 20241108032435_sIK47 | USL00D | 2024-11-09T14:15:27.125Z | 2024-11-09T14:16:28.665Z |
5504743 | 5504743 | 20241108025106_YODoZ | USL00D | 2024-11-09T14:15:08.447Z | 2024-11-09T14:16:28.614Z |
5504609 | 5504609 | 20241108022257_Pm27V | USL00D | 2024-11-09T14:14:56.749Z | 2024-11-09T14:16:28.582Z |
5504482 | 5504482 | 20241108020440_OrR2C | USL00D | 2024-11-09T14:14:44.134Z | 2024-11-09T14:16:28.550Z |
5504348 | 5504348 | 20241108014435_Qv214 | USL00D | 2024-11-09T14:14:28.193Z | 2024-11-09T14:16:28.513Z |
5499675 | 5499675 | 20241108125531_8D2tJ | USL00D | 2024-11-09T14:04:43.005Z | 2024-11-09T14:04:43.005Z |
5499603 | 5499603 | 20241108124325_Ktaij | USL00D | 2024-11-09T14:04:25.751Z | 2024-11-09T14:04:25.751Z |
5499576 | 5499576 | 20241108123908_Htrsr | USL00D | 2024-11-09T14:04:21.782Z | 2024-11-09T14:04:21.782Z |
5499481 | 5499481 | 20241108122733_TihtQ | USL00D | 2024-11-09T14:04:11.119Z | 2024-11-09T14:04:11.119Z |
5499370 | 5499370 | 20241108120619_YzHKm | USL00D | 2024-11-09T14:03:52.637Z | 2024-11-09T14:03:52.637Z |
5499199 | 5499199 | 20241108113317_VUA3w | USL00D | 2024-11-09T14:03:31.486Z | 2024-11-09T14:03:31.486Z |
5499193 | 5499193 | 20241108113140_ZDSw7 | USL00D | 2024-11-09T14:03:30.941Z | 2024-11-09T14:03:30.941Z |
5499139 | 5499139 | 20241108111748_rvA7d | USL00D | 2024-11-09T14:03:24.547Z | 2024-11-09T14:03:24.547Z |
5499119 | 5499119 | 20241108111159_tkHen | USL00D | 2024-11-09T14:03:15.880Z | 2024-11-09T14:03:15.880Z |
5499024 | 5499024 | 20241108104926_NFwp3 | USL00D | 2024-11-09T14:03:00.379Z | 2024-11-09T14:03:00.379Z |
5498986 | 5498986 | 20241108103930_zQ4v5 | USL00D | 2024-11-09T14:02:55.742Z | 2024-11-09T14:02:55.742Z |
5498948 | 5498948 | 20241108103151_C7M9V | USL00D | 2024-11-09T14:02:49.748Z | 2024-11-09T14:02:49.748Z |
5498893 | 5498893 | 20241108102134_3t2Kv | USL00D | 2024-11-09T14:02:43.504Z | 2024-11-09T14:02:43.504Z |
5498886 | 5498886 | 20241108101822_UgKEP | USL00D | 2024-11-09T14:02:42.501Z | 2024-11-09T14:02:42.501Z |
5498643 | 5498643 | 20241108092906_t0b87 | USL00D | 2024-11-09T14:02:04.571Z | 2024-11-09T14:02:04.571Z |
5498612 | 5498612 | 20241108092115_tKvWJ | USL00D | 2024-11-09T14:01:55.771Z | 2024-11-09T14:01:55.771Z |
5498591 | 5498591 | 20241108091459_1VJVe | USL00D | 2024-11-09T14:01:53.438Z | 2024-11-09T14:01:53.438Z |
5498534 | 5498534 | 20241108085727_0DAxj | USL00D | 2024-11-09T14:01:43.315Z | 2024-11-09T14:01:43.315Z |
5498520 | 5498520 | 20241108085533_vHjQ3 | USL00D | 2024-11-09T14:01:41.598Z | 2024-11-09T14:01:41.598Z |
5498470 | 5498470 | 20241108083806_Yn8pz | USL00D | 2024-11-09T14:01:33.508Z | 2024-11-09T14:01:33.508Z |
5498384 | 5498384 | 20241108082358_vP3XX | USL00D | 2024-11-09T14:01:20.328Z | 2024-11-09T14:01:20.328Z |
5498375 | 5498375 | 20241108082306_s39z3 | USL00D | 2024-11-09T14:01:18.475Z | 2024-11-09T14:01:18.475Z |
5498339 | 5498339 | 20241108081224_OssSP | USL00D | 2024-11-09T14:01:11.028Z | 2024-11-09T14:01:11.028Z |
5498304 | 5498304 | 20241108075538_A8lir | USL00D | 2024-11-09T14:01:05.169Z | 2024-11-09T14:01:05.169Z |
5498294 | 5498294 | 20241108075157_aICCx | USL00D | 2024-11-09T14:01:03.238Z | 2024-11-09T14:01:03.238Z |
5498286 | 5498286 | 20241108075002_EQf3v | USL00D | 2024-11-09T14:01:02.397Z | 2024-11-09T14:01:02.397Z |
5498267 | 5498267 | 20241108074710_4QRDV | USL00D | 2024-11-09T14:00:59.603Z | 2024-11-09T14:00:59.603Z |
5498228 | 5498228 | 20241108073455_JM7mD | USL00D | 2024-11-09T14:00:53.479Z | 2024-11-09T14:00:53.479Z |
5498213 | 5498213 | 20241108073334_Yu7AI | USL00D | 2024-11-09T14:00:51.273Z | 2024-11-09T14:00:51.273Z |
5498154 | 5498154 | 20241108071553_d3sac | USL00D | 2024-11-09T14:00:39.791Z | 2024-11-09T14:00:39.791Z |
5498123 | 5498123 | 20241108070435_gjJq3 | USL00D | 2024-11-09T14:00:35.120Z | 2024-11-09T14:00:35.120Z |
5498106 | 5498106 | 20241108065710_xs4So | USL00D | 2024-11-09T14:00:30.425Z | 2024-11-09T14:00:30.425Z |
5498054 | 5498054 | 20241108063506_iTAji | USL00D | 2024-11-09T14:00:20.213Z | 2024-11-09T14:00:20.213Z |
5498034 | 5498034 | 20241108063100_e228F | USL00D | 2024-11-09T14:00:14.888Z | 2024-11-09T14:00:14.888Z |
5498031 | 5498031 | 20241108062924_3VQQG | USL00D | 2024-11-09T14:00:13.997Z | 2024-11-09T14:00:13.997Z |
5497962 | 5497962 | 20241107062646_fBsHb | USL00D | 2024-11-08T14:14:32.456Z | 2024-11-09T14:18:54.391Z |
5497950 | 5497950 | 20241107061923_6fgPp | USL00D | 2024-11-08T14:14:31.904Z | 2024-11-09T14:18:54.249Z |
5497915 | 5497915 | 20241107060040_OWw9Q | USL00D | 2024-11-08T14:14:30.451Z | 2024-11-09T14:18:53.611Z |
5497910 | 5497910 | 20241107060012_2v0nc | USL00D | 2024-11-08T14:14:30.315Z | 2024-11-09T14:18:53.559Z |
5497899 | 5497899 | 20241107055800_yPEz3 | USL00D | 2024-11-08T14:14:29.709Z | 2024-11-09T14:18:53.442Z |
5497872 | 5497872 | 20241107054036_HhxDT | USL00D | 2024-11-08T14:14:28.552Z | 2024-11-09T14:18:52.964Z |
5497854 | 5497854 | 20241107053502_eBJg5 | USL00D | 2024-11-08T14:14:27.854Z | 2024-11-09T14:18:52.805Z |
5497820 | 5497820 | 20241107052250_q5P32 | USL00D | 2024-11-08T14:14:25.145Z | 2024-11-09T14:18:52.445Z |
5497803 | 5497803 | 20241107051857_HTF3f | USL00D | 2024-11-08T14:14:23.194Z | 2024-11-09T14:18:52.299Z |
5497796 | 5497796 | 20241107051815_HT8VL | USL00D | 2024-11-08T14:14:22.128Z | 2024-11-09T14:18:52.159Z |
5497679 | 5497679 | 20241107042735_U20dc | USL00D | 2024-11-08T14:14:10.318Z | 2024-11-09T14:18:50.425Z |
5497572 | 5497572 | 20241107040206_Antia | USL00D | 2024-11-08T14:13:59.339Z | 2024-11-09T14:18:46.399Z |
5497500 | 5497500 | 20241107035040_a5dTb | USL00D | 2024-11-08T14:13:54.599Z | 2024-11-09T14:18:44.818Z |
5497310 | 5497310 | 20241107031958_Zsx2J | USL00D | 2024-11-08T14:13:31.720Z | 2024-11-09T14:18:40.574Z |
5497097 | 5497097 | 20241107024144_7whu4 | USL00D | 2024-11-08T14:13:09.984Z | 2024-11-09T14:18:35.504Z |
5496957 | 5496957 | 20241107021822_6ZIk9 | USL00D | 2024-11-08T14:13:00.842Z | 2024-11-09T14:18:33.581Z |
5493660 | 5493660 | 20241107125626_1ItMX | USL00D | 2024-11-08T14:04:26.877Z | 2024-11-09T14:16:27.687Z |
5493591 | 5493591 | 20241107124334_wz7c0 | USL00D | 2024-11-08T14:04:13.201Z | 2024-11-09T14:16:27.668Z |
5493523 | 5493523 | 20241107122511_6QPK2 | USL00D | 2024-11-08T14:03:58.330Z | 2024-11-09T14:16:27.646Z |
5493385 | 5493385 | 20241107120121_f2X8u | USL00D | 2024-11-08T14:03:40.085Z | 2024-11-09T14:16:27.608Z |
5493373 | 5493373 | 20241107115925_3yVv3 | USL00D | 2024-11-08T14:03:38.474Z | 2024-11-09T14:16:27.604Z |
5493324 | 5493324 | 20241107114847_M5Xh8 | USL00D | 2024-11-08T14:03:33.573Z | 2024-11-09T14:16:27.588Z |
5493153 | 5493153 | 20241107110848_9y29i | USL00D | 2024-11-08T14:02:59.062Z | 2024-11-09T14:16:27.548Z |
5492913 | 5492913 | 20241107101950_0fWSN | USL00D | 2024-11-08T14:02:33.171Z | 2024-11-09T14:16:27.486Z |
5492847 | 5492847 | 20241107100509_ydlz2 | USL00D | 2024-11-08T14:02:13.690Z | 2024-11-09T14:16:27.468Z |
5492795 | 5492795 | 20241107095648_O9uPK | USL00D | 2024-11-08T14:02:06.418Z | 2024-11-09T14:16:27.456Z |
5492705 | 5492705 | 20241107093506_rxoMR | USL00D | 2024-11-08T14:01:55.717Z | 2024-11-09T14:16:27.432Z |
5492682 | 5492682 | 20241107093100_F4BIx | USL00D | 2024-11-08T14:01:53.569Z | 2024-11-09T14:16:27.428Z |
5492662 | 5492662 | 20241107092559_3enSE | USL00D | 2024-11-08T14:01:49.970Z | 2024-11-09T14:16:27.423Z |
5492639 | 5492639 | 20241107092206_RywMp | USL00D | 2024-11-08T14:01:41.981Z | 2024-11-09T14:16:27.418Z |
5492483 | 5492483 | 20241107084052_eQSiV | USL00D | 2024-11-08T14:01:16.017Z | 2024-11-09T14:16:27.383Z |
5492456 | 5492456 | 20241107083706_3kGfx | USL00D | 2024-11-08T14:01:13.625Z | 2024-11-09T14:16:27.378Z |
5492425 | 5492425 | 20241107083206_qMsWU | USL00D | 2024-11-08T14:01:04.519Z | 2024-11-09T14:16:27.369Z |
5492363 | 5492363 | 20241107081605_Tpw6P | USL00D | 2024-11-08T14:00:52.798Z | 2024-11-09T14:16:27.355Z |
5492252 | 5492252 | 20241107074705_fiJcL | USL00D | 2024-11-08T14:00:37.803Z | 2024-11-09T14:16:27.328Z |
5492227 | 5492227 | 20241107073759_TIJEQ | USL00D | 2024-11-08T14:00:34.624Z | 2024-11-09T14:16:27.322Z |
5492218 | 5492218 | 20241107073335_C9o7C | USL00D | 2024-11-08T14:00:33.416Z | 2024-11-09T14:16:27.318Z |
5492203 | 5492203 | 20241107072658_DF232 | USL00D | 2024-11-08T14:00:28.443Z | 2024-11-09T14:16:27.313Z |
5492174 | 5492174 | 20241107071933_fWwq4 | USL00D | 2024-11-08T14:00:23.514Z | 2024-11-09T14:16:27.303Z |
5492122 | 5492122 | 20241107065147_ny3oz | USL00D | 2024-11-08T14:00:15.279Z | 2024-11-09T14:16:27.282Z |
5492091 | 5492091 | 20241107063213_9RGL2 | USL00D | 2024-11-08T14:00:09.482Z | 2024-11-09T14:16:27.268Z |
5491932 | 5491932 | 20241106062725_MoY3o | USL00D | 2024-11-07T14:17:19.961Z | 2024-11-09T14:20:16.303Z |
5491923 | 5491923 | 20241106062247_pO627 | USL00D | 2024-11-07T14:17:19.626Z | 2024-11-09T14:20:16.236Z |
5491886 | 5491886 | 20241106060043_baEhY | USL00D | 2024-11-07T14:17:17.394Z | 2024-11-09T14:20:15.829Z |
5491846 | 5491846 | 20241106053228_2zl0K | USL00D | 2024-11-07T14:17:10.247Z | 2024-11-09T14:20:15.367Z |
5491831 | 5491831 | 20241106052623_mYN2k | USL00D | 2024-11-07T14:17:06.577Z | 2024-11-09T14:20:15.246Z |
5491784 | 5491784 | 20241106050947_s125G | USL00D | 2024-11-07T14:16:59.257Z | 2024-11-09T14:20:14.643Z |
5491767 | 5491767 | 20241106050544_sU2nE | USL00D | 2024-11-07T14:16:56.640Z | 2024-11-09T14:20:14.386Z |
5491679 | 5491679 | 20241106042710_8bAMT | USL00D | 2024-11-07T14:16:44.181Z | 2024-11-09T14:20:12.760Z |
5486658 | 5486658 | 20241106124414_iePJO | USL00D | 2024-11-07T14:03:42.316Z | 2024-11-09T14:16:53.412Z |
5485876 | 5485876 | 20241106081156_MV2uV | USL00D | 2024-11-07T14:00:57.850Z | 2024-11-09T14:16:33.819Z |
5485860 | 5485860 | 20241106080619_gOjrP | USL00D | 2024-11-07T14:00:52.570Z | 2024-11-09T14:16:33.600Z |
5485762 | 5485762 | 20241106072149_UtfyO | USL00D | 2024-11-07T14:00:31.579Z | 2024-11-09T14:16:31.854Z |
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);