participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,784 rows where station_code = "KR0008" 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 |
---|---|---|---|---|---|
4524665 | 4524665 | 20240630175438_RLleg | KR0008 | 2024-07-01T12:00:22.660Z | 2024-07-09T12:07:59.704Z |
4524660 | 4524660 | 20240630174813_fJ0j5 | KR0008 | 2024-07-01T12:00:22.206Z | 2024-07-09T12:07:59.675Z |
4524446 | 4524446 | 20240628131433_dtmQa | KR0008 | 2024-06-30T12:07:43.039Z | 2024-07-06T12:16:37.721Z |
4518454 | 4518454 | 20240628163158_LbWGQ | KR0008 | 2024-06-30T12:01:50.219Z | 2024-07-07T12:13:44.073Z |
4518391 | 4518391 | 20240628161821_ZBxTM | KR0008 | 2024-06-30T12:01:45.473Z | 2024-07-07T12:13:44.021Z |
4518323 | 4518323 | 20240628161008_pXQLB | KR0008 | 2024-06-30T12:01:41.090Z | 2024-07-07T12:13:43.936Z |
4518253 | 4518253 | 20240628160131_NX0jm | KR0008 | 2024-06-30T12:01:31.645Z | 2024-07-07T12:13:43.864Z |
4518051 | 4518051 | 20240628153218_o005I | KR0008 | 2024-06-30T12:01:17.602Z | 2024-07-07T12:13:42.195Z |
4517980 | 4517980 | 20240628151940_YgtQJ | KR0008 | 2024-06-30T12:01:12.434Z | 2024-07-07T12:13:41.993Z |
4517899 | 4517899 | 20240628150905_DA63U | KR0008 | 2024-06-30T12:01:06.926Z | 2024-07-07T12:13:41.927Z |
4517422 | 4517422 | 20240628140805_XgALC | KR0008 | 2024-06-30T12:00:28.378Z | 2024-07-07T12:13:40.597Z |
4510531 | 4510531 | 20240627121137_nxV9v | KR0008 | 2024-06-28T12:04:45.579Z | 2024-07-05T12:11:33.612Z |
4506989 | 4506989 | 20240627153550_38HSe | KR0008 | 2024-06-28T12:00:57.847Z | 2024-07-06T12:16:11.735Z |
4506701 | 4506701 | 20240627141403_oI7fd | KR0008 | 2024-06-28T12:00:35.968Z | 2024-07-06T12:16:09.786Z |
4506505 | 4506505 | 20240627131258_6i0uN | KR0008 | 2024-06-28T12:00:20.555Z | 2024-07-06T12:16:09.094Z |
4506486 | 4506486 | 20240627130535_jPO9z | KR0008 | 2024-06-28T12:00:18.978Z | 2024-07-06T12:16:09.071Z |
4503292 | 4503292 | 20240626144744_tuTok | KR0008 | 2024-06-27T12:01:27.188Z | 2024-07-05T12:11:21.515Z |
4503079 | 4503079 | 20240626140657_8rI8D | KR0008 | 2024-06-27T12:01:08.912Z | 2024-07-05T12:11:20.395Z |
4502982 | 4502982 | 20240626135748_hgV9k | KR0008 | 2024-06-27T12:01:03.995Z | 2024-07-05T12:11:20.329Z |
4502944 | 4502944 | 20240626135130_1rfXN | KR0008 | 2024-06-27T12:01:01.826Z | 2024-07-05T12:11:20.227Z |
4502661 | 4502661 | 20240626125858_x91Og | KR0008 | 2024-06-27T12:00:38.747Z | 2024-07-05T12:11:19.863Z |
4495857 | 4495857 | 20240619175005_mPvIL | KR0008 | 2024-06-24T12:06:53.128Z | 2024-06-28T12:09:33.616Z |
4484082 | 4484082 | 20240618183847_3E4RG | KR0008 | 2024-06-20T12:05:02.211Z | 2024-06-27T12:11:27.342Z |
4484040 | 4484040 | 20240618183159_qs5Or | KR0008 | 2024-06-20T12:04:57.700Z | 2024-06-27T12:11:27.090Z |
4483912 | 4483912 | 20240618181354_XLMFC | KR0008 | 2024-06-20T12:04:45.090Z | 2024-06-27T12:11:26.111Z |
4483760 | 4483760 | 20240618175626_lOJ4D | KR0008 | 2024-06-20T12:04:34.704Z | 2024-06-27T12:11:24.983Z |
4483739 | 4483739 | 20240618175417_AKQDu | KR0008 | 2024-06-20T12:04:33.591Z | 2024-06-27T12:11:24.842Z |
4482490 | 4482490 | 20240618135304_m2OBc | KR0008 | 2024-06-20T12:02:44.322Z | 2024-06-27T12:11:17.187Z |
4479776 | 4479776 | 20240616183313_ChST2 | KR0008 | 2024-06-19T12:09:49.475Z | 2024-06-24T12:11:46.935Z |
4479724 | 4479724 | 20240616182411_5QpWU | KR0008 | 2024-06-19T12:09:45.650Z | 2024-06-24T12:11:44.766Z |
4477965 | 4477965 | 20240617191020_2xW3K | KR0008 | 2024-06-19T12:06:10.237Z | 2024-06-26T12:14:37.692Z |
4477688 | 4477688 | 20240617182645_p7Yuj | KR0008 | 2024-06-19T12:05:49.045Z | 2024-06-26T12:14:35.448Z |
4477572 | 4477572 | 20240617180950_CwIFi | KR0008 | 2024-06-19T12:05:32.423Z | 2024-06-26T12:14:34.979Z |
4477198 | 4477198 | 20240617171155_oNcLV | KR0008 | 2024-06-19T12:05:06.318Z | 2024-06-26T12:14:31.664Z |
4477069 | 4477069 | 20240617165628_N9c3l | KR0008 | 2024-06-19T12:04:47.037Z | 2024-06-26T12:14:29.893Z |
4476600 | 4476600 | 20240617150049_XZJwP | KR0008 | 2024-06-19T12:04:01.948Z | 2024-06-26T12:14:24.103Z |
4474294 | 4474294 | 20240616175749_gPgS9 | KR0008 | 2024-06-18T12:05:06.648Z | 2024-06-24T12:11:42.091Z |
4474194 | 4474194 | 20240616173805_4Lf9q | KR0008 | 2024-06-18T12:04:56.726Z | 2024-06-24T12:11:40.216Z |
4474100 | 4474100 | 20240616172106_NMrVQ | KR0008 | 2024-06-18T12:04:50.469Z | 2024-06-24T12:11:38.682Z |
4473862 | 4473862 | 20240616162927_kbuh8 | KR0008 | 2024-06-18T12:04:35.777Z | 2024-06-24T12:11:34.819Z |
4473424 | 4473424 | 20240616131128_7D6PE | KR0008 | 2024-06-18T12:03:56.052Z | 2024-06-24T12:11:27.792Z |
4470992 | 4470992 | 20240615185418_lrTT2 | KR0008 | 2024-06-17T12:07:59.673Z | 2024-06-23T12:12:34.601Z |
4470987 | 4470987 | 20240615185306_mIpXY | KR0008 | 2024-06-17T12:07:59.369Z | 2024-06-23T12:12:34.583Z |
4470968 | 4470968 | 20240615185048_pG871 | KR0008 | 2024-06-17T12:07:58.141Z | 2024-06-23T12:12:34.443Z |
4470834 | 4470834 | 20240615182855_Xu91m | KR0008 | 2024-06-17T12:07:47.812Z | 2024-06-23T12:12:33.370Z |
4463065 | 4463065 | 20240613183456_H4QZb | KR0008 | 2024-06-15T12:09:24.516Z | 2024-06-21T12:11:47.872Z |
4462855 | 4462855 | 20240613175752_6qNe5 | KR0008 | 2024-06-15T12:09:13.761Z | 2024-06-21T12:11:47.524Z |
4462851 | 4462851 | 20240613175725_wH7kn | KR0008 | 2024-06-15T12:09:13.375Z | 2024-06-21T12:11:47.520Z |
4462714 | 4462714 | 20240613173244_1tsD3 | KR0008 | 2024-06-15T12:09:05.922Z | 2024-06-21T12:11:47.365Z |
4462173 | 4462173 | 20240613161151_yx9kZ | KR0008 | 2024-06-15T12:08:11.816Z | 2024-06-21T12:11:46.405Z |
4462023 | 4462023 | 20240613153555_5Gl32 | KR0008 | 2024-06-15T12:08:00.007Z | 2024-06-21T12:11:46.173Z |
4461879 | 4461879 | 20240613144417_lOsQg | KR0008 | 2024-06-15T12:07:46.747Z | 2024-06-21T12:11:45.656Z |
4461829 | 4461829 | 20240613143123_3ttgA | KR0008 | 2024-06-15T12:07:42.483Z | 2024-06-21T12:11:45.456Z |
4461814 | 4461814 | 20240613142053_tVfpd | KR0008 | 2024-06-15T12:07:40.413Z | 2024-06-21T12:11:45.430Z |
4461651 | 4461651 | 20240613132009_Agu6r | KR0008 | 2024-06-15T12:07:20.896Z | 2024-06-21T12:11:44.767Z |
4461510 | 4461510 | 20240613120207_k2jj0 | KR0008 | 2024-06-15T12:07:04.349Z | 2024-06-21T12:11:44.322Z |
4458504 | 4458504 | 20240612141118_8laTR | KR0008 | 2024-06-14T12:04:54.869Z | 2024-06-20T12:12:03.748Z |
4454971 | 4454971 | 20240611184314_pHOPf | KR0008 | 2024-06-13T12:06:21.810Z | 2024-06-19T12:13:49.183Z |
4454820 | 4454820 | 20240611182526_mATF2 | KR0008 | 2024-06-13T12:06:18.919Z | 2024-06-19T12:13:48.612Z |
4454769 | 4454769 | 20240611182102_gzexb | KR0008 | 2024-06-13T12:06:18.165Z | 2024-06-19T12:13:48.588Z |
4454595 | 4454595 | 20240611180141_6HXyj | KR0008 | 2024-06-13T12:06:14.105Z | 2024-06-19T12:13:48.378Z |
4454323 | 4454323 | 20240611172454_rk5Ss | KR0008 | 2024-06-13T12:06:08.025Z | 2024-06-19T12:13:47.675Z |
4454041 | 4454041 | 20240611165241_xPOqk | KR0008 | 2024-06-13T12:06:01.681Z | 2024-06-19T12:13:47.416Z |
4454001 | 4454001 | 20240611164917_7eRSU | KR0008 | 2024-06-13T12:06:01.070Z | 2024-06-19T12:13:47.406Z |
4453629 | 4453629 | 20240611160110_3fAzs | KR0008 | 2024-06-13T12:05:46.026Z | 2024-06-19T12:13:47.117Z |
4452736 | 4452736 | 20240611140437_hgfd2 | KR0008 | 2024-06-13T12:05:20.086Z | 2024-06-19T12:13:45.729Z |
4448082 | 4448082 | 20240610164054_eXb4E | KR0008 | 2024-06-12T12:06:05.937Z | 2024-06-18T12:11:16.486Z |
4447946 | 4447946 | 20240610162231_w2Od0 | KR0008 | 2024-06-12T12:06:00.107Z | 2024-06-18T12:11:15.896Z |
4447926 | 4447926 | 20240610161937_ZeK2O | KR0008 | 2024-06-12T12:05:59.212Z | 2024-06-18T12:11:15.884Z |
4447882 | 4447882 | 20240610161406_bErRJ | KR0008 | 2024-06-12T12:05:55.833Z | 2024-06-18T12:11:15.722Z |
4447757 | 4447757 | 20240610155747_4w2Os | KR0008 | 2024-06-12T12:05:46.118Z | 2024-06-18T12:11:15.529Z |
4447712 | 4447712 | 20240610155123_nUrtg | KR0008 | 2024-06-12T12:05:43.435Z | 2024-06-18T12:11:15.298Z |
4444734 | 4444734 | 20240610184351_Hl3KU | KR0008 | 2024-06-12T12:00:35.217Z | 2024-06-19T12:13:24.191Z |
4444722 | 4444722 | 20240610183905_zQUPA | KR0008 | 2024-06-12T12:00:33.037Z | 2024-06-19T12:13:24.170Z |
4444701 | 4444701 | 20240610182823_RKA8u | KR0008 | 2024-06-12T12:00:30.511Z | 2024-06-19T12:13:24.092Z |
4444667 | 4444667 | 20240610182428_ECVB8 | KR0008 | 2024-06-12T12:00:26.879Z | 2024-06-19T12:13:23.981Z |
4444644 | 4444644 | 20240610181936_mjiiy | KR0008 | 2024-06-12T12:00:23.345Z | 2024-06-19T12:13:23.918Z |
4444162 | 4444162 | 20240609120251_0iPNv | KR0008 | 2024-06-11T12:06:12.477Z | 2024-06-17T12:15:21.410Z |
4444106 | 4444106 | 20240610143718_OfHb9 | KR0008 | 2024-06-11T12:04:37.642Z | 2024-06-18T12:11:14.665Z |
4443527 | 4443527 | 20240610120844_E0RcJ | KR0008 | 2024-06-11T12:03:55.009Z | 2024-06-18T12:11:12.713Z |
4426982 | 4426982 | 20240606184515_nnCNP | KR0008 | 2024-06-08T12:03:52.328Z | 2024-06-15T12:16:48.857Z |
4426959 | 4426959 | 20240606184210_WrLMm | KR0008 | 2024-06-08T12:03:51.113Z | 2024-06-15T12:16:48.842Z |
4426912 | 4426912 | 20240606183215_Sz6Li | KR0008 | 2024-06-08T12:03:47.680Z | 2024-06-15T12:16:48.786Z |
4426852 | 4426852 | 20240606182620_SUCI3 | KR0008 | 2024-06-08T12:03:45.012Z | 2024-06-15T12:16:48.703Z |
4426821 | 4426821 | 20240606182415_D4GYr | KR0008 | 2024-06-08T12:03:43.974Z | 2024-06-15T12:16:48.687Z |
4426782 | 4426782 | 20240606182056_fyMjs | KR0008 | 2024-06-08T12:03:41.403Z | 2024-06-15T12:16:48.380Z |
4426752 | 4426752 | 20240606181809_PPx4C | KR0008 | 2024-06-08T12:03:38.430Z | 2024-06-15T12:16:48.328Z |
4426738 | 4426738 | 20240606181638_6nitw | KR0008 | 2024-06-08T12:03:34.888Z | 2024-06-15T12:16:48.277Z |
4426729 | 4426729 | 20240606181448_RjtLF | KR0008 | 2024-06-08T12:03:31.207Z | 2024-06-15T12:16:48.234Z |
4426681 | 4426681 | 20240606181035_mp7kf | KR0008 | 2024-06-08T12:03:25.038Z | 2024-06-15T12:16:48.096Z |
4425885 | 4425885 | 20240606162521_fCKI8 | KR0008 | 2024-06-08T12:02:07.765Z | 2024-06-15T12:16:46.012Z |
4425685 | 4425685 | 20240606155744_k0QnY | KR0008 | 2024-06-08T12:01:51.280Z | 2024-06-15T12:16:45.325Z |
4425538 | 4425538 | 20240606153125_Mg8tr | KR0008 | 2024-06-08T12:01:35.071Z | 2024-06-15T12:16:44.903Z |
4425424 | 4425424 | 20240606151603_wzD3m | KR0008 | 2024-06-08T12:01:23.286Z | 2024-06-15T12:16:44.739Z |
4425331 | 4425331 | 20240606150357_PMuHk | KR0008 | 2024-06-08T12:01:12.242Z | 2024-06-15T12:16:44.487Z |
4425319 | 4425319 | 20240606150257_mf9G3 | KR0008 | 2024-06-08T12:01:11.942Z | 2024-06-15T12:16:44.487Z |
4425286 | 4425286 | 20240606145601_deGDq | KR0008 | 2024-06-08T12:01:07.493Z | 2024-06-15T12:16:44.387Z |
4425202 | 4425202 | 20240606144705_JCD3k | KR0008 | 2024-06-08T12:00:59.797Z | 2024-06-15T12:16:44.274Z |
4424803 | 4424803 | 20240606135014_KCCU3 | KR0008 | 2024-06-08T12:00:21.156Z | 2024-06-15T12:16:42.326Z |
4420354 | 4420354 | 20240605184605_nYaTH | KR0008 | 2024-06-07T12:03:54.630Z | 2024-06-14T12:08:15.835Z |
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);