participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,710 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 |
---|---|---|---|---|---|
5517554 | 5517554 | 20241110040154_Y9V2Z | SK0002 | 2024-11-11T14:14:34.778Z | 2024-11-12T14:21:46.589Z |
5517318 | 5517318 | 20241110032404_ADKCA | SK0002 | 2024-11-11T14:14:14.115Z | 2024-11-12T14:21:37.675Z |
5517305 | 5517305 | 20241110032139_plloL | SK0002 | 2024-11-11T14:14:13.260Z | 2024-11-12T14:21:37.279Z |
5517107 | 5517107 | 20241110024836_3HRh5 | SK0002 | 2024-11-11T14:13:54.860Z | 2024-11-12T14:21:31.889Z |
5516964 | 5516964 | 20241110022725_Z2xi8 | SK0002 | 2024-11-11T14:13:38.900Z | 2024-11-12T14:21:25.339Z |
5516795 | 5516795 | 20241110020422_3dyZL | SK0002 | 2024-11-11T14:13:22.507Z | 2024-11-12T14:21:20.151Z |
5516781 | 5516781 | 20241110020025_sW2wG | SK0002 | 2024-11-11T14:13:20.852Z | 2024-11-12T14:21:19.794Z |
5516589 | 5516589 | 20241110012512_mdUyt | SK0002 | 2024-11-11T14:13:10.038Z | 2024-11-12T14:21:12.729Z |
5516528 | 5516528 | 20241110011219_7X79Y | SK0002 | 2024-11-11T14:13:06.582Z | 2024-11-12T14:21:09.581Z |
5516357 | 5516357 | 20241110004522_h9PD6 | SK0002 | 2024-11-11T14:12:51.656Z | 2024-11-12T14:21:02.898Z |
5516331 | 5516331 | 20241110004052_utxHn | SK0002 | 2024-11-11T14:12:46.028Z | 2024-11-12T14:21:00.723Z |
5515990 | 5515990 | 20241109232629_PgXJR | SK0002 | 2024-11-11T14:11:53.580Z | 2024-11-12T14:20:45.840Z |
5515980 | 5515980 | 20241109232356_GlJAw | SK0002 | 2024-11-11T14:11:52.607Z | 2024-11-12T14:20:45.546Z |
5515940 | 5515940 | 20241109231539_ajdpk | SK0002 | 2024-11-11T14:11:48.603Z | 2024-11-12T14:20:44.182Z |
5515811 | 5515811 | 20241109224831_C9mkN | SK0002 | 2024-11-11T14:11:31.653Z | 2024-11-12T14:20:39.685Z |
5515672 | 5515672 | 20241109221824_sh3GR | SK0002 | 2024-11-11T14:11:20.670Z | 2024-11-12T14:20:32.609Z |
5515518 | 5515518 | 20241109214539_9aPyW | SK0002 | 2024-11-11T14:11:10.421Z | 2024-11-12T14:20:24.991Z |
5515486 | 5515486 | 20241109213743_4DCon | SK0002 | 2024-11-11T14:11:07.727Z | 2024-11-12T14:20:23.836Z |
5511124 | 5511124 | 20241109043416_uxXWe | SK0002 | 2024-11-10T14:16:18.264Z | 2024-11-12T14:23:45.306Z |
5510757 | 5510757 | 20241109033300_iiTiN | SK0002 | 2024-11-10T14:15:38.789Z | 2024-11-12T14:23:40.476Z |
5510590 | 5510590 | 20241109030536_07tzl | SK0002 | 2024-11-10T14:15:28.537Z | 2024-11-12T14:23:38.176Z |
5510528 | 5510528 | 20241109025459_3XVUW | SK0002 | 2024-11-10T14:15:24.826Z | 2024-11-12T14:23:37.518Z |
5510409 | 5510409 | 20241109023730_FWrsF | SK0002 | 2024-11-10T14:15:10.178Z | 2024-11-12T14:23:35.758Z |
5510328 | 5510328 | 20241109022137_iRT5y | SK0002 | 2024-11-10T14:15:01.603Z | 2024-11-12T14:23:34.427Z |
5510274 | 5510274 | 20241109021444_xDM5Y | SK0002 | 2024-11-10T14:14:56.298Z | 2024-11-12T14:23:33.562Z |
5510111 | 5510111 | 20241109014340_MG1wl | SK0002 | 2024-11-10T14:14:36.273Z | 2024-11-12T14:23:30.243Z |
5510047 | 5510047 | 20241109013644_HTCLr | SK0002 | 2024-11-10T14:14:30.706Z | 2024-11-12T14:23:29.689Z |
5509974 | 5509974 | 20241109011841_R1R5V | SK0002 | 2024-11-10T14:14:20.852Z | 2024-11-12T14:23:28.189Z |
5509607 | 5509607 | 20241108235434_hHRkW | SK0002 | 2024-11-10T14:13:39.972Z | 2024-11-12T14:23:22.346Z |
5505144 | 5505144 | 20241108035832_YMiHT | SK0002 | 2024-11-09T14:15:50.366Z | 2024-11-12T14:25:12.960Z |
5505139 | 5505139 | 20241108035830_eYcB9 | SK0002 | 2024-11-09T14:15:50.181Z | 2024-11-12T14:25:12.953Z |
5505126 | 5505126 | 20241108035612_tmRrr | SK0002 | 2024-11-09T14:15:46.351Z | 2024-11-12T14:25:12.693Z |
5504935 | 5504935 | 20241108032214_vFhF0 | SK0002 | 2024-11-09T14:15:24.423Z | 2024-11-12T14:25:10.001Z |
5504882 | 5504882 | 20241108031211_8xZ1n | SK0002 | 2024-11-09T14:15:19.389Z | 2024-11-12T14:25:08.878Z |
5504624 | 5504624 | 20241108022616_OTlzB | SK0002 | 2024-11-09T14:14:57.746Z | 2024-11-12T14:25:05.641Z |
5504078 | 5504078 | 20241108005016_vzkQd | SK0002 | 2024-11-09T14:14:02.985Z | 2024-11-12T14:24:57.163Z |
5503702 | 5503702 | 20241107233253_6pRz2 | SK0002 | 2024-11-09T14:13:38.391Z | 2024-11-12T14:24:51.113Z |
5503567 | 5503567 | 20241107225312_aaQe4 | SK0002 | 2024-11-09T14:13:18.343Z | 2024-11-12T14:24:48.852Z |
5503361 | 5503361 | 20241107215509_uuKp4 | SK0002 | 2024-11-09T14:12:53.760Z | 2024-11-12T14:24:46.507Z |
5497439 | 5497439 | 20241107034050_3z2e6 | SK0002 | 2024-11-08T14:13:46.651Z | 2024-11-12T14:26:11.929Z |
5497411 | 5497411 | 20241107033538_bu53a | SK0002 | 2024-11-08T14:13:42.629Z | 2024-11-12T14:26:11.574Z |
5497347 | 5497347 | 20241107032615_I7ygw | SK0002 | 2024-11-08T14:13:36.199Z | 2024-11-12T14:26:11.132Z |
5497153 | 5497153 | 20241107025005_T6Kii | SK0002 | 2024-11-08T14:13:16.432Z | 2024-11-12T14:26:09.777Z |
5497028 | 5497028 | 20241107023035_4Cmc8 | SK0002 | 2024-11-08T14:13:06.304Z | 2024-11-12T14:26:08.645Z |
5496438 | 5496438 | 20241107002632_VSTGD | SK0002 | 2024-11-08T14:12:10.024Z | 2024-11-12T14:26:04.510Z |
5491187 | 5491187 | 20241106021832_RsxfM | SK0002 | 2024-11-07T14:15:25.290Z | 2024-11-12T14:26:53.400Z |
5490865 | 5490865 | 20241106010002_v3vXy | SK0002 | 2024-11-07T14:15:01.101Z | 2024-11-12T14:26:51.636Z |
5490758 | 5490758 | 20241106003136_gbcnb | SK0002 | 2024-11-07T14:14:50.864Z | 2024-11-12T14:26:51.229Z |
5490682 | 5490682 | 20241106000629_qoLQy | SK0002 | 2024-11-07T14:14:30.084Z | 2024-11-12T14:26:50.590Z |
5490621 | 5490621 | 20241105234042_D02D6 | SK0002 | 2024-11-07T14:14:19.085Z | 2024-11-12T14:26:49.913Z |
5485176 | 5485176 | 20241105041546_tr4nx | SK0002 | 2024-11-06T14:17:51.960Z | 2024-11-12T14:27:37.320Z |
5485053 | 5485053 | 20241105035833_JtmVA | SK0002 | 2024-11-06T14:17:42.282Z | 2024-11-12T14:27:36.528Z |
5484902 | 5484902 | 20241105033911_7WeZu | SK0002 | 2024-11-06T14:17:27.655Z | 2024-11-12T14:27:35.812Z |
5484713 | 5484713 | 20241105032128_11EYJ | SK0002 | 2024-11-06T14:17:10.787Z | 2024-11-12T14:27:35.325Z |
5484643 | 5484643 | 20241105031620_rbup3 | SK0002 | 2024-11-06T14:17:07.672Z | 2024-11-12T14:27:35.068Z |
5484237 | 5484237 | 20241105022309_0TA9u | SK0002 | 2024-11-06T14:16:36.865Z | 2024-11-12T14:27:32.857Z |
5484157 | 5484157 | 20241105021542_xwWNl | SK0002 | 2024-11-06T14:16:23.327Z | 2024-11-12T14:27:32.249Z |
5483992 | 5483992 | 20241105015230_RTHwH | SK0002 | 2024-11-06T14:16:01.029Z | 2024-11-12T14:27:31.079Z |
5483978 | 5483978 | 20241105015055_3stMk | SK0002 | 2024-11-06T14:15:59.718Z | 2024-11-12T14:27:30.812Z |
5483937 | 5483937 | 20241105014634_Rttq2 | SK0002 | 2024-11-06T14:15:56.092Z | 2024-11-12T14:27:30.721Z |
5483841 | 5483841 | 20241105013650_GWezF | SK0002 | 2024-11-06T14:15:45.554Z | 2024-11-12T14:27:30.389Z |
5483757 | 5483757 | 20241105012712_5Ik6r | SK0002 | 2024-11-06T14:15:40.627Z | 2024-11-12T14:27:30.103Z |
5483745 | 5483745 | 20241105012559_PJeR8 | SK0002 | 2024-11-06T14:15:39.562Z | 2024-11-12T14:27:29.918Z |
5483393 | 5483393 | 20241105003523_j04x3 | SK0002 | 2024-11-06T14:15:10.545Z | 2024-11-12T14:27:27.972Z |
5483370 | 5483370 | 20241105003251_PI9hf | SK0002 | 2024-11-06T14:15:04.903Z | 2024-11-12T14:27:27.817Z |
5482480 | 5482480 | 20241104222625_rm4U1 | SK0002 | 2024-11-06T14:13:15.135Z | 2024-11-12T14:27:22.627Z |
5482285 | 5482285 | 20241104214305_6TZ8O | SK0002 | 2024-11-06T14:12:49.013Z | 2024-11-12T14:27:21.514Z |
5482203 | 5482203 | 20241104212430_g1OGc | SK0002 | 2024-11-06T14:12:35.429Z | 2024-11-12T14:27:20.763Z |
5481673 | 5481673 | 20241104191407_YIxra | SK0002 | 2024-11-06T14:11:17.563Z | 2024-11-12T14:27:15.968Z |
5481482 | 5481482 | 20241104175337_B0Rtk | SK0002 | 2024-11-06T14:10:38.787Z | 2024-11-12T14:27:13.273Z |
5481403 | 5481403 | 20241104173036_GpdvK | SK0002 | 2024-11-06T14:10:29.362Z | 2024-11-12T14:27:12.352Z |
5481333 | 5481333 | 20241104170614_X5hWM | SK0002 | 2024-11-06T14:10:02.443Z | 2024-11-12T14:27:11.525Z |
5481327 | 5481327 | 20241104170322_tdUUE | SK0002 | 2024-11-06T14:10:00.636Z | 2024-11-12T14:27:11.444Z |
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 |
5476317 | 5476317 | 20241103230700_cmMn7 | SK0002 | 2024-11-05T14:15:03.254Z | 2024-11-12T14:28:05.380Z |
5476269 | 5476269 | 20241103225647_C4eWB | SK0002 | 2024-11-05T14:14:59.525Z | 2024-11-12T14:28:04.771Z |
5476029 | 5476029 | 20241103221017_6PDtK | SK0002 | 2024-11-05T14:14:40.484Z | 2024-11-12T14:28:02.445Z |
5475978 | 5475978 | 20241103220300_1D3m2 | SK0002 | 2024-11-05T14:14:36.889Z | 2024-11-12T14:28:01.992Z |
5475884 | 5475884 | 20241103214505_A4lV2 | SK0002 | 2024-11-05T14:14:29.754Z | 2024-11-12T14:28:01.732Z |
5475771 | 5475771 | 20241103212009_cKBxI | SK0002 | 2024-11-05T14:14:10.567Z | 2024-11-12T14:28:00.894Z |
5475725 | 5475725 | 20241103210938_yl1LF | SK0002 | 2024-11-05T14:14:03.522Z | 2024-11-12T14:28:00.733Z |
5475698 | 5475698 | 20241103210430_ZcThT | SK0002 | 2024-11-05T14:14:01.904Z | 2024-11-12T14:28:00.560Z |
5475631 | 5475631 | 20241103205212_H0z1y | SK0002 | 2024-11-05T14:13:54.766Z | 2024-11-12T14:28:00.105Z |
5475413 | 5475413 | 20241103200218_TUQHF | SK0002 | 2024-11-05T14:13:29.667Z | 2024-11-12T14:27:58.532Z |
5475260 | 5475260 | 20241103193801_R7GY2 | SK0002 | 2024-11-05T14:12:55.124Z | 2024-11-12T14:27:57.857Z |
5475070 | 5475070 | 20241103190119_z2EMU | SK0002 | 2024-11-05T14:12:29.255Z | 2024-11-12T14:27:56.941Z |
5474820 | 5474820 | 20241103182158_3B71U | SK0002 | 2024-11-05T14:12:07.721Z | 2024-11-12T14:27:54.916Z |
5474792 | 5474792 | 20241103181810_B6Myn | SK0002 | 2024-11-05T14:12:00.979Z | 2024-11-12T14:27:54.712Z |
5474522 | 5474522 | 20241103173411_VQj3a | SK0002 | 2024-11-05T14:11:12.092Z | 2024-11-12T14:27:52.614Z |
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);