participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,725 rows where station_code = "SK0002" 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 |
---|---|---|---|---|---|
5572823 | 5572823 | 20241121031315_e1dH6 | SK0002 | 2024-11-22T14:18:51.567Z | 2024-11-22T14:19:22.396Z |
5572367 | 5572367 | 20241121021433_G2AM1 | SK0002 | 2024-11-22T14:18:19.778Z | 2024-11-22T14:19:22.316Z |
5572312 | 5572312 | 20241121020835_TmBFr | SK0002 | 2024-11-22T14:18:14.869Z | 2024-11-22T14:19:22.303Z |
5572213 | 5572213 | 20241121014943_waM3e | SK0002 | 2024-11-22T14:18:05.110Z | 2024-11-22T14:19:22.280Z |
5571742 | 5571742 | 20241121003909_U7jap | SK0002 | 2024-11-22T14:17:36.889Z | 2024-11-22T14:19:22.184Z |
5571641 | 5571641 | 20241121002615_i63sY | SK0002 | 2024-11-22T14:17:30.054Z | 2024-11-22T14:19:22.164Z |
5571353 | 5571353 | 20241120232734_4NdOH | SK0002 | 2024-11-22T14:16:55.963Z | 2024-11-22T14:19:22.109Z |
5571334 | 5571334 | 20241120232416_CyWka | SK0002 | 2024-11-22T14:16:51.593Z | 2024-11-22T14:19:22.103Z |
5571247 | 5571247 | 20241120230749_22sta | SK0002 | 2024-11-22T14:16:43.684Z | 2024-11-22T14:19:22.078Z |
5571096 | 5571096 | 20241120222157_yBOsk | SK0002 | 2024-11-22T14:16:25.165Z | 2024-11-22T14:19:22.041Z |
5570649 | 5570649 | 20241120203452_Ftpf8 | SK0002 | 2024-11-22T14:15:58.367Z | 2024-11-22T14:19:21.956Z |
5570580 | 5570580 | 20241120201759_a6tFn | SK0002 | 2024-11-22T14:15:50.347Z | 2024-11-22T14:19:21.943Z |
5570238 | 5570238 | 20241120190756_vUS3U | SK0002 | 2024-11-22T14:15:03.686Z | 2024-11-22T14:19:21.886Z |
5570129 | 5570129 | 20241120184741_iZS7C | SK0002 | 2024-11-22T14:14:54.188Z | 2024-11-22T14:19:21.867Z |
5556403 | 5556403 | 20241118205927_bcFMc | SK0002 | 2024-11-20T14:10:25.457Z | 2024-11-22T14:22:17.108Z |
5517554 | 5517554 | 20241110040154_Y9V2Z | SK0002 | 2024-11-11T14:14:34.778Z | 2024-11-18T14:26:37.127Z |
5517318 | 5517318 | 20241110032404_ADKCA | SK0002 | 2024-11-11T14:14:14.115Z | 2024-11-18T14:26:35.875Z |
5517305 | 5517305 | 20241110032139_plloL | SK0002 | 2024-11-11T14:14:13.260Z | 2024-11-18T14:26:35.821Z |
5517107 | 5517107 | 20241110024836_3HRh5 | SK0002 | 2024-11-11T14:13:54.860Z | 2024-11-18T14:26:34.769Z |
5516964 | 5516964 | 20241110022725_Z2xi8 | SK0002 | 2024-11-11T14:13:38.900Z | 2024-11-18T14:26:34.019Z |
5516795 | 5516795 | 20241110020422_3dyZL | SK0002 | 2024-11-11T14:13:22.507Z | 2024-11-18T14:26:33.330Z |
5516781 | 5516781 | 20241110020025_sW2wG | SK0002 | 2024-11-11T14:13:20.852Z | 2024-11-18T14:26:33.241Z |
5516589 | 5516589 | 20241110012512_mdUyt | SK0002 | 2024-11-11T14:13:10.038Z | 2024-11-18T14:26:32.212Z |
5516528 | 5516528 | 20241110011219_7X79Y | SK0002 | 2024-11-11T14:13:06.582Z | 2024-11-18T14:26:31.708Z |
5516357 | 5516357 | 20241110004522_h9PD6 | SK0002 | 2024-11-11T14:12:51.656Z | 2024-11-18T14:26:30.819Z |
5516331 | 5516331 | 20241110004052_utxHn | SK0002 | 2024-11-11T14:12:46.028Z | 2024-11-18T14:26:30.698Z |
5515990 | 5515990 | 20241109232629_PgXJR | SK0002 | 2024-11-11T14:11:53.580Z | 2024-11-18T14:26:28.855Z |
5515980 | 5515980 | 20241109232356_GlJAw | SK0002 | 2024-11-11T14:11:52.607Z | 2024-11-18T14:26:28.776Z |
5515940 | 5515940 | 20241109231539_ajdpk | SK0002 | 2024-11-11T14:11:48.603Z | 2024-11-18T14:26:28.563Z |
5515811 | 5515811 | 20241109224831_C9mkN | SK0002 | 2024-11-11T14:11:31.653Z | 2024-11-18T14:26:28.062Z |
5515672 | 5515672 | 20241109221824_sh3GR | SK0002 | 2024-11-11T14:11:20.670Z | 2024-11-18T14:26:27.344Z |
5515518 | 5515518 | 20241109214539_9aPyW | SK0002 | 2024-11-11T14:11:10.421Z | 2024-11-18T14:26:26.523Z |
5515486 | 5515486 | 20241109213743_4DCon | SK0002 | 2024-11-11T14:11:07.727Z | 2024-11-18T14:26:26.269Z |
5511124 | 5511124 | 20241109043416_uxXWe | SK0002 | 2024-11-10T14:16:18.264Z | 2024-11-17T14:24:05.412Z |
5510757 | 5510757 | 20241109033300_iiTiN | SK0002 | 2024-11-10T14:15:38.789Z | 2024-11-17T14:24:00.951Z |
5510590 | 5510590 | 20241109030536_07tzl | SK0002 | 2024-11-10T14:15:28.537Z | 2024-11-17T14:23:59.554Z |
5510528 | 5510528 | 20241109025459_3XVUW | SK0002 | 2024-11-10T14:15:24.826Z | 2024-11-17T14:23:58.583Z |
5510409 | 5510409 | 20241109023730_FWrsF | SK0002 | 2024-11-10T14:15:10.178Z | 2024-11-17T14:23:57.108Z |
5510328 | 5510328 | 20241109022137_iRT5y | SK0002 | 2024-11-10T14:15:01.603Z | 2024-11-17T14:23:56.265Z |
5510274 | 5510274 | 20241109021444_xDM5Y | SK0002 | 2024-11-10T14:14:56.298Z | 2024-11-17T14:23:55.570Z |
5510111 | 5510111 | 20241109014340_MG1wl | SK0002 | 2024-11-10T14:14:36.273Z | 2024-11-17T14:23:53.043Z |
5510047 | 5510047 | 20241109013644_HTCLr | SK0002 | 2024-11-10T14:14:30.706Z | 2024-11-17T14:23:52.386Z |
5509974 | 5509974 | 20241109011841_R1R5V | SK0002 | 2024-11-10T14:14:20.852Z | 2024-11-17T14:23:51.449Z |
5509607 | 5509607 | 20241108235434_hHRkW | SK0002 | 2024-11-10T14:13:39.972Z | 2024-11-17T14:23:47.768Z |
5505144 | 5505144 | 20241108035832_YMiHT | SK0002 | 2024-11-09T14:15:50.366Z | 2024-11-16T14:28:28.075Z |
5505139 | 5505139 | 20241108035830_eYcB9 | SK0002 | 2024-11-09T14:15:50.181Z | 2024-11-16T14:28:28.036Z |
5505126 | 5505126 | 20241108035612_tmRrr | SK0002 | 2024-11-09T14:15:46.351Z | 2024-11-16T14:28:27.915Z |
5504935 | 5504935 | 20241108032214_vFhF0 | SK0002 | 2024-11-09T14:15:24.423Z | 2024-11-16T14:28:25.042Z |
5504882 | 5504882 | 20241108031211_8xZ1n | SK0002 | 2024-11-09T14:15:19.389Z | 2024-11-16T14:28:24.384Z |
5504624 | 5504624 | 20241108022616_OTlzB | SK0002 | 2024-11-09T14:14:57.746Z | 2024-11-16T14:28:21.787Z |
5504078 | 5504078 | 20241108005016_vzkQd | SK0002 | 2024-11-09T14:14:02.985Z | 2024-11-16T14:28:15.719Z |
5503702 | 5503702 | 20241107233253_6pRz2 | SK0002 | 2024-11-09T14:13:38.391Z | 2024-11-16T14:28:11.627Z |
5503567 | 5503567 | 20241107225312_aaQe4 | SK0002 | 2024-11-09T14:13:18.343Z | 2024-11-16T14:28:08.948Z |
5503361 | 5503361 | 20241107215509_uuKp4 | SK0002 | 2024-11-09T14:12:53.760Z | 2024-11-16T14:28:06.700Z |
5497439 | 5497439 | 20241107034050_3z2e6 | SK0002 | 2024-11-08T14:13:46.651Z | 2024-11-15T14:25:03.895Z |
5497411 | 5497411 | 20241107033538_bu53a | SK0002 | 2024-11-08T14:13:42.629Z | 2024-11-15T14:25:03.561Z |
5497347 | 5497347 | 20241107032615_I7ygw | SK0002 | 2024-11-08T14:13:36.199Z | 2024-11-15T14:25:03.036Z |
5497153 | 5497153 | 20241107025005_T6Kii | SK0002 | 2024-11-08T14:13:16.432Z | 2024-11-15T14:25:01.967Z |
5497028 | 5497028 | 20241107023035_4Cmc8 | SK0002 | 2024-11-08T14:13:06.304Z | 2024-11-15T14:25:01.397Z |
5496438 | 5496438 | 20241107002632_VSTGD | SK0002 | 2024-11-08T14:12:10.024Z | 2024-11-15T14:24:57.788Z |
5491187 | 5491187 | 20241106021832_RsxfM | SK0002 | 2024-11-07T14:15:25.290Z | 2024-11-14T14:23:24.387Z |
5490865 | 5490865 | 20241106010002_v3vXy | SK0002 | 2024-11-07T14:15:01.101Z | 2024-11-14T14:23:22.667Z |
5490758 | 5490758 | 20241106003136_gbcnb | SK0002 | 2024-11-07T14:14:50.864Z | 2024-11-14T14:23:21.638Z |
5490682 | 5490682 | 20241106000629_qoLQy | SK0002 | 2024-11-07T14:14:30.084Z | 2024-11-14T14:23:21.206Z |
5490621 | 5490621 | 20241105234042_D02D6 | SK0002 | 2024-11-07T14:14:19.085Z | 2024-11-14T14:23:20.967Z |
5485176 | 5485176 | 20241105041546_tr4nx | SK0002 | 2024-11-06T14:17:51.960Z | 2024-11-13T14:27:40.920Z |
5485053 | 5485053 | 20241105035833_JtmVA | SK0002 | 2024-11-06T14:17:42.282Z | 2024-11-13T14:27:40.560Z |
5484902 | 5484902 | 20241105033911_7WeZu | SK0002 | 2024-11-06T14:17:27.655Z | 2024-11-13T14:27:40.058Z |
5484713 | 5484713 | 20241105032128_11EYJ | SK0002 | 2024-11-06T14:17:10.787Z | 2024-11-13T14:27:39.409Z |
5484643 | 5484643 | 20241105031620_rbup3 | SK0002 | 2024-11-06T14:17:07.672Z | 2024-11-13T14:27:38.993Z |
5484237 | 5484237 | 20241105022309_0TA9u | SK0002 | 2024-11-06T14:16:36.865Z | 2024-11-13T14:27:37.564Z |
5484157 | 5484157 | 20241105021542_xwWNl | SK0002 | 2024-11-06T14:16:23.327Z | 2024-11-13T14:27:37.453Z |
5483992 | 5483992 | 20241105015230_RTHwH | SK0002 | 2024-11-06T14:16:01.029Z | 2024-11-13T14:27:37.117Z |
5483978 | 5483978 | 20241105015055_3stMk | SK0002 | 2024-11-06T14:15:59.718Z | 2024-11-13T14:27:37.077Z |
5483937 | 5483937 | 20241105014634_Rttq2 | SK0002 | 2024-11-06T14:15:56.092Z | 2024-11-13T14:27:37.033Z |
5483841 | 5483841 | 20241105013650_GWezF | SK0002 | 2024-11-06T14:15:45.554Z | 2024-11-13T14:27:36.874Z |
5483757 | 5483757 | 20241105012712_5Ik6r | SK0002 | 2024-11-06T14:15:40.627Z | 2024-11-13T14:27:36.766Z |
5483745 | 5483745 | 20241105012559_PJeR8 | SK0002 | 2024-11-06T14:15:39.562Z | 2024-11-13T14:27:36.725Z |
5483393 | 5483393 | 20241105003523_j04x3 | SK0002 | 2024-11-06T14:15:10.545Z | 2024-11-13T14:27:36.176Z |
5483370 | 5483370 | 20241105003251_PI9hf | SK0002 | 2024-11-06T14:15:04.903Z | 2024-11-13T14:27:36.106Z |
5482480 | 5482480 | 20241104222625_rm4U1 | SK0002 | 2024-11-06T14:13:15.135Z | 2024-11-13T14:27:34.675Z |
5482285 | 5482285 | 20241104214305_6TZ8O | SK0002 | 2024-11-06T14:12:49.013Z | 2024-11-13T14:27:34.283Z |
5482203 | 5482203 | 20241104212430_g1OGc | SK0002 | 2024-11-06T14:12:35.429Z | 2024-11-13T14:27:34.112Z |
5481673 | 5481673 | 20241104191407_YIxra | SK0002 | 2024-11-06T14:11:17.563Z | 2024-11-13T14:27:31.509Z |
5481482 | 5481482 | 20241104175337_B0Rtk | SK0002 | 2024-11-06T14:10:38.787Z | 2024-11-13T14:27:29.247Z |
5481403 | 5481403 | 20241104173036_GpdvK | SK0002 | 2024-11-06T14:10:29.362Z | 2024-11-13T14:27:28.375Z |
5481333 | 5481333 | 20241104170614_X5hWM | SK0002 | 2024-11-06T14:10:02.443Z | 2024-11-13T14:27:27.682Z |
5481327 | 5481327 | 20241104170322_tdUUE | SK0002 | 2024-11-06T14:10:00.636Z | 2024-11-13T14:27:27.524Z |
5478592 | 5478592 | 20241104043834_Y8wP2 | SK0002 | 2024-11-05T14:18:32.970Z | 2024-11-12T14:28:16.297Z |
5478440 | 5478440 | 20241104041149_MrcNr | SK0002 | 2024-11-05T14:18:22.817Z | 2024-11-12T14:28:15.406Z |
5478164 | 5478164 | 20241104033133_5yzse | SK0002 | 2024-11-05T14:18:01.084Z | 2024-11-12T14:28:14.475Z |
5478118 | 5478118 | 20241104032334_T33oR | SK0002 | 2024-11-05T14:17:57.848Z | 2024-11-12T14:28:14.397Z |
5477537 | 5477537 | 20241104020606_w4mO0 | SK0002 | 2024-11-05T14:17:01.834Z | 2024-11-12T14:28:11.958Z |
5477424 | 5477424 | 20241104015024_3iqdW | SK0002 | 2024-11-05T14:16:52.307Z | 2024-11-12T14:28:11.533Z |
5477314 | 5477314 | 20241104013545_z21sB | SK0002 | 2024-11-05T14:16:42.734Z | 2024-11-12T14:28:10.685Z |
5477311 | 5477311 | 20241104013521_LB2Mb | SK0002 | 2024-11-05T14:16:42.244Z | 2024-11-12T14:28:10.550Z |
5477173 | 5477173 | 20241104011133_22M17 | SK0002 | 2024-11-05T14:16:28.793Z | 2024-11-12T14:28:09.942Z |
5476849 | 5476849 | 20241104003318_y20rJ | SK0002 | 2024-11-05T14:16:07.519Z | 2024-11-12T14:28:07.726Z |
5476663 | 5476663 | 20241104000406_vlil2 | SK0002 | 2024-11-05T14:15:49.576Z | 2024-11-12T14:28:06.752Z |
5476384 | 5476384 | 20241103231837_LE5se | SK0002 | 2024-11-05T14:15:14.269Z | 2024-11-12T14:28:05.926Z |
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);