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-09T14:16:28.493Z |
5504241 | 5504241 | 20241108011854_xPQvw | SI0001 | 2024-11-09T14:14:16.035Z | 2024-11-09T14:16:28.484Z |
5504185 | 5504185 | 20241108011037_IPRAJ | SI0001 | 2024-11-09T14:14:12.285Z | 2024-11-09T14:16:28.470Z |
5504146 | 5504146 | 20241108010312_KgrIR | SI0001 | 2024-11-09T14:14:07.904Z | 2024-11-09T14:16:28.460Z |
5504126 | 5504126 | 20241108005828_w10uj | SI0001 | 2024-11-09T14:14:06.073Z | 2024-11-09T14:16:28.455Z |
5504095 | 5504095 | 20241108005156_5zMsd | SI0001 | 2024-11-09T14:14:04.048Z | 2024-11-09T14:16:28.448Z |
5503967 | 5503967 | 20241108002718_XyHV6 | SI0001 | 2024-11-09T14:13:55.378Z | 2024-11-09T14:16:28.413Z |
5503856 | 5503856 | 20241107235924_wNtEi | SI0001 | 2024-11-09T14:13:48.215Z | 2024-11-09T14:16:28.368Z |
5503803 | 5503803 | 20241107235121_SP3Rj | SI0001 | 2024-11-09T14:13:45.284Z | 2024-11-09T14:16:28.351Z |
5503777 | 5503777 | 20241107234741_OGj8h | SI0001 | 2024-11-09T14:13:43.943Z | 2024-11-09T14:16:28.344Z |
5503643 | 5503643 | 20241107230956_bAhy1 | SI0001 | 2024-11-09T14:13:28.254Z | 2024-11-09T14:16:28.310Z |
5503632 | 5503632 | 20241107230751_fhPsy | SI0001 | 2024-11-09T14:13:26.986Z | 2024-11-09T14:16:28.307Z |
5503624 | 5503624 | 20241107230616_tKsRd | SI0001 | 2024-11-09T14:13:26.313Z | 2024-11-09T14:16:28.305Z |
5503602 | 5503602 | 20241107230003_vMcQ5 | SI0001 | 2024-11-09T14:13:23.383Z | 2024-11-09T14:16:28.299Z |
5503459 | 5503459 | 20241107222440_ff2vA | SI0001 | 2024-11-09T14:13:07.124Z | 2024-11-09T14:16:28.264Z |
5503437 | 5503437 | 20241107221951_r2PcW | SI0001 | 2024-11-09T14:13:04.757Z | 2024-11-09T14:16:28.257Z |
5503408 | 5503408 | 20241107220936_k83es | SI0001 | 2024-11-09T14:13:00.627Z | 2024-11-09T14:16:28.247Z |
5503318 | 5503318 | 20241107213629_RIvv6 | SI0001 | 2024-11-09T14:12:48.153Z | 2024-11-09T14:16:28.216Z |
5503238 | 5503238 | 20241107210805_SPDvO | SI0001 | 2024-11-09T14:12:37.652Z | 2024-11-09T14:16:28.197Z |
5502972 | 5502972 | 20241107202113_NbgCg | SI0001 | 2024-11-09T14:12:16.265Z | 2024-11-09T14:16:28.140Z |
5502930 | 5502930 | 20241107201233_SU7d2 | SI0001 | 2024-11-09T14:12:13.035Z | 2024-11-09T14:16:28.130Z |
5502899 | 5502899 | 20241107200858_F25pP | SI0001 | 2024-11-09T14:12:11.364Z | 2024-11-09T14:16:28.123Z |
5502879 | 5502879 | 20241107200319_I7rT7 | SI0001 | 2024-11-09T14:12:10.093Z | 2024-11-09T14:16:28.118Z |
5502800 | 5502800 | 20241107194558_dliCq | SI0001 | 2024-11-09T14:12:03.919Z | 2024-11-09T14:16:28.099Z |
5502789 | 5502789 | 20241107194536_lwuc9 | SI0001 | 2024-11-09T14:12:03.555Z | 2024-11-09T14:16:28.097Z |
5502760 | 5502760 | 20241107194108_ZJj3X | SI0001 | 2024-11-09T14:12:01.833Z | 2024-11-09T14:16:28.091Z |
5502684 | 5502684 | 20241107193138_2aybb | SI0001 | 2024-11-09T14:11:58.020Z | 2024-11-09T14:16:28.077Z |
5502563 | 5502563 | 20241107190653_KGpmL | SI0001 | 2024-11-09T14:11:44.486Z | 2024-11-09T14:16:28.056Z |
5502499 | 5502499 | 20241107185026_Eb9bt | SI0001 | 2024-11-09T14:11:33.638Z | 2024-11-09T14:16:28.041Z |
5502121 | 5502121 | 20241107172448_x3s53 | SI0001 | 2024-11-09T14:10:58.216Z | 2024-11-09T14:16:27.956Z |
5497136 | 5497136 | 20241107024847_vru26 | SI0001 | 2024-11-08T14:13:14.467Z | 2024-11-09T14:18:35.860Z |
5497123 | 5497123 | 20241107024436_R7euZ | SI0001 | 2024-11-08T14:13:12.322Z | 2024-11-09T14:18:35.757Z |
5497072 | 5497072 | 20241107023817_m51i3 | SI0001 | 2024-11-08T14:13:08.463Z | 2024-11-09T14:18:35.161Z |
5496937 | 5496937 | 20241107021206_jJnq7 | SI0001 | 2024-11-08T14:12:59.768Z | 2024-11-09T14:18:33.312Z |
5496707 | 5496707 | 20241107012203_93PeC | SI0001 | 2024-11-08T14:12:44.525Z | 2024-11-09T14:18:27.851Z |
5496690 | 5496690 | 20241107011623_lcvbL | SI0001 | 2024-11-08T14:12:41.716Z | 2024-11-09T14:18:27.608Z |
5496407 | 5496407 | 20241107001543_eJWBy | SI0001 | 2024-11-08T14:12:06.950Z | 2024-11-09T14:18:21.736Z |
5490315 | 5490315 | 20241105220943_m9jhp | SI0001 | 2024-11-07T14:13:51.771Z | 2024-11-09T14:19:53.771Z |
5490258 | 5490258 | 20241105215010_Qn3tw | SI0001 | 2024-11-07T14:13:46.509Z | 2024-11-09T14:19:53.238Z |
5490181 | 5490181 | 20241105213225_ZtLCI | SI0001 | 2024-11-07T14:13:30.662Z | 2024-11-09T14:19:51.782Z |
5490072 | 5490072 | 20241105205143_Cb1pA | SI0001 | 2024-11-07T14:13:08.092Z | 2024-11-09T14:19:50.568Z |
5489985 | 5489985 | 20241105203833_2U389 | SI0001 | 2024-11-07T14:12:59.552Z | 2024-11-09T14:19:49.702Z |
5489868 | 5489868 | 20241105202145_od6p4 | SI0001 | 2024-11-07T14:12:51.352Z | 2024-11-09T14:19:47.289Z |
5489691 | 5489691 | 20241105194303_in1pA | SI0001 | 2024-11-07T14:12:35.378Z | 2024-11-09T14:19:45.960Z |
5489626 | 5489626 | 20241105192902_eaXRD | SI0001 | 2024-11-07T14:12:21.098Z | 2024-11-09T14:19:45.248Z |
5489623 | 5489623 | 20241105192841_HCRwT | SI0001 | 2024-11-07T14:12:20.188Z | 2024-11-09T14:19:45.129Z |
5489520 | 5489520 | 20241105190800_EJK4A | SI0001 | 2024-11-07T14:12:07.483Z | 2024-11-09T14:19:43.472Z |
5485197 | 5485197 | 20241105041845_Nfkk3 | SI0001 | 2024-11-06T14:17:53.297Z | 2024-11-09T14:21:19.963Z |
5485175 | 5485175 | 20241105041520_eZeVa | SI0001 | 2024-11-06T14:17:51.686Z | 2024-11-09T14:21:19.820Z |
5485155 | 5485155 | 20241105041129_pHuW4 | SI0001 | 2024-11-06T14:17:50.574Z | 2024-11-09T14:21:19.739Z |
5485133 | 5485133 | 20241105040852_jaVFQ | SI0001 | 2024-11-06T14:17:49.220Z | 2024-11-09T14:21:19.634Z |
5485126 | 5485126 | 20241105040743_hwuo5 | SI0001 | 2024-11-06T14:17:48.048Z | 2024-11-09T14:21:19.561Z |
5485112 | 5485112 | 20241105040511_I5ZlF | SI0001 | 2024-11-06T14:17:46.536Z | 2024-11-09T14:21:19.435Z |
5485037 | 5485037 | 20241105035605_hMjoG | SI0001 | 2024-11-06T14:17:40.157Z | 2024-11-09T14:21:18.856Z |
5484905 | 5484905 | 20241105034006_J37iR | SI0001 | 2024-11-06T14:17:27.901Z | 2024-11-09T14:21:17.260Z |
5484823 | 5484823 | 20241105033157_YnMag | SI0001 | 2024-11-06T14:17:20.488Z | 2024-11-09T14:21:16.718Z |
5484758 | 5484758 | 20241105032558_k4RZK | SI0001 | 2024-11-06T14:17:13.885Z | 2024-11-09T14:21:16.239Z |
5484738 | 5484738 | 20241105032333_na32k | SI0001 | 2024-11-06T14:17:12.516Z | 2024-11-09T14:21:16.119Z |
5484664 | 5484664 | 20241105031830_OaBum | SI0001 | 2024-11-06T14:17:08.658Z | 2024-11-09T14:21:15.647Z |
5484541 | 5484541 | 20241105030306_n9QKJ | SI0001 | 2024-11-06T14:17:00.135Z | 2024-11-09T14:21:14.950Z |
5484523 | 5484523 | 20241105030030_1NvUt | SI0001 | 2024-11-06T14:16:59.568Z | 2024-11-09T14:21:14.840Z |
5484512 | 5484512 | 20241105025931_ClJOv | SI0001 | 2024-11-06T14:16:58.940Z | 2024-11-09T14:21:14.809Z |
5484496 | 5484496 | 20241105025702_1eled | SI0001 | 2024-11-06T14:16:58.120Z | 2024-11-09T14:21:14.696Z |
5484447 | 5484447 | 20241105025059_mo5DD | SI0001 | 2024-11-06T14:16:55.469Z | 2024-11-09T14:21:14.153Z |
5484301 | 5484301 | 20241105023224_0l7xe | SI0001 | 2024-11-06T14:16:47.109Z | 2024-11-09T14:21:12.974Z |
5484146 | 5484146 | 20241105021445_7YwZL | SI0001 | 2024-11-06T14:16:22.010Z | 2024-11-09T14:21:11.342Z |
5484144 | 5484144 | 20241105021435_rvlIs | SI0001 | 2024-11-06T14:16:21.874Z | 2024-11-09T14:21:11.340Z |
5484116 | 5484116 | 20241105021040_zVWSC | SI0001 | 2024-11-06T14:16:19.499Z | 2024-11-09T14:21:11.002Z |
5484047 | 5484047 | 20241105020502_0B5t3 | SI0001 | 2024-11-06T14:16:08.403Z | 2024-11-09T14:21:10.314Z |
5484014 | 5484014 | 20241105015651_ZMgx9 | SI0001 | 2024-11-06T14:16:03.064Z | 2024-11-09T14:21:10.078Z |
5483916 | 5483916 | 20241105014337_6pCVM | SI0001 | 2024-11-06T14:15:53.003Z | 2024-11-09T14:21:09.413Z |
5483876 | 5483876 | 20241105013930_83aaV | SI0001 | 2024-11-06T14:15:48.517Z | 2024-11-09T14:21:08.890Z |
5483852 | 5483852 | 20241105013833_eyISZ | SI0001 | 2024-11-06T14:15:46.057Z | 2024-11-09T14:21:08.727Z |
5483702 | 5483702 | 20241105012210_OZpLL | SI0001 | 2024-11-06T14:15:36.786Z | 2024-11-09T14:21:06.828Z |
5483685 | 5483685 | 20241105011904_rUNUP | SI0001 | 2024-11-06T14:15:35.802Z | 2024-11-09T14:21:06.772Z |
5483645 | 5483645 | 20241105011434_FFoWJ | SI0001 | 2024-11-06T14:15:33.427Z | 2024-11-09T14:21:06.455Z |
5483632 | 5483632 | 20241105011300_iBMw7 | SI0001 | 2024-11-06T14:15:32.668Z | 2024-11-09T14:21:06.422Z |
5483582 | 5483582 | 20241105005939_8FF9w | SI0001 | 2024-11-06T14:15:29.807Z | 2024-11-09T14:21:06.024Z |
5483561 | 5483561 | 20241105005716_G2AVE | SI0001 | 2024-11-06T14:15:28.577Z | 2024-11-09T14:21:05.892Z |
5483546 | 5483546 | 20241105005547_uG48j | SI0001 | 2024-11-06T14:15:27.916Z | 2024-11-09T14:21:05.871Z |
5483522 | 5483522 | 20241105005220_UB2EQ | SI0001 | 2024-11-06T14:15:26.618Z | 2024-11-09T14:21:05.777Z |
5483502 | 5483502 | 20241105004711_9lJso | SI0001 | 2024-11-06T14:15:25.634Z | 2024-11-09T14:21:05.670Z |
5483474 | 5483474 | 20241105004407_TvTDZ | SI0001 | 2024-11-06T14:15:23.847Z | 2024-11-09T14:21:05.619Z |
5483357 | 5483357 | 20241105003014_WeiUb | SI0001 | 2024-11-06T14:15:01.992Z | 2024-11-09T14:21:04.979Z |
5483342 | 5483342 | 20241105002810_zBpMp | SI0001 | 2024-11-06T14:15:00.947Z | 2024-11-09T14:21:04.923Z |
5483296 | 5483296 | 20241105002405_PulmI | SI0001 | 2024-11-06T14:14:56.239Z | 2024-11-09T14:21:04.673Z |
5483267 | 5483267 | 20241105002030_Ulrgh | SI0001 | 2024-11-06T14:14:51.132Z | 2024-11-09T14:21:04.478Z |
5483229 | 5483229 | 20241105001605_RkfN2 | SI0001 | 2024-11-06T14:14:48.616Z | 2024-11-09T14:21:04.216Z |
5483200 | 5483200 | 20241105001144_m6nId | SI0001 | 2024-11-06T14:14:45.841Z | 2024-11-09T14:21:04.013Z |
5483159 | 5483159 | 20241105000502_EymOz | SI0001 | 2024-11-06T14:14:43.229Z | 2024-11-09T14:21:03.819Z |
5483094 | 5483094 | 20241104235732_pjfZ3 | SI0001 | 2024-11-06T14:14:39.615Z | 2024-11-09T14:21:03.424Z |
5483009 | 5483009 | 20241104234748_9JkeN | SI0001 | 2024-11-06T14:14:34.544Z | 2024-11-09T14:21:02.892Z |
5482950 | 5482950 | 20241104234104_5ZoPf | SI0001 | 2024-11-06T14:14:30.284Z | 2024-11-09T14:21:02.588Z |
5482935 | 5482935 | 20241104233554_46FFY | SI0001 | 2024-11-06T14:14:22.143Z | 2024-11-09T14:21:02.460Z |
5482926 | 5482926 | 20241104233416_3cU3V | SI0001 | 2024-11-06T14:14:20.627Z | 2024-11-09T14:21:02.402Z |
5482900 | 5482900 | 20241104233134_JGvt6 | SI0001 | 2024-11-06T14:14:17.215Z | 2024-11-09T14:21:02.285Z |
5482831 | 5482831 | 20241104231855_vFYLK | SI0001 | 2024-11-06T14:14:08.135Z | 2024-11-09T14:21:01.832Z |
5482804 | 5482804 | 20241104231605_B3vGf | SI0001 | 2024-11-06T14:14:03.270Z | 2024-11-09T14:21:01.658Z |
5482733 | 5482733 | 20241104230902_UM6m9 | SI0001 | 2024-11-06T14:13:46.107Z | 2024-11-09T14:21:01.270Z |
5482660 | 5482660 | 20241104225714_4j6U2 | SI0001 | 2024-11-06T14:13:31.861Z | 2024-11-09T14:21:00.804Z |
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);