participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,969 rows where station_code = "ES0001" 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 |
---|---|---|---|---|---|
5604165 | 5604165 | 20241124211127_6pJIx | ES0001 | 2024-11-26T14:16:43.348Z | 2024-11-26T14:18:44.914Z |
5604105 | 5604105 | 20241124204349_LnL45 | ES0001 | 2024-11-26T14:16:32.167Z | 2024-11-26T14:18:44.880Z |
5592249 | 5592249 | 20241123024552_q0Gam | ES0001 | 2024-11-24T14:20:49.771Z | 2024-11-26T14:23:42.446Z |
5592083 | 5592083 | 20241123021036_ltVPn | ES0001 | 2024-11-24T14:20:37.171Z | 2024-11-26T14:23:37.583Z |
5592050 | 5592050 | 20241123020303_MVjDE | ES0001 | 2024-11-24T14:20:36.207Z | 2024-11-26T14:23:36.608Z |
5592044 | 5592044 | 20241123020029_nowNf | ES0001 | 2024-11-24T14:20:35.630Z | 2024-11-26T14:23:36.516Z |
5589965 | 5589965 | 20241122180607_EITcQ | ES0001 | 2024-11-24T14:17:55.330Z | 2024-11-26T14:23:00.430Z |
5589868 | 5589868 | 20241122174534_Beb4o | ES0001 | 2024-11-24T14:17:48.654Z | 2024-11-26T14:22:59.612Z |
5584636 | 5584636 | 20241123052643_yzBxk | ES0001 | 2024-11-24T14:01:47.355Z | 2024-11-26T14:19:09.491Z |
5584328 | 5584328 | 20241123041818_CKYDN | ES0001 | 2024-11-24T14:00:41.049Z | 2024-11-26T14:18:52.737Z |
5581905 | 5581905 | 20241122024707_x3zqg | ES0001 | 2024-11-23T14:20:49.675Z | 2024-11-26T14:25:19.447Z |
5571605 | 5571605 | 20241121001532_L5nYH | ES0001 | 2024-11-22T14:17:22.486Z | 2024-11-26T14:26:38.217Z |
5571482 | 5571482 | 20241120235453_93W8q | ES0001 | 2024-11-22T14:17:10.527Z | 2024-11-26T14:26:35.471Z |
5571200 | 5571200 | 20241120225131_e87IS | ES0001 | 2024-11-22T14:16:36.856Z | 2024-11-26T14:26:32.880Z |
5571061 | 5571061 | 20241120220715_72pdS | ES0001 | 2024-11-22T14:16:20.684Z | 2024-11-26T14:26:31.988Z |
5570746 | 5570746 | 20241120204932_1T9gQ | ES0001 | 2024-11-22T14:16:03.677Z | 2024-11-26T14:26:28.161Z |
5541990 | 5541990 | 20241114052653_fL1u5 | ES0001 | 2024-11-15T14:08:46.392Z | 2024-11-22T14:24:21.615Z |
5541955 | 5541955 | 20241114052106_zJ8kg | ES0001 | 2024-11-15T14:08:43.304Z | 2024-11-22T14:24:21.384Z |
5541796 | 5541796 | 20241114043604_lHOKy | ES0001 | 2024-11-15T14:08:30.534Z | 2024-11-22T14:24:20.260Z |
5541713 | 5541713 | 20241114040449_ADD8m | ES0001 | 2024-11-15T14:08:14.912Z | 2024-11-22T14:24:20.014Z |
5524729 | 5524729 | 20241111052352_63s1t | ES0001 | 2024-11-12T14:17:58.403Z | 2024-11-19T14:22:23.610Z |
5524613 | 5524613 | 20241111044632_2tRzW | ES0001 | 2024-11-12T14:17:46.233Z | 2024-11-19T14:22:22.905Z |
5524288 | 5524288 | 20241111034732_VqtPr | ES0001 | 2024-11-12T14:16:55.332Z | 2024-11-19T14:22:19.736Z |
5524205 | 5524205 | 20241111033119_QWHnY | ES0001 | 2024-11-12T14:16:45.908Z | 2024-11-19T14:22:18.791Z |
5523921 | 5523921 | 20241111024822_6v31W | ES0001 | 2024-11-12T14:16:20.694Z | 2024-11-19T14:22:15.914Z |
5523873 | 5523873 | 20241111024301_Yqyso | ES0001 | 2024-11-12T14:16:18.555Z | 2024-11-19T14:22:15.671Z |
5523808 | 5523808 | 20241111022734_Az8L3 | ES0001 | 2024-11-12T14:16:14.538Z | 2024-11-19T14:22:15.141Z |
5523646 | 5523646 | 20241111020008_mMMX4 | ES0001 | 2024-11-12T14:16:05.775Z | 2024-11-19T14:22:14.235Z |
5523170 | 5523170 | 20241111002230_PhwuU | ES0001 | 2024-11-12T14:14:53.124Z | 2024-11-19T14:22:10.289Z |
5522937 | 5522937 | 20241110230832_5Hc1A | ES0001 | 2024-11-12T14:14:32.107Z | 2024-11-19T14:22:09.025Z |
5522918 | 5522918 | 20241110225622_haGOk | ES0001 | 2024-11-12T14:14:29.862Z | 2024-11-19T14:22:08.884Z |
5522801 | 5522801 | 20241110214806_0hcGn | ES0001 | 2024-11-12T14:14:19.866Z | 2024-11-19T14:22:06.442Z |
5522761 | 5522761 | 20241110211908_fzYCA | ES0001 | 2024-11-12T14:14:09.840Z | 2024-11-19T14:22:06.010Z |
5517373 | 5517373 | 20241110033600_22iOS | ES0001 | 2024-11-11T14:14:19.206Z | 2024-11-18T14:26:36.181Z |
5517329 | 5517329 | 20241110032641_3r9Rl | ES0001 | 2024-11-11T14:14:14.930Z | 2024-11-18T14:26:35.988Z |
5516457 | 5516457 | 20241110010322_ZuOR7 | ES0001 | 2024-11-11T14:13:02.301Z | 2024-11-18T14:26:31.288Z |
5516417 | 5516417 | 20241110005541_iDF4H | ES0001 | 2024-11-11T14:12:59.902Z | 2024-11-18T14:26:31.125Z |
5516413 | 5516413 | 20241110005445_AuN2s | ES0001 | 2024-11-11T14:12:59.612Z | 2024-11-18T14:26:31.084Z |
5516301 | 5516301 | 20241110003522_DeklK | ES0001 | 2024-11-11T14:12:42.407Z | 2024-11-18T14:26:30.577Z |
5516299 | 5516299 | 20241110003504_EKqcR | ES0001 | 2024-11-11T14:12:42.153Z | 2024-11-18T14:26:30.571Z |
5515924 | 5515924 | 20241109231355_aT22d | ES0001 | 2024-11-11T14:11:47.336Z | 2024-11-18T14:26:28.525Z |
5515916 | 5515916 | 20241109231307_FDGoC | ES0001 | 2024-11-11T14:11:46.827Z | 2024-11-18T14:26:28.486Z |
5515900 | 5515900 | 20241109230856_786yY | ES0001 | 2024-11-11T14:11:45.413Z | 2024-11-18T14:26:28.377Z |
5515609 | 5515609 | 20241109220936_iZ8wF | ES0001 | 2024-11-11T14:11:17.237Z | 2024-11-18T14:26:27.063Z |
5515529 | 5515529 | 20241109214835_YVAQr | ES0001 | 2024-11-11T14:11:11.115Z | 2024-11-18T14:26:26.603Z |
5515296 | 5515296 | 20241109202104_FldOY | ES0001 | 2024-11-11T14:10:39.380Z | 2024-11-18T14:26:25.337Z |
5511196 | 5511196 | 20241109050126_ilNDe | ES0001 | 2024-11-10T14:16:29.037Z | 2024-11-17T14:24:06.684Z |
5511147 | 5511147 | 20241109044058_rq1GU | ES0001 | 2024-11-10T14:16:20.476Z | 2024-11-17T14:24:05.543Z |
5511033 | 5511033 | 20241109041048_Yw8iL | ES0001 | 2024-11-10T14:16:06.613Z | 2024-11-17T14:24:03.618Z |
5510895 | 5510895 | 20241109035019_DJWNz | ES0001 | 2024-11-10T14:15:51.757Z | 2024-11-17T14:24:02.311Z |
5510617 | 5510617 | 20241109031406_9pzfR | ES0001 | 2024-11-10T14:15:29.850Z | 2024-11-17T14:23:59.709Z |
5510552 | 5510552 | 20241109025807_MGSOc | ES0001 | 2024-11-10T14:15:26.214Z | 2024-11-17T14:23:58.966Z |
5510428 | 5510428 | 20241109024024_btjaZ | ES0001 | 2024-11-10T14:15:13.268Z | 2024-11-17T14:23:57.415Z |
5509771 | 5509771 | 20241109003144_koEwG | ES0001 | 2024-11-10T14:13:59.556Z | 2024-11-17T14:23:48.979Z |
5509586 | 5509586 | 20241108235143_IBBVB | ES0001 | 2024-11-10T14:13:37.459Z | 2024-11-17T14:23:47.342Z |
5509559 | 5509559 | 20241108234603_GVj1S | ES0001 | 2024-11-10T14:13:35.175Z | 2024-11-17T14:23:46.839Z |
5509073 | 5509073 | 20241108214346_9aKtx | ES0001 | 2024-11-10T14:12:28.040Z | 2024-11-17T14:23:40.056Z |
5505417 | 5505417 | 20241108051316_QuEOA | ES0001 | 2024-11-09T14:16:16.682Z | 2024-11-16T14:28:31.695Z |
5505207 | 5505207 | 20241108040804_UN6fn | ES0001 | 2024-11-09T14:15:55.795Z | 2024-11-16T14:28:28.493Z |
5505081 | 5505081 | 20241108035019_1SnGe | ES0001 | 2024-11-09T14:15:42.362Z | 2024-11-16T14:28:26.385Z |
5505023 | 5505023 | 20241108033619_3d6BP | ES0001 | 2024-11-09T14:15:35.597Z | 2024-11-16T14:28:25.788Z |
5504997 | 5504997 | 20241108033020_Vo85U | ES0001 | 2024-11-09T14:15:32.938Z | 2024-11-16T14:28:25.597Z |
5504823 | 5504823 | 20241108030302_kx59U | ES0001 | 2024-11-09T14:15:14.085Z | 2024-11-16T14:28:23.725Z |
5504555 | 5504555 | 20241108021447_Ep3WL | ES0001 | 2024-11-09T14:14:50.893Z | 2024-11-16T14:28:21.404Z |
5504472 | 5504472 | 20241108020317_FUJdy | ES0001 | 2024-11-09T14:14:41.541Z | 2024-11-16T14:28:20.231Z |
5504470 | 5504470 | 20241108020253_sXZbO | ES0001 | 2024-11-09T14:14:41.517Z | 2024-11-16T14:28:20.230Z |
5504385 | 5504385 | 20241108015022_fsE37 | ES0001 | 2024-11-09T14:14:30.434Z | 2024-11-16T14:28:19.457Z |
5504149 | 5504149 | 20241108010505_bJQQz | ES0001 | 2024-11-09T14:14:08.657Z | 2024-11-16T14:28:16.671Z |
5504001 | 5504001 | 20241108003842_1K9nP | ES0001 | 2024-11-09T14:13:57.924Z | 2024-11-16T14:28:14.937Z |
5503901 | 5503901 | 20241108000946_nzqDP | ES0001 | 2024-11-09T14:13:50.444Z | 2024-11-16T14:28:13.587Z |
5503109 | 5503109 | 20241107204244_DLWN5 | ES0001 | 2024-11-09T14:12:25.501Z | 2024-11-16T14:28:02.987Z |
5502920 | 5502920 | 20241107201144_332JY | ES0001 | 2024-11-09T14:12:12.485Z | 2024-11-16T14:28:00.690Z |
5502880 | 5502880 | 20241107200348_CupDv | ES0001 | 2024-11-09T14:12:10.297Z | 2024-11-16T14:28:00.227Z |
5491116 | 5491116 | 20241106020257_yIwWh | ES0001 | 2024-11-07T14:15:19.726Z | 2024-11-14T14:23:23.803Z |
5490951 | 5490951 | 20241106012218_jFir1 | ES0001 | 2024-11-07T14:15:07.541Z | 2024-11-14T14:23:23.016Z |
5490787 | 5490787 | 20241106003859_277Si | ES0001 | 2024-11-07T14:14:55.886Z | 2024-11-14T14:23:21.755Z |
5490768 | 5490768 | 20241106003237_D69v6 | ES0001 | 2024-11-07T14:14:52.348Z | 2024-11-14T14:23:21.652Z |
5490702 | 5490702 | 20241106001343_EwmiG | ES0001 | 2024-11-07T14:14:35.227Z | 2024-11-14T14:23:21.271Z |
5490543 | 5490543 | 20241105231854_MoZ8p | ES0001 | 2024-11-07T14:14:11.014Z | 2024-11-14T14:23:20.784Z |
5490529 | 5490529 | 20241105231644_rmLCT | ES0001 | 2024-11-07T14:14:09.598Z | 2024-11-14T14:23:20.765Z |
5490244 | 5490244 | 20241105214635_zc82Z | ES0001 | 2024-11-07T14:13:42.784Z | 2024-11-14T14:23:18.380Z |
5490136 | 5490136 | 20241105212000_GjWu1 | ES0001 | 2024-11-07T14:13:18.678Z | 2024-11-14T14:23:17.600Z |
5470030 | 5470030 | 20241103051204_kC2cc | ES0001 | 2024-11-04T14:17:37.180Z | 2024-11-11T14:23:03.689Z |
5470002 | 5470002 | 20241103050515_GCvM9 | ES0001 | 2024-11-04T14:17:32.881Z | 2024-11-11T14:23:03.454Z |
5469885 | 5469885 | 20241103043603_ykTKy | ES0001 | 2024-11-04T14:17:14.536Z | 2024-11-11T14:23:02.927Z |
5469373 | 5469373 | 20241103031924_7QQ2Q | ES0001 | 2024-11-04T14:16:22.699Z | 2024-11-11T14:22:59.966Z |
5469329 | 5469329 | 20241103031145_FUddP | ES0001 | 2024-11-04T14:16:20.366Z | 2024-11-11T14:22:59.877Z |
5468892 | 5468892 | 20241103020603_u7Wxn | ES0001 | 2024-11-04T14:15:12.042Z | 2024-11-11T14:22:56.874Z |
5468541 | 5468541 | 20241103005403_n9VNp | ES0001 | 2024-11-04T14:14:23.543Z | 2024-11-11T14:22:54.039Z |
5462913 | 5462913 | 20241102015611_hDqy3 | ES0001 | 2024-11-03T14:18:09.799Z | 2024-11-10T14:26:33.712Z |
5462686 | 5462686 | 20241102011044_LIKp1 | ES0001 | 2024-11-03T14:17:55.300Z | 2024-11-10T14:26:33.091Z |
5462181 | 5462181 | 20241101231709_uoKUy | ES0001 | 2024-11-03T14:17:02.387Z | 2024-11-10T14:26:31.866Z |
5461777 | 5461777 | 20241101212242_Gppgx | ES0001 | 2024-11-03T14:16:15.079Z | 2024-11-10T14:26:30.246Z |
5461696 | 5461696 | 20241101205234_YkzG9 | ES0001 | 2024-11-03T14:16:04.995Z | 2024-11-10T14:26:29.850Z |
5461487 | 5461487 | 20241101191643_DvsLe | ES0001 | 2024-11-03T14:15:49.830Z | 2024-11-10T14:26:28.939Z |
5461421 | 5461421 | 20241101185401_RIjCm | ES0001 | 2024-11-03T14:15:39.015Z | 2024-11-10T14:26:28.755Z |
5461399 | 5461399 | 20241101184509_iYkjU | ES0001 | 2024-11-03T14:15:32.631Z | 2024-11-10T14:26:28.597Z |
5452773 | 5452773 | 20241101042709_WCoWZ | ES0001 | 2024-11-02T12:19:21.206Z | 2024-11-09T14:24:33.596Z |
5452488 | 5452488 | 20241101032425_CiYvg | ES0001 | 2024-11-02T12:18:52.520Z | 2024-11-09T14:24:31.267Z |
5452155 | 5452155 | 20241101021135_6XYP3 | ES0001 | 2024-11-02T12:18:21.296Z | 2024-11-09T14:24:28.502Z |
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);