participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "SI0002" 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 |
---|---|---|---|---|---|
5496224 | 5496224 | 20241106233014_vPoqr | SI0002 | 2024-11-08T14:11:47.958Z | 2024-11-12T14:26:02.664Z |
5496130 | 5496130 | 20241106230407_OHRle | SI0002 | 2024-11-08T14:11:36.950Z | 2024-11-12T14:26:01.940Z |
5496095 | 5496095 | 20241106225430_Euo9p | SI0002 | 2024-11-08T14:11:33.564Z | 2024-11-12T14:26:01.576Z |
5496062 | 5496062 | 20241106224956_RZFHN | SI0002 | 2024-11-08T14:11:28.960Z | 2024-11-12T14:26:01.168Z |
5495921 | 5495921 | 20241106220556_O3lqH | SI0002 | 2024-11-08T14:11:08.197Z | 2024-11-12T14:25:59.984Z |
5495834 | 5495834 | 20241106214236_uR4A4 | SI0002 | 2024-11-08T14:10:57.751Z | 2024-11-12T14:25:58.212Z |
5495490 | 5495490 | 20241106200130_tbX88 | SI0002 | 2024-11-08T14:10:17.900Z | 2024-11-12T14:25:54.293Z |
5495233 | 5495233 | 20241106190257_jUzt2 | SI0002 | 2024-11-08T14:09:42.340Z | 2024-11-12T14:25:50.997Z |
5495081 | 5495081 | 20241106183300_lK4el | SI0002 | 2024-11-08T14:09:14.537Z | 2024-11-12T14:25:48.840Z |
5491669 | 5491669 | 20241106041950_CbEuC | SI0002 | 2024-11-07T14:16:42.718Z | 2024-11-12T14:26:55.599Z |
5491654 | 5491654 | 20241106041537_wbs4J | SI0002 | 2024-11-07T14:16:38.765Z | 2024-11-12T14:26:55.559Z |
5491652 | 5491652 | 20241106041438_HFHH5 | SI0002 | 2024-11-07T14:16:38.425Z | 2024-11-12T14:26:55.543Z |
5491191 | 5491191 | 20241106021932_Rw2zo | SI0002 | 2024-11-07T14:15:26.515Z | 2024-11-12T14:26:53.445Z |
5491171 | 5491171 | 20241106021559_i1u3K | SI0002 | 2024-11-07T14:15:24.381Z | 2024-11-12T14:26:53.362Z |
5491044 | 5491044 | 20241106014300_wCvGT | SI0002 | 2024-11-07T14:15:15.041Z | 2024-11-12T14:26:52.762Z |
5490932 | 5490932 | 20241106011728_MJvhH | SI0002 | 2024-11-07T14:15:05.981Z | 2024-11-12T14:26:51.999Z |
5490927 | 5490927 | 20241106011533_u0H88 | SI0002 | 2024-11-07T14:15:05.851Z | 2024-11-12T14:26:51.996Z |
5490909 | 5490909 | 20241106010958_D0li7 | SI0002 | 2024-11-07T14:15:04.651Z | 2024-11-12T14:26:51.961Z |
5490882 | 5490882 | 20241106010408_cc72h | SI0002 | 2024-11-07T14:15:02.349Z | 2024-11-12T14:26:51.865Z |
5490709 | 5490709 | 20241106001446_RQe1I | SI0002 | 2024-11-07T14:14:36.411Z | 2024-11-12T14:26:50.828Z |
5490559 | 5490559 | 20241105232810_OTxKu | SI0002 | 2024-11-07T14:14:12.480Z | 2024-11-12T14:26:49.619Z |
5490478 | 5490478 | 20241105225928_ZOaBr | SI0002 | 2024-11-07T14:14:04.969Z | 2024-11-12T14:26:48.611Z |
5490352 | 5490352 | 20241105221910_E707h | SI0002 | 2024-11-07T14:13:54.608Z | 2024-11-12T14:26:47.872Z |
5490283 | 5490283 | 20241105220054_ZfApM | SI0002 | 2024-11-07T14:13:48.614Z | 2024-11-12T14:26:47.639Z |
5490201 | 5490201 | 20241105213845_DUVgg | SI0002 | 2024-11-07T14:13:33.594Z | 2024-11-12T14:26:47.228Z |
5490182 | 5490182 | 20241105213225_ZtLCI | SI0002 | 2024-11-07T14:13:30.662Z | 2024-11-12T14:26:47.105Z |
5490154 | 5490154 | 20241105212407_eMZ2I | SI0002 | 2024-11-07T14:13:21.419Z | 2024-11-12T14:26:46.728Z |
5490056 | 5490056 | 20241105204950_TaY93 | SI0002 | 2024-11-07T14:13:07.223Z | 2024-11-12T14:26:46.016Z |
5489627 | 5489627 | 20241105192902_eaXRD | SI0002 | 2024-11-07T14:12:21.098Z | 2024-11-12T14:26:44.197Z |
5489292 | 5489292 | 20241105183218_jbQ1c | SI0002 | 2024-11-07T14:11:51.024Z | 2024-11-12T14:26:41.967Z |
5489183 | 5489183 | 20241105180307_5bTuq | SI0002 | 2024-11-07T14:11:25.706Z | 2024-11-12T14:26:40.260Z |
5489073 | 5489073 | 20241105174557_yZtJ3 | SI0002 | 2024-11-07T14:11:16.114Z | 2024-11-12T14:26:38.679Z |
5489039 | 5489039 | 20241105174016_yepzs | SI0002 | 2024-11-07T14:11:13.587Z | 2024-11-12T14:26:38.336Z |
5489023 | 5489023 | 20241105173728_X5xLf | SI0002 | 2024-11-07T14:11:11.979Z | 2024-11-12T14:26:37.935Z |
5488760 | 5488760 | 20241105164737_Azfzn | SI0002 | 2024-11-07T14:10:36.085Z | 2024-11-12T14:26:35.370Z |
5488729 | 5488729 | 20241105163833_gm1sd | SI0002 | 2024-11-07T14:10:32.485Z | 2024-11-12T14:26:35.265Z |
5485282 | 5485282 | 20241105043721_3H3Fg | SI0002 | 2024-11-06T14:18:03.114Z | 2024-11-12T14:27:38.077Z |
5485257 | 5485257 | 20241105043054_Wlrnx | SI0002 | 2024-11-06T14:17:59.668Z | 2024-11-12T14:27:37.873Z |
5485170 | 5485170 | 20241105041400_Xgfo9 | SI0002 | 2024-11-06T14:17:51.267Z | 2024-11-12T14:27:37.296Z |
5485160 | 5485160 | 20241105041318_32a2A | SI0002 | 2024-11-06T14:17:50.712Z | 2024-11-12T14:27:37.093Z |
5485090 | 5485090 | 20241105040218_m13vg | SI0002 | 2024-11-06T14:17:44.204Z | 2024-11-12T14:27:36.659Z |
5485083 | 5485083 | 20241105040150_UFTYc | SI0002 | 2024-11-06T14:17:43.883Z | 2024-11-12T14:27:36.643Z |
5485075 | 5485075 | 20241105040117_NTHDa | SI0002 | 2024-11-06T14:17:43.632Z | 2024-11-12T14:27:36.628Z |
5485030 | 5485030 | 20241105035528_90Gcx | SI0002 | 2024-11-06T14:17:40.027Z | 2024-11-12T14:27:36.281Z |
5485024 | 5485024 | 20241105035448_XzpUR | SI0002 | 2024-11-06T14:17:39.761Z | 2024-11-12T14:27:36.258Z |
5485003 | 5485003 | 20241105035300_x3uZW | SI0002 | 2024-11-06T14:17:37.881Z | 2024-11-12T14:27:36.225Z |
5484979 | 5484979 | 20241105035015_BdIEP | SI0002 | 2024-11-06T14:17:35.073Z | 2024-11-12T14:27:36.122Z |
5484910 | 5484910 | 20241105034044_SY2j7 | SI0002 | 2024-11-06T14:17:28.663Z | 2024-11-12T14:27:35.859Z |
5484900 | 5484900 | 20241105033847_UEseX | SI0002 | 2024-11-06T14:17:27.255Z | 2024-11-12T14:27:35.791Z |
5484843 | 5484843 | 20241105033327_6lAKn | SI0002 | 2024-11-06T14:17:22.469Z | 2024-11-12T14:27:35.634Z |
5484839 | 5484839 | 20241105033324_Mw3Yd | SI0002 | 2024-11-06T14:17:22.141Z | 2024-11-12T14:27:35.630Z |
5484836 | 5484836 | 20241105033308_eeQ1P | SI0002 | 2024-11-06T14:17:22.010Z | 2024-11-12T14:27:35.625Z |
5484795 | 5484795 | 20241105033046_Xf04x | SI0002 | 2024-11-06T14:17:18.092Z | 2024-11-12T14:27:35.522Z |
5484726 | 5484726 | 20241105032242_z0vjl | SI0002 | 2024-11-06T14:17:12.186Z | 2024-11-12T14:27:35.338Z |
5484708 | 5484708 | 20241105032125_x2UOK | SI0002 | 2024-11-06T14:17:10.684Z | 2024-11-12T14:27:35.321Z |
5484696 | 5484696 | 20241105032028_em2GT | SI0002 | 2024-11-06T14:17:10.400Z | 2024-11-12T14:27:35.291Z |
5484653 | 5484653 | 20241105031712_Efe3X | SI0002 | 2024-11-06T14:17:08.041Z | 2024-11-12T14:27:35.084Z |
5484585 | 5484585 | 20241105030652_Y3pP4 | SI0002 | 2024-11-06T14:17:02.662Z | 2024-11-12T14:27:34.763Z |
5484562 | 5484562 | 20241105030450_v1Ttk | SI0002 | 2024-11-06T14:17:00.923Z | 2024-11-12T14:27:34.653Z |
5484547 | 5484547 | 20241105030310_NbTSn | SI0002 | 2024-11-06T14:17:00.269Z | 2024-11-12T14:27:34.592Z |
5484537 | 5484537 | 20241105030230_Mofdr | SI0002 | 2024-11-06T14:16:59.916Z | 2024-11-12T14:27:34.587Z |
5484428 | 5484428 | 20241105024818_hRfgv | SI0002 | 2024-11-06T14:16:53.839Z | 2024-11-12T14:27:33.798Z |
5484370 | 5484370 | 20241105024058_ShPxd | SI0002 | 2024-11-06T14:16:51.121Z | 2024-11-12T14:27:33.625Z |
5484302 | 5484302 | 20241105023224_0l7xe | SI0002 | 2024-11-06T14:16:47.109Z | 2024-11-12T14:27:33.453Z |
5484273 | 5484273 | 20241105022935_6Yk8h | SI0002 | 2024-11-06T14:16:41.946Z | 2024-11-12T14:27:32.960Z |
5484213 | 5484213 | 20241105022125_PPmCf | SI0002 | 2024-11-06T14:16:32.670Z | 2024-11-12T14:27:32.718Z |
5484209 | 5484209 | 20241105022110_Gm2Qp | SI0002 | 2024-11-06T14:16:32.174Z | 2024-11-12T14:27:32.717Z |
5484178 | 5484178 | 20241105021740_NWNBO | SI0002 | 2024-11-06T14:16:26.466Z | 2024-11-12T14:27:32.485Z |
5484154 | 5484154 | 20241105021457_Dm3rB | SI0002 | 2024-11-06T14:16:22.994Z | 2024-11-12T14:27:32.241Z |
5484123 | 5484123 | 20241105021207_W1v3J | SI0002 | 2024-11-06T14:16:20.162Z | 2024-11-12T14:27:32.131Z |
5483989 | 5483989 | 20241105015154_FvCBv | SI0002 | 2024-11-06T14:16:00.815Z | 2024-11-12T14:27:31.014Z |
5483986 | 5483986 | 20241105015135_t24Ya | SI0002 | 2024-11-06T14:16:00.586Z | 2024-11-12T14:27:31.004Z |
5483982 | 5483982 | 20241105015058_KIzIX | SI0002 | 2024-11-06T14:16:00.042Z | 2024-11-12T14:27:30.832Z |
5483973 | 5483973 | 20241105015022_TPTNF | SI0002 | 2024-11-06T14:15:59.160Z | 2024-11-12T14:27:30.810Z |
5483838 | 5483838 | 20241105013647_IpGRy | SI0002 | 2024-11-06T14:15:45.323Z | 2024-11-12T14:27:30.387Z |
5483822 | 5483822 | 20241105013521_OD2wv | SI0002 | 2024-11-06T14:15:44.697Z | 2024-11-12T14:27:30.363Z |
5483809 | 5483809 | 20241105013325_nzg0m | SI0002 | 2024-11-06T14:15:44.154Z | 2024-11-12T14:27:30.347Z |
5483784 | 5483784 | 20241105013034_u3g3w | SI0002 | 2024-11-06T14:15:42.464Z | 2024-11-12T14:27:30.165Z |
5483727 | 5483727 | 20241105012432_anyQr | SI0002 | 2024-11-06T14:15:38.310Z | 2024-11-12T14:27:29.866Z |
5483599 | 5483599 | 20241105010312_lOr2n | SI0002 | 2024-11-06T14:15:30.796Z | 2024-11-12T14:27:29.041Z |
5483578 | 5483578 | 20241105005935_LLJxl | SI0002 | 2024-11-06T14:15:29.611Z | 2024-11-12T14:27:28.969Z |
5483537 | 5483537 | 20241105005428_3zL1n | SI0002 | 2024-11-06T14:15:27.401Z | 2024-11-12T14:27:28.680Z |
5483523 | 5483523 | 20241105005220_UB2EQ | SI0002 | 2024-11-06T14:15:26.618Z | 2024-11-12T14:27:28.509Z |
5483503 | 5483503 | 20241105004711_9lJso | SI0002 | 2024-11-06T14:15:25.634Z | 2024-11-12T14:27:28.420Z |
5483479 | 5483479 | 20241105004446_yGtdm | SI0002 | 2024-11-06T14:15:24.367Z | 2024-11-12T14:27:28.256Z |
5483439 | 5483439 | 20241105004123_qXhDU | SI0002 | 2024-11-06T14:15:17.816Z | 2024-11-12T14:27:28.118Z |
5483413 | 5483413 | 20241105003804_ZbF1e | SI0002 | 2024-11-06T14:15:13.893Z | 2024-11-12T14:27:28.060Z |
5483362 | 5483362 | 20241105003051_9J8Z8 | SI0002 | 2024-11-06T14:15:03.626Z | 2024-11-12T14:27:27.784Z |
5483343 | 5483343 | 20241105002810_zBpMp | SI0002 | 2024-11-06T14:15:00.947Z | 2024-11-12T14:27:27.742Z |
5483281 | 5483281 | 20241105002255_hMWiP | SI0002 | 2024-11-06T14:14:52.871Z | 2024-11-12T14:27:27.500Z |
5483275 | 5483275 | 20241105002122_x46OS | SI0002 | 2024-11-06T14:14:51.721Z | 2024-11-12T14:27:27.468Z |
5483230 | 5483230 | 20241105001605_RkfN2 | SI0002 | 2024-11-06T14:14:48.616Z | 2024-11-12T14:27:27.274Z |
5483201 | 5483201 | 20241105001144_m6nId | SI0002 | 2024-11-06T14:14:45.841Z | 2024-11-12T14:27:27.087Z |
5483144 | 5483144 | 20241105000249_dAB6E | SI0002 | 2024-11-06T14:14:42.263Z | 2024-11-12T14:27:26.332Z |
5483122 | 5483122 | 20241105000016_sOlJV | SI0002 | 2024-11-06T14:14:40.929Z | 2024-11-12T14:27:26.096Z |
5483087 | 5483087 | 20241104235645_x4gHI | SI0002 | 2024-11-06T14:14:39.380Z | 2024-11-12T14:27:25.726Z |
5483038 | 5483038 | 20241104234904_kJtoM | SI0002 | 2024-11-06T14:14:35.827Z | 2024-11-12T14:27:25.355Z |
5483020 | 5483020 | 20241104234836_33Zz4 | SI0002 | 2024-11-06T14:14:35.071Z | 2024-11-12T14:27:25.258Z |
5483010 | 5483010 | 20241104234748_9JkeN | SI0002 | 2024-11-06T14:14:34.544Z | 2024-11-12T14:27:25.172Z |
5482970 | 5482970 | 20241104234158_RjoTQ | SI0002 | 2024-11-06T14:14:31.852Z | 2024-11-12T14:27:25.049Z |
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);