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 |
---|---|---|---|---|---|
5553943 | 5553943 | 20241117022952_WORJN | SI0002 | 2024-11-19T14:13:25.892Z | 2024-11-22T14:23:17.286Z |
5548987 | 5548987 | 20241117023456_5rMNX | SI0002 | 2024-11-18T14:10:35.557Z | 2024-11-22T14:23:17.410Z |
5548955 | 5548955 | 20241117022801_2OjYU | SI0002 | 2024-11-18T14:10:32.587Z | 2024-11-22T14:23:17.273Z |
5548904 | 5548904 | 20241117021122_mLuNQ | SI0002 | 2024-11-18T14:10:24.832Z | 2024-11-22T14:23:16.756Z |
5548877 | 5548877 | 20241117020427_uLbD6 | SI0002 | 2024-11-18T14:10:22.132Z | 2024-11-22T14:23:16.612Z |
5548802 | 5548802 | 20241117014245_m9jyR | SI0002 | 2024-11-18T14:10:14.305Z | 2024-11-22T14:23:15.885Z |
5548783 | 5548783 | 20241117014039_cTc2z | SI0002 | 2024-11-18T14:10:12.539Z | 2024-11-22T14:23:15.759Z |
5548742 | 5548742 | 20241117012415_z8Ga4 | SI0002 | 2024-11-18T14:10:08.222Z | 2024-11-22T14:23:15.378Z |
5548693 | 5548693 | 20241117011050_PHZpA | SI0002 | 2024-11-18T14:09:55.692Z | 2024-11-22T14:23:15.158Z |
5548631 | 5548631 | 20241117004100_HISLU | SI0002 | 2024-11-18T14:09:39.424Z | 2024-11-22T14:23:14.749Z |
5548628 | 5548628 | 20241117004048_Pbj5t | SI0002 | 2024-11-18T14:09:38.941Z | 2024-11-22T14:23:14.743Z |
5548612 | 5548612 | 20241117003207_V05gJ | SI0002 | 2024-11-18T14:09:35.130Z | 2024-11-22T14:23:14.615Z |
5548595 | 5548595 | 20241117002934_VQkA2 | SI0002 | 2024-11-18T14:09:33.318Z | 2024-11-22T14:23:14.497Z |
5548558 | 5548558 | 20241117001730_NaJ3V | SI0002 | 2024-11-18T14:09:27.951Z | 2024-11-22T14:23:14.329Z |
5548437 | 5548437 | 20241116233157_fXY33 | SI0002 | 2024-11-18T14:09:13.243Z | 2024-11-22T14:23:13.094Z |
5548381 | 5548381 | 20241116230104_4DASC | SI0002 | 2024-11-18T14:09:03.166Z | 2024-11-22T14:23:12.446Z |
5545330 | 5545330 | 20241116044817_2jxoD | SI0002 | 2024-11-17T14:04:28.934Z | 2024-11-22T14:23:39.897Z |
5545323 | 5545323 | 20241116043606_oGjAD | SI0002 | 2024-11-17T14:04:28.047Z | 2024-11-22T14:23:39.851Z |
5543929 | 5543929 | 20241115044112_R7dm8 | SI0002 | 2024-11-16T14:07:41.163Z | 2024-11-22T14:24:02.560Z |
5543810 | 5543810 | 20241115033920_feGmx | SI0002 | 2024-11-16T14:07:16.460Z | 2024-11-22T14:24:01.684Z |
5543533 | 5543533 | 20241115015912_qR6r0 | SI0002 | 2024-11-16T14:06:36.373Z | 2024-11-22T14:23:59.914Z |
5543474 | 5543474 | 20241115013744_aI5AI | SI0002 | 2024-11-16T14:06:26.901Z | 2024-11-22T14:23:59.423Z |
5543460 | 5543460 | 20241115012926_RbndJ | SI0002 | 2024-11-16T14:06:24.581Z | 2024-11-22T14:23:59.378Z |
5543408 | 5543408 | 20241115011057_l9su2 | SI0002 | 2024-11-16T14:06:15.041Z | 2024-11-22T14:23:58.868Z |
5543331 | 5543331 | 20241115001646_HnJK1 | SI0002 | 2024-11-16T14:06:06.546Z | 2024-11-22T14:23:58.290Z |
5496224 | 5496224 | 20241106233014_vPoqr | SI0002 | 2024-11-08T14:11:47.958Z | 2024-11-15T14:24:56.196Z |
5496130 | 5496130 | 20241106230407_OHRle | SI0002 | 2024-11-08T14:11:36.950Z | 2024-11-15T14:24:55.507Z |
5496095 | 5496095 | 20241106225430_Euo9p | SI0002 | 2024-11-08T14:11:33.564Z | 2024-11-15T14:24:55.365Z |
5496062 | 5496062 | 20241106224956_RZFHN | SI0002 | 2024-11-08T14:11:28.960Z | 2024-11-15T14:24:55.121Z |
5495921 | 5495921 | 20241106220556_O3lqH | SI0002 | 2024-11-08T14:11:08.197Z | 2024-11-15T14:24:54.078Z |
5495834 | 5495834 | 20241106214236_uR4A4 | SI0002 | 2024-11-08T14:10:57.751Z | 2024-11-15T14:24:53.473Z |
5495490 | 5495490 | 20241106200130_tbX88 | SI0002 | 2024-11-08T14:10:17.900Z | 2024-11-15T14:24:49.920Z |
5495233 | 5495233 | 20241106190257_jUzt2 | SI0002 | 2024-11-08T14:09:42.340Z | 2024-11-15T14:24:47.505Z |
5495081 | 5495081 | 20241106183300_lK4el | SI0002 | 2024-11-08T14:09:14.537Z | 2024-11-15T14:24:46.263Z |
5491669 | 5491669 | 20241106041950_CbEuC | SI0002 | 2024-11-07T14:16:42.718Z | 2024-11-14T14:23:26.396Z |
5491654 | 5491654 | 20241106041537_wbs4J | SI0002 | 2024-11-07T14:16:38.765Z | 2024-11-14T14:23:26.380Z |
5491652 | 5491652 | 20241106041438_HFHH5 | SI0002 | 2024-11-07T14:16:38.425Z | 2024-11-14T14:23:26.379Z |
5491191 | 5491191 | 20241106021932_Rw2zo | SI0002 | 2024-11-07T14:15:26.515Z | 2024-11-14T14:23:24.553Z |
5491171 | 5491171 | 20241106021559_i1u3K | SI0002 | 2024-11-07T14:15:24.381Z | 2024-11-14T14:23:24.147Z |
5491044 | 5491044 | 20241106014300_wCvGT | SI0002 | 2024-11-07T14:15:15.041Z | 2024-11-14T14:23:23.364Z |
5490932 | 5490932 | 20241106011728_MJvhH | SI0002 | 2024-11-07T14:15:05.981Z | 2024-11-14T14:23:22.959Z |
5490927 | 5490927 | 20241106011533_u0H88 | SI0002 | 2024-11-07T14:15:05.851Z | 2024-11-14T14:23:22.955Z |
5490909 | 5490909 | 20241106010958_D0li7 | SI0002 | 2024-11-07T14:15:04.651Z | 2024-11-14T14:23:22.864Z |
5490882 | 5490882 | 20241106010408_cc72h | SI0002 | 2024-11-07T14:15:02.349Z | 2024-11-14T14:23:22.686Z |
5490709 | 5490709 | 20241106001446_RQe1I | SI0002 | 2024-11-07T14:14:36.411Z | 2024-11-14T14:23:21.321Z |
5490559 | 5490559 | 20241105232810_OTxKu | SI0002 | 2024-11-07T14:14:12.480Z | 2024-11-14T14:23:20.822Z |
5490478 | 5490478 | 20241105225928_ZOaBr | SI0002 | 2024-11-07T14:14:04.969Z | 2024-11-14T14:23:20.591Z |
5490352 | 5490352 | 20241105221910_E707h | SI0002 | 2024-11-07T14:13:54.608Z | 2024-11-14T14:23:19.048Z |
5490283 | 5490283 | 20241105220054_ZfApM | SI0002 | 2024-11-07T14:13:48.614Z | 2024-11-14T14:23:18.676Z |
5490201 | 5490201 | 20241105213845_DUVgg | SI0002 | 2024-11-07T14:13:33.594Z | 2024-11-14T14:23:18.135Z |
5490182 | 5490182 | 20241105213225_ZtLCI | SI0002 | 2024-11-07T14:13:30.662Z | 2024-11-14T14:23:18.060Z |
5490154 | 5490154 | 20241105212407_eMZ2I | SI0002 | 2024-11-07T14:13:21.419Z | 2024-11-14T14:23:17.824Z |
5490056 | 5490056 | 20241105204950_TaY93 | SI0002 | 2024-11-07T14:13:07.223Z | 2024-11-14T14:23:17.386Z |
5489627 | 5489627 | 20241105192902_eaXRD | SI0002 | 2024-11-07T14:12:21.098Z | 2024-11-14T14:23:14.308Z |
5489292 | 5489292 | 20241105183218_jbQ1c | SI0002 | 2024-11-07T14:11:51.024Z | 2024-11-14T14:23:11.906Z |
5489183 | 5489183 | 20241105180307_5bTuq | SI0002 | 2024-11-07T14:11:25.706Z | 2024-11-14T14:23:10.808Z |
5489073 | 5489073 | 20241105174557_yZtJ3 | SI0002 | 2024-11-07T14:11:16.114Z | 2024-11-14T14:23:10.259Z |
5489039 | 5489039 | 20241105174016_yepzs | SI0002 | 2024-11-07T14:11:13.587Z | 2024-11-14T14:23:09.740Z |
5489023 | 5489023 | 20241105173728_X5xLf | SI0002 | 2024-11-07T14:11:11.979Z | 2024-11-14T14:23:09.459Z |
5488760 | 5488760 | 20241105164737_Azfzn | SI0002 | 2024-11-07T14:10:36.085Z | 2024-11-14T14:23:07.690Z |
5488729 | 5488729 | 20241105163833_gm1sd | SI0002 | 2024-11-07T14:10:32.485Z | 2024-11-14T14:23:07.308Z |
5485282 | 5485282 | 20241105043721_3H3Fg | SI0002 | 2024-11-06T14:18:03.114Z | 2024-11-13T14:27:41.545Z |
5485257 | 5485257 | 20241105043054_Wlrnx | SI0002 | 2024-11-06T14:17:59.668Z | 2024-11-13T14:27:41.431Z |
5485170 | 5485170 | 20241105041400_Xgfo9 | SI0002 | 2024-11-06T14:17:51.267Z | 2024-11-13T14:27:40.909Z |
5485160 | 5485160 | 20241105041318_32a2A | SI0002 | 2024-11-06T14:17:50.712Z | 2024-11-13T14:27:40.885Z |
5485090 | 5485090 | 20241105040218_m13vg | SI0002 | 2024-11-06T14:17:44.204Z | 2024-11-13T14:27:40.612Z |
5485083 | 5485083 | 20241105040150_UFTYc | SI0002 | 2024-11-06T14:17:43.883Z | 2024-11-13T14:27:40.610Z |
5485075 | 5485075 | 20241105040117_NTHDa | SI0002 | 2024-11-06T14:17:43.632Z | 2024-11-13T14:27:40.598Z |
5485030 | 5485030 | 20241105035528_90Gcx | SI0002 | 2024-11-06T14:17:40.027Z | 2024-11-13T14:27:40.475Z |
5485024 | 5485024 | 20241105035448_XzpUR | SI0002 | 2024-11-06T14:17:39.761Z | 2024-11-13T14:27:40.466Z |
5485003 | 5485003 | 20241105035300_x3uZW | SI0002 | 2024-11-06T14:17:37.881Z | 2024-11-13T14:27:40.452Z |
5484979 | 5484979 | 20241105035015_BdIEP | SI0002 | 2024-11-06T14:17:35.073Z | 2024-11-13T14:27:40.410Z |
5484910 | 5484910 | 20241105034044_SY2j7 | SI0002 | 2024-11-06T14:17:28.663Z | 2024-11-13T14:27:40.079Z |
5484900 | 5484900 | 20241105033847_UEseX | SI0002 | 2024-11-06T14:17:27.255Z | 2024-11-13T14:27:40.051Z |
5484843 | 5484843 | 20241105033327_6lAKn | SI0002 | 2024-11-06T14:17:22.469Z | 2024-11-13T14:27:39.944Z |
5484839 | 5484839 | 20241105033324_Mw3Yd | SI0002 | 2024-11-06T14:17:22.141Z | 2024-11-13T14:27:39.941Z |
5484836 | 5484836 | 20241105033308_eeQ1P | SI0002 | 2024-11-06T14:17:22.010Z | 2024-11-13T14:27:39.931Z |
5484795 | 5484795 | 20241105033046_Xf04x | SI0002 | 2024-11-06T14:17:18.092Z | 2024-11-13T14:27:39.877Z |
5484726 | 5484726 | 20241105032242_z0vjl | SI0002 | 2024-11-06T14:17:12.186Z | 2024-11-13T14:27:39.441Z |
5484708 | 5484708 | 20241105032125_x2UOK | SI0002 | 2024-11-06T14:17:10.684Z | 2024-11-13T14:27:39.405Z |
5484696 | 5484696 | 20241105032028_em2GT | SI0002 | 2024-11-06T14:17:10.400Z | 2024-11-13T14:27:39.358Z |
5484653 | 5484653 | 20241105031712_Efe3X | SI0002 | 2024-11-06T14:17:08.041Z | 2024-11-13T14:27:38.998Z |
5484585 | 5484585 | 20241105030652_Y3pP4 | SI0002 | 2024-11-06T14:17:02.662Z | 2024-11-13T14:27:38.659Z |
5484562 | 5484562 | 20241105030450_v1Ttk | SI0002 | 2024-11-06T14:17:00.923Z | 2024-11-13T14:27:38.630Z |
5484547 | 5484547 | 20241105030310_NbTSn | SI0002 | 2024-11-06T14:17:00.269Z | 2024-11-13T14:27:38.574Z |
5484537 | 5484537 | 20241105030230_Mofdr | SI0002 | 2024-11-06T14:16:59.916Z | 2024-11-13T14:27:38.571Z |
5484428 | 5484428 | 20241105024818_hRfgv | SI0002 | 2024-11-06T14:16:53.839Z | 2024-11-13T14:27:37.983Z |
5484370 | 5484370 | 20241105024058_ShPxd | SI0002 | 2024-11-06T14:16:51.121Z | 2024-11-13T14:27:37.793Z |
5484302 | 5484302 | 20241105023224_0l7xe | SI0002 | 2024-11-06T14:16:47.109Z | 2024-11-13T14:27:37.672Z |
5484273 | 5484273 | 20241105022935_6Yk8h | SI0002 | 2024-11-06T14:16:41.946Z | 2024-11-13T14:27:37.608Z |
5484213 | 5484213 | 20241105022125_PPmCf | SI0002 | 2024-11-06T14:16:32.670Z | 2024-11-13T14:27:37.531Z |
5484209 | 5484209 | 20241105022110_Gm2Qp | SI0002 | 2024-11-06T14:16:32.174Z | 2024-11-13T14:27:37.528Z |
5484178 | 5484178 | 20241105021740_NWNBO | SI0002 | 2024-11-06T14:16:26.466Z | 2024-11-13T14:27:37.473Z |
5484154 | 5484154 | 20241105021457_Dm3rB | SI0002 | 2024-11-06T14:16:22.994Z | 2024-11-13T14:27:37.443Z |
5484123 | 5484123 | 20241105021207_W1v3J | SI0002 | 2024-11-06T14:16:20.162Z | 2024-11-13T14:27:37.375Z |
5483989 | 5483989 | 20241105015154_FvCBv | SI0002 | 2024-11-06T14:16:00.815Z | 2024-11-13T14:27:37.114Z |
5483986 | 5483986 | 20241105015135_t24Ya | SI0002 | 2024-11-06T14:16:00.586Z | 2024-11-13T14:27:37.104Z |
5483982 | 5483982 | 20241105015058_KIzIX | SI0002 | 2024-11-06T14:16:00.042Z | 2024-11-13T14:27:37.091Z |
5483973 | 5483973 | 20241105015022_TPTNF | SI0002 | 2024-11-06T14:15:59.160Z | 2024-11-13T14:27:37.075Z |
5483838 | 5483838 | 20241105013647_IpGRy | SI0002 | 2024-11-06T14:15:45.323Z | 2024-11-13T14:27:36.873Z |
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);