participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
>10,000 rows count all where station_code = "SI0001" 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 |
---|---|---|---|---|---|
5504276 | 5504276 | 20241108012513_YtUQ5 | SI0001 | 2024-11-09T14:14:19.387Z | 2024-11-16T14:28:18.527Z |
5504241 | 5504241 | 20241108011854_xPQvw | SI0001 | 2024-11-09T14:14:16.035Z | 2024-11-16T14:28:18.096Z |
5504185 | 5504185 | 20241108011037_IPRAJ | SI0001 | 2024-11-09T14:14:12.285Z | 2024-11-16T14:28:16.857Z |
5504146 | 5504146 | 20241108010312_KgrIR | SI0001 | 2024-11-09T14:14:07.904Z | 2024-11-16T14:28:16.612Z |
5504126 | 5504126 | 20241108005828_w10uj | SI0001 | 2024-11-09T14:14:06.073Z | 2024-11-16T14:28:16.317Z |
5504095 | 5504095 | 20241108005156_5zMsd | SI0001 | 2024-11-09T14:14:04.048Z | 2024-11-16T14:28:15.965Z |
5503967 | 5503967 | 20241108002718_XyHV6 | SI0001 | 2024-11-09T14:13:55.378Z | 2024-11-16T14:28:14.458Z |
5503856 | 5503856 | 20241107235924_wNtEi | SI0001 | 2024-11-09T14:13:48.215Z | 2024-11-16T14:28:13.109Z |
5503803 | 5503803 | 20241107235121_SP3Rj | SI0001 | 2024-11-09T14:13:45.284Z | 2024-11-16T14:28:12.680Z |
5503777 | 5503777 | 20241107234741_OGj8h | SI0001 | 2024-11-09T14:13:43.943Z | 2024-11-16T14:28:12.517Z |
5503643 | 5503643 | 20241107230956_bAhy1 | SI0001 | 2024-11-09T14:13:28.254Z | 2024-11-16T14:28:10.433Z |
5503632 | 5503632 | 20241107230751_fhPsy | SI0001 | 2024-11-09T14:13:26.986Z | 2024-11-16T14:28:10.203Z |
5503624 | 5503624 | 20241107230616_tKsRd | SI0001 | 2024-11-09T14:13:26.313Z | 2024-11-16T14:28:10.118Z |
5503602 | 5503602 | 20241107230003_vMcQ5 | SI0001 | 2024-11-09T14:13:23.383Z | 2024-11-16T14:28:09.667Z |
5503459 | 5503459 | 20241107222440_ff2vA | SI0001 | 2024-11-09T14:13:07.124Z | 2024-11-16T14:28:07.558Z |
5503437 | 5503437 | 20241107221951_r2PcW | SI0001 | 2024-11-09T14:13:04.757Z | 2024-11-16T14:28:07.244Z |
5503408 | 5503408 | 20241107220936_k83es | SI0001 | 2024-11-09T14:13:00.627Z | 2024-11-16T14:28:07.036Z |
5503318 | 5503318 | 20241107213629_RIvv6 | SI0001 | 2024-11-09T14:12:48.153Z | 2024-11-16T14:28:05.851Z |
5503238 | 5503238 | 20241107210805_SPDvO | SI0001 | 2024-11-09T14:12:37.652Z | 2024-11-16T14:28:04.982Z |
5502972 | 5502972 | 20241107202113_NbgCg | SI0001 | 2024-11-09T14:12:16.265Z | 2024-11-16T14:28:01.629Z |
5502930 | 5502930 | 20241107201233_SU7d2 | SI0001 | 2024-11-09T14:12:13.035Z | 2024-11-16T14:28:00.765Z |
5502899 | 5502899 | 20241107200858_F25pP | SI0001 | 2024-11-09T14:12:11.364Z | 2024-11-16T14:28:00.434Z |
5502879 | 5502879 | 20241107200319_I7rT7 | SI0001 | 2024-11-09T14:12:10.093Z | 2024-11-16T14:28:00.132Z |
5502800 | 5502800 | 20241107194558_dliCq | SI0001 | 2024-11-09T14:12:03.919Z | 2024-11-16T14:27:59.613Z |
5502789 | 5502789 | 20241107194536_lwuc9 | SI0001 | 2024-11-09T14:12:03.555Z | 2024-11-16T14:27:59.597Z |
5502760 | 5502760 | 20241107194108_ZJj3X | SI0001 | 2024-11-09T14:12:01.833Z | 2024-11-16T14:27:59.264Z |
5502684 | 5502684 | 20241107193138_2aybb | SI0001 | 2024-11-09T14:11:58.020Z | 2024-11-16T14:27:58.562Z |
5502563 | 5502563 | 20241107190653_KGpmL | SI0001 | 2024-11-09T14:11:44.486Z | 2024-11-16T14:27:57.559Z |
5502499 | 5502499 | 20241107185026_Eb9bt | SI0001 | 2024-11-09T14:11:33.638Z | 2024-11-16T14:27:56.515Z |
5502121 | 5502121 | 20241107172448_x3s53 | SI0001 | 2024-11-09T14:10:58.216Z | 2024-11-16T14:27:50.626Z |
5497136 | 5497136 | 20241107024847_vru26 | SI0001 | 2024-11-08T14:13:14.467Z | 2024-11-15T14:25:01.894Z |
5497123 | 5497123 | 20241107024436_R7euZ | SI0001 | 2024-11-08T14:13:12.322Z | 2024-11-15T14:25:01.849Z |
5497072 | 5497072 | 20241107023817_m51i3 | SI0001 | 2024-11-08T14:13:08.463Z | 2024-11-15T14:25:01.576Z |
5496937 | 5496937 | 20241107021206_jJnq7 | SI0001 | 2024-11-08T14:12:59.768Z | 2024-11-15T14:25:01.022Z |
5496707 | 5496707 | 20241107012203_93PeC | SI0001 | 2024-11-08T14:12:44.525Z | 2024-11-15T14:24:59.563Z |
5496690 | 5496690 | 20241107011623_lcvbL | SI0001 | 2024-11-08T14:12:41.716Z | 2024-11-15T14:24:59.493Z |
5496407 | 5496407 | 20241107001543_eJWBy | SI0001 | 2024-11-08T14:12:06.950Z | 2024-11-15T14:24:57.293Z |
5490315 | 5490315 | 20241105220943_m9jhp | SI0001 | 2024-11-07T14:13:51.771Z | 2024-11-14T14:23:18.918Z |
5490258 | 5490258 | 20241105215010_Qn3tw | SI0001 | 2024-11-07T14:13:46.509Z | 2024-11-14T14:23:18.413Z |
5490181 | 5490181 | 20241105213225_ZtLCI | SI0001 | 2024-11-07T14:13:30.662Z | 2024-11-14T14:23:18.060Z |
5490072 | 5490072 | 20241105205143_Cb1pA | SI0001 | 2024-11-07T14:13:08.092Z | 2024-11-14T14:23:17.393Z |
5489985 | 5489985 | 20241105203833_2U389 | SI0001 | 2024-11-07T14:12:59.552Z | 2024-11-14T14:23:17.019Z |
5489868 | 5489868 | 20241105202145_od6p4 | SI0001 | 2024-11-07T14:12:51.352Z | 2024-11-14T14:23:16.007Z |
5489691 | 5489691 | 20241105194303_in1pA | SI0001 | 2024-11-07T14:12:35.378Z | 2024-11-14T14:23:15.291Z |
5489626 | 5489626 | 20241105192902_eaXRD | SI0001 | 2024-11-07T14:12:21.098Z | 2024-11-14T14:23:14.308Z |
5489623 | 5489623 | 20241105192841_HCRwT | SI0001 | 2024-11-07T14:12:20.188Z | 2024-11-14T14:23:14.252Z |
5489520 | 5489520 | 20241105190800_EJK4A | SI0001 | 2024-11-07T14:12:07.483Z | 2024-11-14T14:23:13.631Z |
5485197 | 5485197 | 20241105041845_Nfkk3 | SI0001 | 2024-11-06T14:17:53.297Z | 2024-11-13T14:27:40.972Z |
5485175 | 5485175 | 20241105041520_eZeVa | SI0001 | 2024-11-06T14:17:51.686Z | 2024-11-13T14:27:40.913Z |
5485155 | 5485155 | 20241105041129_pHuW4 | SI0001 | 2024-11-06T14:17:50.574Z | 2024-11-13T14:27:40.878Z |
5485133 | 5485133 | 20241105040852_jaVFQ | SI0001 | 2024-11-06T14:17:49.220Z | 2024-11-13T14:27:40.827Z |
5485126 | 5485126 | 20241105040743_hwuo5 | SI0001 | 2024-11-06T14:17:48.048Z | 2024-11-13T14:27:40.804Z |
5485112 | 5485112 | 20241105040511_I5ZlF | SI0001 | 2024-11-06T14:17:46.536Z | 2024-11-13T14:27:40.755Z |
5485037 | 5485037 | 20241105035605_hMjoG | SI0001 | 2024-11-06T14:17:40.157Z | 2024-11-13T14:27:40.476Z |
5484905 | 5484905 | 20241105034006_J37iR | SI0001 | 2024-11-06T14:17:27.901Z | 2024-11-13T14:27:40.061Z |
5484823 | 5484823 | 20241105033157_YnMag | SI0001 | 2024-11-06T14:17:20.488Z | 2024-11-13T14:27:39.921Z |
5484758 | 5484758 | 20241105032558_k4RZK | SI0001 | 2024-11-06T14:17:13.885Z | 2024-11-13T14:27:39.795Z |
5484738 | 5484738 | 20241105032333_na32k | SI0001 | 2024-11-06T14:17:12.516Z | 2024-11-13T14:27:39.541Z |
5484664 | 5484664 | 20241105031830_OaBum | SI0001 | 2024-11-06T14:17:08.658Z | 2024-11-13T14:27:39.037Z |
5484541 | 5484541 | 20241105030306_n9QKJ | SI0001 | 2024-11-06T14:17:00.135Z | 2024-11-13T14:27:38.572Z |
5484523 | 5484523 | 20241105030030_1NvUt | SI0001 | 2024-11-06T14:16:59.568Z | 2024-11-13T14:27:38.544Z |
5484512 | 5484512 | 20241105025931_ClJOv | SI0001 | 2024-11-06T14:16:58.940Z | 2024-11-13T14:27:38.482Z |
5484496 | 5484496 | 20241105025702_1eled | SI0001 | 2024-11-06T14:16:58.120Z | 2024-11-13T14:27:38.263Z |
5484447 | 5484447 | 20241105025059_mo5DD | SI0001 | 2024-11-06T14:16:55.469Z | 2024-11-13T14:27:38.088Z |
5484301 | 5484301 | 20241105023224_0l7xe | SI0001 | 2024-11-06T14:16:47.109Z | 2024-11-13T14:27:37.672Z |
5484146 | 5484146 | 20241105021445_7YwZL | SI0001 | 2024-11-06T14:16:22.010Z | 2024-11-13T14:27:37.418Z |
5484144 | 5484144 | 20241105021435_rvlIs | SI0001 | 2024-11-06T14:16:21.874Z | 2024-11-13T14:27:37.413Z |
5484116 | 5484116 | 20241105021040_zVWSC | SI0001 | 2024-11-06T14:16:19.499Z | 2024-11-13T14:27:37.346Z |
5484047 | 5484047 | 20241105020502_0B5t3 | SI0001 | 2024-11-06T14:16:08.403Z | 2024-11-13T14:27:37.195Z |
5484014 | 5484014 | 20241105015651_ZMgx9 | SI0001 | 2024-11-06T14:16:03.064Z | 2024-11-13T14:27:37.166Z |
5483916 | 5483916 | 20241105014337_6pCVM | SI0001 | 2024-11-06T14:15:53.003Z | 2024-11-13T14:27:37.013Z |
5483876 | 5483876 | 20241105013930_83aaV | SI0001 | 2024-11-06T14:15:48.517Z | 2024-11-13T14:27:36.951Z |
5483852 | 5483852 | 20241105013833_eyISZ | SI0001 | 2024-11-06T14:15:46.057Z | 2024-11-13T14:27:36.880Z |
5483702 | 5483702 | 20241105012210_OZpLL | SI0001 | 2024-11-06T14:15:36.786Z | 2024-11-13T14:27:36.649Z |
5483685 | 5483685 | 20241105011904_rUNUP | SI0001 | 2024-11-06T14:15:35.802Z | 2024-11-13T14:27:36.616Z |
5483645 | 5483645 | 20241105011434_FFoWJ | SI0001 | 2024-11-06T14:15:33.427Z | 2024-11-13T14:27:36.544Z |
5483632 | 5483632 | 20241105011300_iBMw7 | SI0001 | 2024-11-06T14:15:32.668Z | 2024-11-13T14:27:36.535Z |
5483582 | 5483582 | 20241105005939_8FF9w | SI0001 | 2024-11-06T14:15:29.807Z | 2024-11-13T14:27:36.447Z |
5483561 | 5483561 | 20241105005716_G2AVE | SI0001 | 2024-11-06T14:15:28.577Z | 2024-11-13T14:27:36.391Z |
5483546 | 5483546 | 20241105005547_uG48j | SI0001 | 2024-11-06T14:15:27.916Z | 2024-11-13T14:27:36.388Z |
5483522 | 5483522 | 20241105005220_UB2EQ | SI0001 | 2024-11-06T14:15:26.618Z | 2024-11-13T14:27:36.365Z |
5483502 | 5483502 | 20241105004711_9lJso | SI0001 | 2024-11-06T14:15:25.634Z | 2024-11-13T14:27:36.339Z |
5483474 | 5483474 | 20241105004407_TvTDZ | SI0001 | 2024-11-06T14:15:23.847Z | 2024-11-13T14:27:36.323Z |
5483357 | 5483357 | 20241105003014_WeiUb | SI0001 | 2024-11-06T14:15:01.992Z | 2024-11-13T14:27:36.076Z |
5483342 | 5483342 | 20241105002810_zBpMp | SI0001 | 2024-11-06T14:15:00.947Z | 2024-11-13T14:27:36.054Z |
5483296 | 5483296 | 20241105002405_PulmI | SI0001 | 2024-11-06T14:14:56.239Z | 2024-11-13T14:27:36.004Z |
5483267 | 5483267 | 20241105002030_Ulrgh | SI0001 | 2024-11-06T14:14:51.132Z | 2024-11-13T14:27:35.946Z |
5483229 | 5483229 | 20241105001605_RkfN2 | SI0001 | 2024-11-06T14:14:48.616Z | 2024-11-13T14:27:35.869Z |
5483200 | 5483200 | 20241105001144_m6nId | SI0001 | 2024-11-06T14:14:45.841Z | 2024-11-13T14:27:35.830Z |
5483159 | 5483159 | 20241105000502_EymOz | SI0001 | 2024-11-06T14:14:43.229Z | 2024-11-13T14:27:35.799Z |
5483094 | 5483094 | 20241104235732_pjfZ3 | SI0001 | 2024-11-06T14:14:39.615Z | 2024-11-13T14:27:35.714Z |
5483009 | 5483009 | 20241104234748_9JkeN | SI0001 | 2024-11-06T14:14:34.544Z | 2024-11-13T14:27:35.565Z |
5482950 | 5482950 | 20241104234104_5ZoPf | SI0001 | 2024-11-06T14:14:30.284Z | 2024-11-13T14:27:35.470Z |
5482935 | 5482935 | 20241104233554_46FFY | SI0001 | 2024-11-06T14:14:22.143Z | 2024-11-13T14:27:35.389Z |
5482926 | 5482926 | 20241104233416_3cU3V | SI0001 | 2024-11-06T14:14:20.627Z | 2024-11-13T14:27:35.372Z |
5482900 | 5482900 | 20241104233134_JGvt6 | SI0001 | 2024-11-06T14:14:17.215Z | 2024-11-13T14:27:35.332Z |
5482831 | 5482831 | 20241104231855_vFYLK | SI0001 | 2024-11-06T14:14:08.135Z | 2024-11-13T14:27:35.237Z |
5482804 | 5482804 | 20241104231605_B3vGf | SI0001 | 2024-11-06T14:14:03.270Z | 2024-11-13T14:27:35.181Z |
5482733 | 5482733 | 20241104230902_UM6m9 | SI0001 | 2024-11-06T14:13:46.107Z | 2024-11-13T14:27:35.065Z |
5482660 | 5482660 | 20241104225714_4j6U2 | SI0001 | 2024-11-06T14:13:31.861Z | 2024-11-13T14:27:34.981Z |
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);