participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,346 rows where station_code = "KR002Z" 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 |
---|---|---|---|---|---|
4573241 | 4573241 | 20240705115506_cXwZa | KR002Z | 2024-07-08T12:07:54.545Z | 2024-07-13T12:12:58.253Z |
4532913 | 4532913 | 20240701134446_KpCa8 | KR002Z | 2024-07-02T12:04:47.436Z | 2024-07-09T12:08:08.503Z |
4524396 | 4524396 | 20240628130322_3LxFu | KR002Z | 2024-06-30T12:07:42.502Z | 2024-07-06T12:16:37.649Z |
4524247 | 4524247 | 20240628124237_ahpWW | KR002Z | 2024-06-30T12:07:41.054Z | 2024-07-06T12:16:37.430Z |
4524071 | 4524071 | 20240628121302_nBzQj | KR002Z | 2024-06-30T12:07:39.472Z | 2024-07-06T12:16:37.144Z |
4524031 | 4524031 | 20240628120846_YAyBb | KR002Z | 2024-06-30T12:07:38.990Z | 2024-07-06T12:16:37.037Z |
4512794 | 4512794 | 20240627180552_ABt79 | KR002Z | 2024-06-29T12:04:17.485Z | 2024-07-06T12:16:14.166Z |
4508769 | 4508769 | 20240626191145_5mMoD | KR002Z | 2024-06-28T12:03:06.514Z | 2024-07-05T12:11:23.720Z |
4508740 | 4508740 | 20240626185655_lCSEv | KR002Z | 2024-06-28T12:03:04.738Z | 2024-07-05T12:11:23.673Z |
4508700 | 4508700 | 20240626184433_HQMUs | KR002Z | 2024-06-28T12:03:02.705Z | 2024-07-05T12:11:23.626Z |
4508663 | 4508663 | 20240626182845_HreGy | KR002Z | 2024-06-28T12:03:00.017Z | 2024-07-05T12:11:23.593Z |
4508359 | 4508359 | 20240626174415_T5rBe | KR002Z | 2024-06-28T12:02:44.398Z | 2024-07-05T12:11:23.005Z |
4507822 | 4507822 | 20240626161719_tF3ZZ | KR002Z | 2024-06-28T12:02:14.959Z | 2024-07-05T12:11:22.299Z |
4507350 | 4507350 | 20240626151821_Wc9fV | KR002Z | 2024-06-28T12:01:49.066Z | 2024-07-05T12:11:21.743Z |
4507144 | 4507144 | 20240627161132_McHJf | KR002Z | 2024-06-28T12:01:05.954Z | 2024-07-06T12:16:12.170Z |
4507002 | 4507002 | 20240627153716_g8wOe | KR002Z | 2024-06-28T12:00:58.251Z | 2024-07-06T12:16:11.762Z |
4506984 | 4506984 | 20240627153423_nb2AL | KR002Z | 2024-06-28T12:00:57.343Z | 2024-07-06T12:16:11.730Z |
4506829 | 4506829 | 20240627145557_eOA0A | KR002Z | 2024-06-28T12:00:45.492Z | 2024-07-06T12:16:10.372Z |
4506735 | 4506735 | 20240627142226_rLa8R | KR002Z | 2024-06-28T12:00:37.931Z | 2024-07-06T12:16:09.946Z |
4506662 | 4506662 | 20240627140402_oJ7mf | KR002Z | 2024-06-28T12:00:32.731Z | 2024-07-06T12:16:09.695Z |
4506577 | 4506577 | 20240627133907_Qma5H | KR002Z | 2024-06-28T12:00:26.681Z | 2024-07-06T12:16:09.406Z |
4498495 | 4498495 | 20240625145934_yDa2l | KR002Z | 2024-06-26T12:00:40.624Z | 2024-07-04T12:08:44.859Z |
4498486 | 4498486 | 20240625144947_pgvdm | KR002Z | 2024-06-26T12:00:39.301Z | 2024-07-04T12:08:44.822Z |
4491661 | 4491661 | 20240620191305_TP7ZU | KR002Z | 2024-06-22T12:04:35.705Z | 2024-06-29T12:13:30.574Z |
4490626 | 4490626 | 20240620151034_Nog5M | KR002Z | 2024-06-22T12:02:35.043Z | 2024-06-29T12:13:25.220Z |
4490342 | 4490342 | 20240620125455_jArG7 | KR002Z | 2024-06-22T12:01:58.668Z | 2024-06-29T12:13:24.582Z |
4487747 | 4487747 | 20240619184238_wVylw | KR002Z | 2024-06-21T12:04:20.423Z | 2024-06-28T12:09:34.406Z |
4487636 | 4487636 | 20240619182502_TUWMM | KR002Z | 2024-06-21T12:04:12.305Z | 2024-06-28T12:09:34.135Z |
4487621 | 4487621 | 20240619182405_uZmAb | KR002Z | 2024-06-21T12:04:11.677Z | 2024-06-28T12:09:34.100Z |
4487512 | 4487512 | 20240619175815_XWvgW | KR002Z | 2024-06-21T12:04:05.446Z | 2024-06-28T12:09:33.785Z |
4487198 | 4487198 | 20240619165220_iQhj5 | KR002Z | 2024-06-21T12:03:36.500Z | 2024-06-28T12:09:32.858Z |
4487024 | 4487024 | 20240619152615_pjEbv | KR002Z | 2024-06-21T12:03:20.680Z | 2024-06-28T12:09:32.359Z |
4484215 | 4484215 | 20240618190909_RLH0P | KR002Z | 2024-06-20T12:05:15.267Z | 2024-06-27T12:11:28.014Z |
4484103 | 4484103 | 20240618183948_7Nwwp | KR002Z | 2024-06-20T12:05:03.131Z | 2024-06-27T12:11:27.424Z |
4483939 | 4483939 | 20240618181644_wZOYY | KR002Z | 2024-06-20T12:04:47.783Z | 2024-06-27T12:11:26.311Z |
4483812 | 4483812 | 20240618180050_tMe7I | KR002Z | 2024-06-20T12:04:38.389Z | 2024-06-27T12:11:25.337Z |
4483800 | 4483800 | 20240618175929_2SzMa | KR002Z | 2024-06-20T12:04:37.853Z | 2024-06-27T12:11:25.276Z |
4483773 | 4483773 | 20240618175654_ttXfK | KR002Z | 2024-06-20T12:04:35.151Z | 2024-06-27T12:11:25.042Z |
4483538 | 4483538 | 20240618172236_l6If1 | KR002Z | 2024-06-20T12:04:21.859Z | 2024-06-27T12:11:23.321Z |
4483142 | 4483142 | 20240618163131_BZagC | KR002Z | 2024-06-20T12:03:40.189Z | 2024-06-27T12:11:20.462Z |
4482703 | 4482703 | 20240618145615_CIVo4 | KR002Z | 2024-06-20T12:03:02.754Z | 2024-06-27T12:11:18.070Z |
4482499 | 4482499 | 20240618135504_JgaGk | KR002Z | 2024-06-20T12:02:46.146Z | 2024-06-27T12:11:17.232Z |
4482220 | 4482220 | 20240618121233_158SM | KR002Z | 2024-06-20T12:02:06.246Z | 2024-06-27T12:11:15.885Z |
4479660 | 4479660 | 20240616181013_ViQ3z | KR002Z | 2024-06-19T12:09:42.252Z | 2024-06-24T12:11:43.341Z |
4477884 | 4477884 | 20240617185554_hpvlT | KR002Z | 2024-06-19T12:06:05.359Z | 2024-06-26T12:14:37.209Z |
4477592 | 4477592 | 20240617181118_EsDjb | KR002Z | 2024-06-19T12:05:33.584Z | 2024-06-26T12:14:35.054Z |
4477516 | 4477516 | 20240617180237_HA2AQ | KR002Z | 2024-06-19T12:05:28.081Z | 2024-06-26T12:14:34.111Z |
4477437 | 4477437 | 20240617175305_zBDOf | KR002Z | 2024-06-19T12:05:22.289Z | 2024-06-26T12:14:33.609Z |
4477046 | 4477046 | 20240617165348_A903w | KR002Z | 2024-06-19T12:04:45.689Z | 2024-06-26T12:14:29.715Z |
4476915 | 4476915 | 20240617162658_cHrtj | KR002Z | 2024-06-19T12:04:36.355Z | 2024-06-26T12:14:28.225Z |
4476904 | 4476904 | 20240617162336_2RiNW | KR002Z | 2024-06-19T12:04:35.592Z | 2024-06-26T12:14:28.089Z |
4476785 | 4476785 | 20240617160044_hTIyB | KR002Z | 2024-06-19T12:04:26.411Z | 2024-06-26T12:14:26.510Z |
4476539 | 4476539 | 20240617144000_WikpV | KR002Z | 2024-06-19T12:03:54.973Z | 2024-06-26T12:14:23.367Z |
4476416 | 4476416 | 20240617133955_Hs0Tr | KR002Z | 2024-06-19T12:03:44.724Z | 2024-06-26T12:14:21.462Z |
4473573 | 4473573 | 20240616143318_ygqal | KR002Z | 2024-06-18T12:04:10.620Z | 2024-06-24T12:11:29.958Z |
4473559 | 4473559 | 20240616142940_W3i6H | KR002Z | 2024-06-18T12:04:09.431Z | 2024-06-24T12:11:29.693Z |
4470188 | 4470188 | 20240615171256_TIcM5 | KR002Z | 2024-06-17T12:06:57.830Z | 2024-06-23T12:12:28.507Z |
4463047 | 4463047 | 20240613183257_hZ3AS | KR002Z | 2024-06-15T12:09:23.682Z | 2024-06-21T12:11:47.842Z |
4462887 | 4462887 | 20240613180222_a3N9c | KR002Z | 2024-06-15T12:09:14.794Z | 2024-06-21T12:11:47.538Z |
4462818 | 4462818 | 20240613175250_QUCry | KR002Z | 2024-06-15T12:09:11.356Z | 2024-06-21T12:11:47.500Z |
4462627 | 4462627 | 20240613172336_XL43T | KR002Z | 2024-06-15T12:08:59.049Z | 2024-06-21T12:11:47.243Z |
4462472 | 4462472 | 20240613165856_vE7Qv | KR002Z | 2024-06-15T12:08:42.535Z | 2024-06-21T12:11:46.977Z |
4462435 | 4462435 | 20240613165240_OfG5c | KR002Z | 2024-06-15T12:08:39.376Z | 2024-06-21T12:11:46.921Z |
4462100 | 4462100 | 20240613155242_IMPpJ | KR002Z | 2024-06-15T12:08:07.376Z | 2024-06-21T12:11:46.323Z |
4462054 | 4462054 | 20240613154048_zeMle | KR002Z | 2024-06-15T12:08:04.025Z | 2024-06-21T12:11:46.208Z |
4461987 | 4461987 | 20240613151958_K0Lr5 | KR002Z | 2024-06-15T12:07:55.450Z | 2024-06-21T12:11:46.099Z |
4461940 | 4461940 | 20240613150416_R0AqZ | KR002Z | 2024-06-15T12:07:51.698Z | 2024-06-21T12:11:45.815Z |
4461896 | 4461896 | 20240613144617_sKWiy | KR002Z | 2024-06-15T12:07:47.665Z | 2024-06-21T12:11:45.667Z |
4461609 | 4461609 | 20240613125754_1AI5U | KR002Z | 2024-06-15T12:07:14.057Z | 2024-06-21T12:11:44.542Z |
4461531 | 4461531 | 20240613122212_lkMq2 | KR002Z | 2024-06-15T12:07:06.446Z | 2024-06-21T12:11:44.386Z |
4459321 | 4459321 | 20240612172918_hPaVv | KR002Z | 2024-06-14T12:05:28.621Z | 2024-06-20T12:12:05.004Z |
4458921 | 4458921 | 20240612161205_UNSQB | KR002Z | 2024-06-14T12:05:14.832Z | 2024-06-20T12:12:04.516Z |
4458688 | 4458688 | 20240612145538_L3ayr | KR002Z | 2024-06-14T12:05:01.682Z | 2024-06-20T12:12:04.096Z |
4458437 | 4458437 | 20240612134126_nV9OX | KR002Z | 2024-06-14T12:04:52.378Z | 2024-06-20T12:12:03.646Z |
4455031 | 4455031 | 20240611185506_WnLNC | KR002Z | 2024-06-13T12:06:22.933Z | 2024-06-19T12:13:49.223Z |
4454860 | 4454860 | 20240611182929_IpZ7y | KR002Z | 2024-06-13T12:06:19.566Z | 2024-06-19T12:13:48.628Z |
4454304 | 4454304 | 20240611172147_VZP2N | KR002Z | 2024-06-13T12:06:07.343Z | 2024-06-19T12:13:47.652Z |
4454167 | 4454167 | 20240611170740_plNJ4 | KR002Z | 2024-06-13T12:06:04.540Z | 2024-06-19T12:13:47.557Z |
4453793 | 4453793 | 20240611162032_rel9c | KR002Z | 2024-06-13T12:05:53.452Z | 2024-06-19T12:13:47.240Z |
4453486 | 4453486 | 20240611154705_H00fr | KR002Z | 2024-06-13T12:05:42.607Z | 2024-06-19T12:13:47.013Z |
4448378 | 4448378 | 20240610172432_3TMFk | KR002Z | 2024-06-12T12:06:21.023Z | 2024-06-18T12:11:17.341Z |
4448193 | 4448193 | 20240610165715_WYSOf | KR002Z | 2024-06-12T12:06:11.779Z | 2024-06-18T12:11:16.837Z |
4447938 | 4447938 | 20240610162047_Djb35 | KR002Z | 2024-06-12T12:05:59.614Z | 2024-06-18T12:11:15.894Z |
4447907 | 4447907 | 20240610161647_vvWXJ | KR002Z | 2024-06-12T12:05:58.108Z | 2024-06-18T12:11:15.819Z |
4444773 | 4444773 | 20240610185310_hjZRr | KR002Z | 2024-06-12T12:00:39.055Z | 2024-06-19T12:13:24.256Z |
4444662 | 4444662 | 20240610182235_6FEUJ | KR002Z | 2024-06-12T12:00:25.585Z | 2024-06-19T12:13:23.962Z |
4444624 | 4444624 | 20240610181322_znOha | KR002Z | 2024-06-12T12:00:19.506Z | 2024-06-19T12:13:23.883Z |
4444046 | 4444046 | 20240610142044_RMLH5 | KR002Z | 2024-06-11T12:04:33.300Z | 2024-06-18T12:11:14.532Z |
4443964 | 4443964 | 20240610135715_90UE9 | KR002Z | 2024-06-11T12:04:25.742Z | 2024-06-18T12:11:14.352Z |
4443866 | 4443866 | 20240610133744_GR88V | KR002Z | 2024-06-11T12:04:19.803Z | 2024-06-18T12:11:14.139Z |
4441789 | 4441789 | 20240609182622_uqRd2 | KR002Z | 2024-06-11T12:00:35.265Z | 2024-06-18T12:11:01.344Z |
4439956 | 4439956 | 20240609151452_wmyCJ | KR002Z | 2024-06-10T12:02:42.143Z | 2024-06-17T12:15:23.161Z |
4439887 | 4439887 | 20240609144019_1tlQc | KR002Z | 2024-06-10T12:02:39.745Z | 2024-06-17T12:15:22.772Z |
4439852 | 4439852 | 20240609142327_hQuyV | KR002Z | 2024-06-10T12:02:38.700Z | 2024-06-17T12:15:22.636Z |
4439669 | 4439669 | 20240609125817_lHDKM | KR002Z | 2024-06-10T12:02:31.182Z | 2024-06-17T12:15:21.645Z |
4430761 | 4430761 | 20240606123829_76bzh | KR002Z | 2024-06-08T12:10:22.327Z | 2024-06-14T12:08:31.898Z |
4424755 | 4424755 | 20240606134049_jwQAq | KR002Z | 2024-06-08T12:00:15.431Z | 2024-06-15T12:16:42.049Z |
4415639 | 4415639 | 20240604183405_0d4LM | KR002Z | 2024-06-06T12:05:09.339Z | 2024-06-13T12:08:30.164Z |
4415474 | 4415474 | 20240604180922_Kj5Wc | KR002Z | 2024-06-06T12:04:45.266Z | 2024-06-13T12:08:29.983Z |
4415001 | 4415001 | 20240604165800_jtzUY | KR002Z | 2024-06-06T12:04:04.887Z | 2024-06-13T12:08:29.603Z |
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);