participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,443 rows where station_code = "KR000A" 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 |
---|---|---|---|---|---|
5098666 | 5098666 | 20240913185343_3OGfD | KR000A | 2024-09-17T12:01:16.215Z | 2024-09-18T12:12:26.017Z |
5068407 | 5068407 | 20240910112843_wiB6D | KR000A | 2024-09-14T12:19:14.537Z | 2024-09-18T12:15:26.083Z |
5059977 | 5059977 | 20240910192638_54pNz | KR000A | 2024-09-14T12:07:52.602Z | 2024-09-18T12:14:34.231Z |
5059958 | 5059958 | 20240910192357_P0G6P | KR000A | 2024-09-14T12:07:50.097Z | 2024-09-18T12:14:34.145Z |
5059849 | 5059849 | 20240910190502_vpRAi | KR000A | 2024-09-14T12:07:25.594Z | 2024-09-18T12:14:33.809Z |
5059842 | 5059842 | 20240910190446_IfAvR | KR000A | 2024-09-14T12:07:24.719Z | 2024-09-18T12:14:33.807Z |
5059762 | 5059762 | 20240910184545_8JX9C | KR000A | 2024-09-14T12:07:08.431Z | 2024-09-18T12:14:33.290Z |
5059701 | 5059701 | 20240910183349_danAp | KR000A | 2024-09-14T12:06:48.371Z | 2024-09-18T12:14:32.979Z |
5059641 | 5059641 | 20240910182225_8Y6Oh | KR000A | 2024-09-14T12:06:38.980Z | 2024-09-18T12:14:32.700Z |
5059629 | 5059629 | 20240910182102_R3mmH | KR000A | 2024-09-14T12:06:38.008Z | 2024-09-18T12:14:32.686Z |
5059393 | 5059393 | 20240910173656_2vcjN | KR000A | 2024-09-14T12:05:51.007Z | 2024-09-18T12:14:31.772Z |
5058913 | 5058913 | 20240910165850_nxcBo | KR000A | 2024-09-14T12:04:50.061Z | 2024-09-18T12:14:30.737Z |
5058743 | 5058743 | 20240910164043_Btc1d | KR000A | 2024-09-14T12:04:26.021Z | 2024-09-18T12:14:30.111Z |
5058126 | 5058126 | 20240910154703_Z7qmF | KR000A | 2024-09-14T12:03:00.547Z | 2024-09-18T12:14:27.594Z |
5058039 | 5058039 | 20240910153945_BTIX9 | KR000A | 2024-09-14T12:02:42.743Z | 2024-09-18T12:14:27.304Z |
5057960 | 5057960 | 20240910153135_mfqfW | KR000A | 2024-09-14T12:02:30.073Z | 2024-09-18T12:14:26.767Z |
5057290 | 5057290 | 20240910140838_QaBp0 | KR000A | 2024-09-14T12:00:45.772Z | 2024-09-18T12:14:21.725Z |
5052098 | 5052098 | 20240907194101_Vm96s | KR000A | 2024-09-13T12:14:56.612Z | 2024-09-16T12:21:03.718Z |
5051901 | 5051901 | 20240907190259_GWctJ | KR000A | 2024-09-13T12:14:43.462Z | 2024-09-16T12:21:02.459Z |
5051867 | 5051867 | 20240907185806_x8IPg | KR000A | 2024-09-13T12:14:39.834Z | 2024-09-16T12:21:02.330Z |
5051839 | 5051839 | 20240907185013_Cmv0Q | KR000A | 2024-09-13T12:14:37.478Z | 2024-09-16T12:21:02.118Z |
5051835 | 5051835 | 20240907184954_Vu0D2 | KR000A | 2024-09-13T12:14:37.178Z | 2024-09-16T12:21:02.112Z |
5051818 | 5051818 | 20240907184659_PFAOm | KR000A | 2024-09-13T12:14:36.519Z | 2024-09-16T12:21:02.086Z |
5051782 | 5051782 | 20240907183614_OPZQP | KR000A | 2024-09-13T12:14:33.490Z | 2024-09-16T12:21:01.902Z |
5051735 | 5051735 | 20240907183029_asjmv | KR000A | 2024-09-13T12:14:31.971Z | 2024-09-16T12:21:01.696Z |
5051713 | 5051713 | 20240907182647_XEdwp | KR000A | 2024-09-13T12:14:30.478Z | 2024-09-16T12:21:01.653Z |
5051696 | 5051696 | 20240907182532_YzVvC | KR000A | 2024-09-13T12:14:30.122Z | 2024-09-16T12:21:01.637Z |
5051676 | 5051676 | 20240907182221_yCEaa | KR000A | 2024-09-13T12:14:28.897Z | 2024-09-16T12:21:01.555Z |
5051642 | 5051642 | 20240907180325_3WSc0 | KR000A | 2024-09-13T12:14:26.603Z | 2024-09-16T12:21:01.453Z |
5051626 | 5051626 | 20240907175326_OmDew | KR000A | 2024-09-13T12:14:25.102Z | 2024-09-16T12:21:01.418Z |
5051593 | 5051593 | 20240907174808_zLQFE | KR000A | 2024-09-13T12:14:23.832Z | 2024-09-16T12:21:01.358Z |
5051585 | 5051585 | 20240907174743_74UBK | KR000A | 2024-09-13T12:14:23.720Z | 2024-09-16T12:21:01.353Z |
5051554 | 5051554 | 20240907174502_IPmfg | KR000A | 2024-09-13T12:14:23.003Z | 2024-09-16T12:21:01.200Z |
5051536 | 5051536 | 20240907174044_8LsoP | KR000A | 2024-09-13T12:14:22.003Z | 2024-09-16T12:21:01.180Z |
5051513 | 5051513 | 20240907173847_gXAQ8 | KR000A | 2024-09-13T12:14:21.506Z | 2024-09-16T12:21:01.121Z |
5051416 | 5051416 | 20240907172542_K7kwT | KR000A | 2024-09-13T12:14:13.888Z | 2024-09-16T12:21:00.401Z |
5051276 | 5051276 | 20240907171051_CtB2j | KR000A | 2024-09-13T12:14:08.554Z | 2024-09-16T12:21:00.001Z |
5051243 | 5051243 | 20240907170828_OfJLc | KR000A | 2024-09-13T12:14:07.422Z | 2024-09-16T12:20:59.922Z |
5050820 | 5050820 | 20240907161303_gknnl | KR000A | 2024-09-13T12:13:47.596Z | 2024-09-16T12:20:58.704Z |
5050677 | 5050677 | 20240907155906_lMgdF | KR000A | 2024-09-13T12:13:43.478Z | 2024-09-16T12:20:58.348Z |
5050597 | 5050597 | 20240907154631_t8OZt | KR000A | 2024-09-13T12:13:38.344Z | 2024-09-16T12:20:58.073Z |
5050522 | 5050522 | 20240907153407_QRda2 | KR000A | 2024-09-13T12:13:35.281Z | 2024-09-16T12:20:57.938Z |
5050516 | 5050516 | 20240907153343_so2MY | KR000A | 2024-09-13T12:13:35.095Z | 2024-09-16T12:20:57.915Z |
5050404 | 5050404 | 20240907151835_Pn3K8 | KR000A | 2024-09-13T12:13:30.591Z | 2024-09-16T12:20:57.580Z |
5050323 | 5050323 | 20240907151006_qGmkx | KR000A | 2024-09-13T12:13:24.686Z | 2024-09-16T12:20:57.049Z |
5050300 | 5050300 | 20240907150527_Pme6E | KR000A | 2024-09-13T12:13:23.138Z | 2024-09-16T12:20:56.974Z |
5050185 | 5050185 | 20240907144605_a96df | KR000A | 2024-09-13T12:13:16.062Z | 2024-09-16T12:20:56.674Z |
5043546 | 5043546 | 20240907112543_W22sN | KR000A | 2024-09-12T12:17:36.515Z | 2024-09-15T12:21:42.075Z |
5042695 | 5042695 | 20240907122521_vBIXB | KR000A | 2024-09-12T12:17:16.885Z | 2024-09-16T12:20:53.951Z |
5042665 | 5042665 | 20240907122235_Wekko | KR000A | 2024-09-12T12:17:16.635Z | 2024-09-16T12:20:53.884Z |
5042634 | 5042634 | 20240907121054_G982l | KR000A | 2024-09-12T12:17:16.421Z | 2024-09-16T12:20:53.827Z |
5018725 | 5018725 | 20240904195657_nDxoF | KR000A | 2024-09-10T12:11:27.072Z | 2024-09-13T12:19:48.603Z |
5017894 | 5017894 | 20240904165008_T23hT | KR000A | 2024-09-10T12:09:43.153Z | 2024-09-13T12:19:47.124Z |
5017718 | 5017718 | 20240904163535_xAmby | KR000A | 2024-09-10T12:09:26.632Z | 2024-09-13T12:19:47.062Z |
5017706 | 5017706 | 20240904163426_bm2aW | KR000A | 2024-09-10T12:09:25.483Z | 2024-09-13T12:19:47.060Z |
5017443 | 5017443 | 20240904160911_u2L2F | KR000A | 2024-09-10T12:09:11.038Z | 2024-09-13T12:19:46.887Z |
5015814 | 5015814 | 20240904124106_JQSEf | KR000A | 2024-09-10T12:06:48.934Z | 2024-09-13T12:19:44.716Z |
5015494 | 5015494 | 20240904114535_oMOlM | KR000A | 2024-09-10T12:06:15.748Z | 2024-09-13T12:19:44.161Z |
5007034 | 5007034 | 20240903194844_0kCvp | KR000A | 2024-09-09T12:05:20.851Z | 2024-09-12T12:19:11.169Z |
5007011 | 5007011 | 20240903194749_O1amS | KR000A | 2024-09-09T12:05:19.594Z | 2024-09-12T12:19:11.116Z |
5006725 | 5006725 | 20240903183940_5oIch | KR000A | 2024-09-09T12:04:57.617Z | 2024-09-12T12:19:09.330Z |
5006671 | 5006671 | 20240903182209_2B27f | KR000A | 2024-09-09T12:04:52.731Z | 2024-09-12T12:19:09.182Z |
5006626 | 5006626 | 20240903180953_AIOGD | KR000A | 2024-09-09T12:04:49.814Z | 2024-09-12T12:19:09.068Z |
5006613 | 5006613 | 20240903180544_YjsOs | KR000A | 2024-09-09T12:04:49.173Z | 2024-09-12T12:19:09.053Z |
5006557 | 5006557 | 20240903175213_kH9O2 | KR000A | 2024-09-09T12:04:45.952Z | 2024-09-12T12:19:08.745Z |
5006514 | 5006514 | 20240903174526_WgAaQ | KR000A | 2024-09-09T12:04:43.694Z | 2024-09-12T12:19:08.524Z |
5006493 | 5006493 | 20240903174357_t0zPh | KR000A | 2024-09-09T12:04:42.470Z | 2024-09-12T12:19:08.349Z |
5006375 | 5006375 | 20240903173051_8ttiM | KR000A | 2024-09-09T12:04:34.349Z | 2024-09-12T12:19:08.226Z |
5006245 | 5006245 | 20240903170904_9G3C4 | KR000A | 2024-09-09T12:04:26.501Z | 2024-09-12T12:19:08.029Z |
5006226 | 5006226 | 20240903170737_9YC5O | KR000A | 2024-09-09T12:04:25.831Z | 2024-09-12T12:19:07.989Z |
5006209 | 5006209 | 20240903170557_UNBHt | KR000A | 2024-09-09T12:04:25.014Z | 2024-09-12T12:19:07.944Z |
5006153 | 5006153 | 20240903170128_5pCw6 | KR000A | 2024-09-09T12:04:22.817Z | 2024-09-12T12:19:07.736Z |
5006032 | 5006032 | 20240903164745_8xwjp | KR000A | 2024-09-09T12:04:17.535Z | 2024-09-12T12:19:07.251Z |
5005959 | 5005959 | 20240903163815_thIi9 | KR000A | 2024-09-09T12:04:14.671Z | 2024-09-12T12:19:07.145Z |
5005944 | 5005944 | 20240903163726_SqBCQ | KR000A | 2024-09-09T12:04:13.983Z | 2024-09-12T12:19:07.105Z |
5005902 | 5005902 | 20240903163122_D31wC | KR000A | 2024-09-09T12:04:12.202Z | 2024-09-12T12:19:07.034Z |
5005804 | 5005804 | 20240903161505_bwA1c | KR000A | 2024-09-09T12:04:07.501Z | 2024-09-12T12:19:06.914Z |
5005685 | 5005685 | 20240903155558_ZkgM8 | KR000A | 2024-09-09T12:03:55.291Z | 2024-09-12T12:19:06.431Z |
5005609 | 5005609 | 20240903154432_wZ1qw | KR000A | 2024-09-09T12:03:51.191Z | 2024-09-12T12:19:06.249Z |
5005438 | 5005438 | 20240903151358_5J0Ir | KR000A | 2024-09-09T12:03:43.020Z | 2024-09-12T12:19:05.949Z |
5005356 | 5005356 | 20240903145850_F9afA | KR000A | 2024-09-09T12:03:38.660Z | 2024-09-12T12:19:05.805Z |
5005331 | 5005331 | 20240903145542_MAHup | KR000A | 2024-09-09T12:03:37.399Z | 2024-09-12T12:19:05.760Z |
5005304 | 5005304 | 20240903145027_heBAD | KR000A | 2024-09-09T12:03:35.094Z | 2024-09-12T12:19:05.680Z |
5005253 | 5005253 | 20240903143921_ePR4e | KR000A | 2024-09-09T12:03:31.912Z | 2024-09-12T12:19:05.599Z |
5005189 | 5005189 | 20240903142704_zK3hz | KR000A | 2024-09-09T12:03:25.840Z | 2024-09-12T12:19:05.434Z |
5004963 | 5004963 | 20240903134030_H0B4V | KR000A | 2024-09-09T12:03:14.133Z | 2024-09-12T12:19:04.621Z |
5004781 | 5004781 | 20240903123907_I0dk3 | KR000A | 2024-09-09T12:03:02.491Z | 2024-09-12T12:19:04.101Z |
5004748 | 5004748 | 20240903122316_4UUZD | KR000A | 2024-09-09T12:02:58.586Z | 2024-09-12T12:19:03.724Z |
5004695 | 5004695 | 20240903121011_2ZDUn | KR000A | 2024-09-09T12:02:55.329Z | 2024-09-12T12:19:03.545Z |
5004583 | 5004583 | 20240903114923_QEYPm | KR000A | 2024-09-09T12:02:49.226Z | 2024-09-12T12:19:03.157Z |
5004320 | 5004320 | 20240903111620_Xa4ov | KR000A | 2024-09-09T12:02:35.624Z | 2024-09-12T12:19:01.645Z |
5004294 | 5004294 | 20240903111435_W7mNt | KR000A | 2024-09-09T12:02:34.373Z | 2024-09-12T12:19:01.569Z |
5004224 | 5004224 | 20240903105923_GSQAg | KR000A | 2024-09-09T12:02:28.907Z | 2024-09-12T12:19:01.293Z |
5004221 | 5004221 | 20240903105838_PEOk8 | KR000A | 2024-09-09T12:02:28.712Z | 2024-09-12T12:19:01.271Z |
4996483 | 4996483 | 20240902194620_nmtDT | KR000A | 2024-09-08T12:04:51.781Z | 2024-09-11T12:20:54.853Z |
4996467 | 4996467 | 20240902194309_LW2n9 | KR000A | 2024-09-08T12:04:50.789Z | 2024-09-11T12:20:54.715Z |
4996101 | 4996101 | 20240902184021_hw56q | KR000A | 2024-09-08T12:04:22.283Z | 2024-09-11T12:20:51.153Z |
4996036 | 4996036 | 20240902183316_RL633 | KR000A | 2024-09-08T12:04:18.961Z | 2024-09-11T12:20:50.752Z |
4995972 | 4995972 | 20240902182239_5OgbF | KR000A | 2024-09-08T12:04:15.070Z | 2024-09-11T12:20:50.015Z |
4995910 | 4995910 | 20240902181024_q6fDz | KR000A | 2024-09-08T12:04:11.511Z | 2024-09-11T12:20:49.612Z |
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);