participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,570 rows where station_code = "KR002D" 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 |
---|---|---|---|---|---|
5467191 | 5467191 | 20241102202211_UIopG | KR002D | 2024-11-04T14:11:04.535Z | 2024-11-04T14:18:00.254Z |
5467134 | 5467134 | 20241102201414_03nrA | KR002D | 2024-11-04T14:10:46.769Z | 2024-11-04T14:18:00.215Z |
5467125 | 5467125 | 20241102201246_AQm6y | KR002D | 2024-11-04T14:10:44.803Z | 2024-11-04T14:18:00.204Z |
5467116 | 5467116 | 20241102201029_jEg20 | KR002D | 2024-11-04T14:10:43.233Z | 2024-11-04T14:18:00.200Z |
5467051 | 5467051 | 20241102195544_YJzH2 | KR002D | 2024-11-04T14:10:31.914Z | 2024-11-04T14:18:00.163Z |
5467041 | 5467041 | 20241102195056_AUG3V | KR002D | 2024-11-04T14:10:30.444Z | 2024-11-04T14:18:00.159Z |
5466949 | 5466949 | 20241102192850_4p5CJ | KR002D | 2024-11-04T14:10:21.364Z | 2024-11-04T14:18:00.124Z |
5466942 | 5466942 | 20241102192713_h2zjw | KR002D | 2024-11-04T14:10:20.550Z | 2024-11-04T14:18:00.112Z |
5466787 | 5466787 | 20241102185653_Sjni9 | KR002D | 2024-11-04T14:09:48.316Z | 2024-11-04T14:18:00.055Z |
5466733 | 5466733 | 20241102184313_coQvj | KR002D | 2024-11-04T14:09:39.400Z | 2024-11-04T14:18:00.032Z |
5466699 | 5466699 | 20241102183633_YDKM2 | KR002D | 2024-11-04T14:09:35.141Z | 2024-11-04T14:18:00.020Z |
5466669 | 5466669 | 20241102183003_2SSpH | KR002D | 2024-11-04T14:09:31.982Z | 2024-11-04T14:18:00.002Z |
5466632 | 5466632 | 20241102182143_irxiB | KR002D | 2024-11-04T14:09:27.692Z | 2024-11-04T14:17:59.988Z |
5466613 | 5466613 | 20241102181722_EFy2R | KR002D | 2024-11-04T14:09:25.307Z | 2024-11-04T14:17:59.981Z |
5466454 | 5466454 | 20241102174415_mvS2d | KR002D | 2024-11-04T14:08:55.513Z | 2024-11-04T14:17:59.904Z |
5466410 | 5466410 | 20241102173408_FTOVw | KR002D | 2024-11-04T14:08:48.640Z | 2024-11-04T14:17:59.882Z |
5466320 | 5466320 | 20241102171237_wNL2F | KR002D | 2024-11-04T14:08:36.969Z | 2024-11-04T14:17:59.818Z |
5466227 | 5466227 | 20241102165417_ylnmg | KR002D | 2024-11-04T14:08:19.364Z | 2024-11-04T14:17:59.693Z |
5466215 | 5466215 | 20241102164953_fQEQG | KR002D | 2024-11-04T14:08:16.784Z | 2024-11-04T14:17:59.684Z |
5466155 | 5466155 | 20241102163622_mcAcq | KR002D | 2024-11-04T14:08:07.145Z | 2024-11-04T14:17:59.646Z |
5466116 | 5466116 | 20241102162617_W4V1v | KR002D | 2024-11-04T14:08:03.179Z | 2024-11-04T14:17:59.616Z |
5466114 | 5466114 | 20241102162423_MYRTE | KR002D | 2024-11-04T14:08:02.854Z | 2024-11-04T14:17:59.615Z |
5466096 | 5466096 | 20241102161809_xXYkP | KR002D | 2024-11-04T14:08:00.242Z | 2024-11-04T14:17:59.600Z |
5465971 | 5465971 | 20241102154407_bRC9m | KR002D | 2024-11-04T14:07:36.188Z | 2024-11-04T14:17:59.460Z |
5465961 | 5465961 | 20241102153740_HXrqK | KR002D | 2024-11-04T14:07:34.025Z | 2024-11-04T14:17:59.437Z |
5465871 | 5465871 | 20241102150318_zWTxg | KR002D | 2024-11-04T14:07:16.142Z | 2024-11-04T14:17:59.085Z |
5465845 | 5465845 | 20241102144935_R0g8n | KR002D | 2024-11-04T14:07:12.150Z | 2024-11-04T14:17:59.044Z |
5465829 | 5465829 | 20241102143357_NR3RU | KR002D | 2024-11-04T14:06:54.988Z | 2024-11-04T14:17:58.977Z |
5465825 | 5465825 | 20241102142843_uNO3X | KR002D | 2024-11-04T14:06:52.840Z | 2024-11-04T14:17:58.959Z |
5465806 | 5465806 | 20241102141020_2x37b | KR002D | 2024-11-04T14:06:46.119Z | 2024-11-04T14:17:58.831Z |
5465753 | 5465753 | 20241102134512_wJoi2 | KR002D | 2024-11-04T14:06:36.508Z | 2024-11-04T14:17:58.699Z |
5465601 | 5465601 | 20241102120411_N0v9u | KR002D | 2024-11-04T14:05:44.159Z | 2024-11-04T14:17:58.270Z |
5465526 | 5465526 | 20241102100425_2hLyU | KR002D | 2024-11-04T14:04:51.543Z | 2024-11-04T14:17:57.787Z |
5438480 | 5438480 | 20241030172354_ohRph | KR002D | 2024-11-01T12:11:46.281Z | 2024-11-04T14:24:39.076Z |
5437974 | 5437974 | 20241030160851_LwZGM | KR002D | 2024-11-01T12:10:47.996Z | 2024-11-04T14:24:34.898Z |
5436427 | 5436427 | 20241030130628_JAMPr | KR002D | 2024-11-01T12:07:34.066Z | 2024-11-04T14:24:21.433Z |
5436223 | 5436223 | 20241030123851_uE2wt | KR002D | 2024-11-01T12:07:07.717Z | 2024-11-04T14:24:19.125Z |
5435355 | 5435355 | 20241030112054_AAqtF | KR002D | 2024-11-01T12:04:59.627Z | 2024-11-04T14:24:10.381Z |
5434776 | 5434776 | 20241030101217_Eof3R | KR002D | 2024-11-01T12:03:20.719Z | 2024-11-04T14:24:03.025Z |
5433694 | 5433694 | 20241029205357_OGN3Q | KR002D | 2024-10-31T12:22:27.911Z | 2024-11-04T14:26:14.816Z |
5433676 | 5433676 | 20241029204405_vhveF | KR002D | 2024-10-31T12:22:27.202Z | 2024-11-04T14:26:14.644Z |
5433589 | 5433589 | 20241029202806_9SZ3f | KR002D | 2024-10-31T12:22:23.367Z | 2024-11-04T14:26:13.973Z |
5433587 | 5433587 | 20241029202742_c0U13 | KR002D | 2024-10-31T12:22:23.313Z | 2024-11-04T14:26:13.969Z |
5433543 | 5433543 | 20241029201719_o3iFV | KR002D | 2024-10-31T12:22:21.217Z | 2024-11-04T14:26:13.739Z |
5426520 | 5426520 | 20241029200028_43ImC | KR002D | 2024-10-31T12:10:12.188Z | 2024-11-04T14:26:12.888Z |
5426469 | 5426469 | 20241029195218_2Qx3k | KR002D | 2024-10-31T12:10:02.487Z | 2024-11-04T14:26:11.910Z |
5426411 | 5426411 | 20241029194641_uptVG | KR002D | 2024-10-31T12:09:57.778Z | 2024-11-04T14:26:11.538Z |
5426409 | 5426409 | 20241029194627_ikvC7 | KR002D | 2024-10-31T12:09:57.598Z | 2024-11-04T14:26:11.528Z |
5426269 | 5426269 | 20241029192159_Q4Nsj | KR002D | 2024-10-31T12:09:45.741Z | 2024-11-04T14:26:09.603Z |
5426192 | 5426192 | 20241029190743_AibHW | KR002D | 2024-10-31T12:09:35.816Z | 2024-11-04T14:26:08.867Z |
5426107 | 5426107 | 20241029184704_jaiME | KR002D | 2024-10-31T12:09:20.331Z | 2024-11-04T14:26:07.804Z |
5426100 | 5426100 | 20241029184532_r15XQ | KR002D | 2024-10-31T12:09:18.663Z | 2024-11-04T14:26:07.726Z |
5426082 | 5426082 | 20241029183915_jNwC0 | KR002D | 2024-10-31T12:09:14.444Z | 2024-11-04T14:26:07.501Z |
5426076 | 5426076 | 20241029183854_fE5cN | KR002D | 2024-10-31T12:09:13.055Z | 2024-11-04T14:26:07.475Z |
5426044 | 5426044 | 20241029183454_xhT2R | KR002D | 2024-10-31T12:09:09.664Z | 2024-11-04T14:26:07.355Z |
5426034 | 5426034 | 20241029183314_1bLIU | KR002D | 2024-10-31T12:09:09.011Z | 2024-11-04T14:26:07.287Z |
5426019 | 5426019 | 20241029182907_IJRD1 | KR002D | 2024-10-31T12:09:06.244Z | 2024-11-04T14:26:07.054Z |
5425927 | 5425927 | 20241029181723_elG5h | KR002D | 2024-10-31T12:08:58.477Z | 2024-11-04T14:26:06.035Z |
5425896 | 5425896 | 20241029180901_QchWl | KR002D | 2024-10-31T12:08:55.326Z | 2024-11-04T14:26:05.501Z |
5425832 | 5425832 | 20241029180216_ZyRj6 | KR002D | 2024-10-31T12:08:49.796Z | 2024-11-04T14:26:05.141Z |
5425591 | 5425591 | 20241029171902_m3Bri | KR002D | 2024-10-31T12:08:09.672Z | 2024-11-04T14:26:03.983Z |
5425505 | 5425505 | 20241029170319_3oKFN | KR002D | 2024-10-31T12:07:58.096Z | 2024-11-04T14:26:03.316Z |
5425483 | 5425483 | 20241029165924_7IWvY | KR002D | 2024-10-31T12:07:49.556Z | 2024-11-04T14:26:03.046Z |
5425430 | 5425430 | 20241029164617_k32rz | KR002D | 2024-10-31T12:07:38.809Z | 2024-11-04T14:26:02.885Z |
5425386 | 5425386 | 20241029163604_M1Szz | KR002D | 2024-10-31T12:07:33.576Z | 2024-11-04T14:26:02.407Z |
5425379 | 5425379 | 20241029163309_xDwGw | KR002D | 2024-10-31T12:07:32.925Z | 2024-11-04T14:26:02.359Z |
5425151 | 5425151 | 20241029160145_G56tw | KR002D | 2024-10-31T12:06:57.446Z | 2024-11-04T14:26:01.515Z |
5424930 | 5424930 | 20241029153309_KqLzl | KR002D | 2024-10-31T12:06:30.885Z | 2024-11-04T14:26:00.619Z |
5424735 | 5424735 | 20241029150631_tYF2k | KR002D | 2024-10-31T12:05:56.159Z | 2024-11-04T14:25:58.484Z |
5424416 | 5424416 | 20241029141833_RRlx6 | KR002D | 2024-10-31T12:05:00.571Z | 2024-11-04T14:25:56.455Z |
5424387 | 5424387 | 20241029141436_0XXkd | KR002D | 2024-10-31T12:04:56.064Z | 2024-11-04T14:25:56.352Z |
5424283 | 5424283 | 20241029135241_ZgxaJ | KR002D | 2024-10-31T12:04:29.418Z | 2024-11-04T14:25:55.342Z |
5424190 | 5424190 | 20241029133607_bw3Es | KR002D | 2024-10-31T12:04:14.358Z | 2024-11-04T14:25:54.434Z |
5423796 | 5423796 | 20241029120140_P92Os | KR002D | 2024-10-31T12:02:49.473Z | 2024-11-04T14:25:49.177Z |
5418371 | 5418371 | 20241027203220_Lemwg | KR002D | 2024-10-30T12:15:36.374Z | 2024-11-04T14:28:03.071Z |
5418365 | 5418365 | 20241027203015_LFR43 | KR002D | 2024-10-30T12:15:35.770Z | 2024-11-04T14:28:03.055Z |
5418361 | 5418361 | 20241027203006_P3F1O | KR002D | 2024-10-30T12:15:35.399Z | 2024-11-04T14:28:03.038Z |
5418319 | 5418319 | 20241027202224_3MWAp | KR002D | 2024-10-30T12:15:26.835Z | 2024-11-04T14:28:02.756Z |
5418256 | 5418256 | 20241027201336_XLEqd | KR002D | 2024-10-30T12:15:13.648Z | 2024-11-04T14:28:02.465Z |
5418106 | 5418106 | 20241027195541_TyDld | KR002D | 2024-10-30T12:14:53.685Z | 2024-11-04T14:28:01.738Z |
5418099 | 5418099 | 20241027195415_2dadq | KR002D | 2024-10-30T12:14:52.667Z | 2024-11-04T14:28:01.725Z |
5418097 | 5418097 | 20241027195357_0xcE4 | KR002D | 2024-10-30T12:14:52.394Z | 2024-11-04T14:28:01.681Z |
5417867 | 5417867 | 20241027192350_TFKuu | KR002D | 2024-10-30T12:14:34.134Z | 2024-11-04T14:28:00.838Z |
5417854 | 5417854 | 20241027192155_VCE39 | KR002D | 2024-10-30T12:14:32.871Z | 2024-11-04T14:28:00.602Z |
5417807 | 5417807 | 20241027191505_1gK4Z | KR002D | 2024-10-30T12:14:29.159Z | 2024-11-04T14:27:59.827Z |
5417793 | 5417793 | 20241027191330_JRRpy | KR002D | 2024-10-30T12:14:28.323Z | 2024-11-04T14:27:59.619Z |
5417621 | 5417621 | 20241027185354_cd3xw | KR002D | 2024-10-30T12:14:00.301Z | 2024-11-04T14:27:58.848Z |
5416966 | 5416966 | 20241027172848_GBna9 | KR002D | 2024-10-30T12:12:39.461Z | 2024-11-04T14:27:55.474Z |
5416827 | 5416827 | 20241027170639_juvl5 | KR002D | 2024-10-30T12:12:28.665Z | 2024-11-04T14:27:54.604Z |
5394596 | 5394596 | 20241025205447_XkKmz | KR002D | 2024-10-28T12:15:02.521Z | 2024-11-03T14:27:21.792Z |
5394449 | 5394449 | 20241025203726_JKaSH | KR002D | 2024-10-28T12:14:42.000Z | 2024-11-03T14:27:21.254Z |
5394431 | 5394431 | 20241025203425_7NVDj | KR002D | 2024-10-28T12:14:38.627Z | 2024-11-03T14:27:21.190Z |
5394411 | 5394411 | 20241025203205_JXNH0 | KR002D | 2024-10-28T12:14:35.736Z | 2024-11-03T14:27:21.162Z |
5394332 | 5394332 | 20241025201628_jTZ7t | KR002D | 2024-10-28T12:14:23.727Z | 2024-11-03T14:27:20.912Z |
5394286 | 5394286 | 20241025200949_FCicq | KR002D | 2024-10-28T12:14:18.865Z | 2024-11-03T14:27:20.620Z |
5394278 | 5394278 | 20241025200854_aV4ag | KR002D | 2024-10-28T12:14:17.920Z | 2024-11-03T14:27:20.615Z |
5394237 | 5394237 | 20241025200208_K3F17 | KR002D | 2024-10-28T12:14:14.786Z | 2024-11-03T14:27:20.418Z |
5394220 | 5394220 | 20241025195846_0DLge | KR002D | 2024-10-28T12:14:12.027Z | 2024-11-03T14:27:20.387Z |
5394102 | 5394102 | 20241025193553_wElQO | KR002D | 2024-10-28T12:14:03.592Z | 2024-11-03T14:27:19.875Z |
5394100 | 5394100 | 20241025193546_coFPx | KR002D | 2024-10-28T12:14:03.559Z | 2024-11-03T14:27:19.874Z |
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);