participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,397 rows where station_code = "SK0003" 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 |
---|---|---|---|---|---|
5132008 | 5132008 | 20240915224714_AlCdE | SK0003 | 2024-09-19T12:15:43.303Z | 2024-09-19T12:15:43.303Z |
5131489 | 5131489 | 20240915200149_tMpU8 | SK0003 | 2024-09-19T12:15:06.190Z | 2024-09-19T12:15:06.190Z |
5131239 | 5131239 | 20240915184736_onK6D | SK0003 | 2024-09-19T12:14:43.582Z | 2024-09-19T12:14:43.582Z |
5090380 | 5090380 | 20240912012321_nuYD7 | SK0003 | 2024-09-16T12:12:17.409Z | 2024-09-19T12:21:11.266Z |
5090146 | 5090146 | 20240912011229_8Wdq9 | SK0003 | 2024-09-16T12:12:02.801Z | 2024-09-19T12:21:11.028Z |
5089489 | 5089489 | 20240912004542_QXZt8 | SK0003 | 2024-09-16T12:11:26.955Z | 2024-09-19T12:21:09.991Z |
5080006 | 5080006 | 20240911032542_aDgvn | SK0003 | 2024-09-15T12:16:44.641Z | 2024-09-19T12:21:42.986Z |
5079925 | 5079925 | 20240911032100_1tYgC | SK0003 | 2024-09-15T12:16:41.940Z | 2024-09-19T12:21:42.847Z |
5079818 | 5079818 | 20240911031449_nDmj3 | SK0003 | 2024-09-15T12:16:37.563Z | 2024-09-19T12:21:42.684Z |
5079567 | 5079567 | 20240911030309_eb6RS | SK0003 | 2024-09-15T12:16:26.250Z | 2024-09-19T12:21:42.386Z |
5079375 | 5079375 | 20240911025118_Uk9V6 | SK0003 | 2024-09-15T12:16:17.877Z | 2024-09-19T12:21:41.542Z |
5078984 | 5078984 | 20240911022804_LTSlw | SK0003 | 2024-09-15T12:16:01.638Z | 2024-09-19T12:21:40.956Z |
5078863 | 5078863 | 20240911021735_iEonY | SK0003 | 2024-09-15T12:15:53.647Z | 2024-09-19T12:21:40.751Z |
5078252 | 5078252 | 20240911014602_S9RPc | SK0003 | 2024-09-15T12:15:29.074Z | 2024-09-19T12:21:40.121Z |
5078246 | 5078246 | 20240911014534_6t4DS | SK0003 | 2024-09-15T12:15:28.158Z | 2024-09-19T12:21:40.114Z |
5078235 | 5078235 | 20240911014424_cdrEX | SK0003 | 2024-09-15T12:15:26.776Z | 2024-09-19T12:21:40.100Z |
5077969 | 5077969 | 20240911013238_I3Wxi | SK0003 | 2024-09-15T12:15:13.140Z | 2024-09-19T12:21:39.840Z |
5077480 | 5077480 | 20240911005752_RJy3g | SK0003 | 2024-09-15T12:14:48.183Z | 2024-09-19T12:21:39.118Z |
5077385 | 5077385 | 20240911004853_807wc | SK0003 | 2024-09-15T12:14:40.878Z | 2024-09-19T12:21:38.842Z |
5077276 | 5077276 | 20240911004024_sGWlY | SK0003 | 2024-09-15T12:14:36.447Z | 2024-09-19T12:21:38.616Z |
5077227 | 5077227 | 20240911003609_lHl25 | SK0003 | 2024-09-15T12:14:32.843Z | 2024-09-19T12:21:38.535Z |
5077079 | 5077079 | 20240911002300_F2v1D | SK0003 | 2024-09-15T12:14:21.595Z | 2024-09-19T12:21:38.199Z |
5076561 | 5076561 | 20240910234642_2JxkR | SK0003 | 2024-09-15T12:13:43.115Z | 2024-09-19T12:21:37.345Z |
5076471 | 5076471 | 20240910233817_bZgGG | SK0003 | 2024-09-15T12:13:36.587Z | 2024-09-19T12:21:37.284Z |
5076165 | 5076165 | 20240910231037_Nm7T8 | SK0003 | 2024-09-15T12:13:20.984Z | 2024-09-19T12:21:36.539Z |
5075628 | 5075628 | 20240911235831_MQjsV | SK0003 | 2024-09-15T12:10:05.771Z | 2024-09-19T12:21:09.389Z |
5075121 | 5075121 | 20240911232923_hO1Jv | SK0003 | 2024-09-15T12:09:25.509Z | 2024-09-19T12:21:08.416Z |
5074722 | 5074722 | 20240911225733_Wp927 | SK0003 | 2024-09-15T12:08:46.140Z | 2024-09-19T12:21:07.632Z |
5074327 | 5074327 | 20240911222952_2wg5f | SK0003 | 2024-09-15T12:08:23.173Z | 2024-09-19T12:21:07.078Z |
5073745 | 5073745 | 20240911214236_G20uJ | SK0003 | 2024-09-15T12:07:36.821Z | 2024-09-19T12:21:06.173Z |
5073455 | 5073455 | 20240911212624_u0RqI | SK0003 | 2024-09-15T12:07:12.047Z | 2024-09-19T12:21:05.822Z |
5070252 | 5070252 | 20240910224642_2KwPk | SK0003 | 2024-09-14T12:20:17.304Z | 2024-09-19T12:21:35.952Z |
5070022 | 5070022 | 20240910222446_EAhi0 | SK0003 | 2024-09-14T12:20:12.018Z | 2024-09-19T12:21:35.601Z |
5065153 | 5065153 | 20240910031602_3zPRN | SK0003 | 2024-09-14T12:16:29.338Z | 2024-09-18T12:15:18.525Z |
5065023 | 5065023 | 20240910025459_J2zwD | SK0003 | 2024-09-14T12:16:18.228Z | 2024-09-18T12:15:18.159Z |
5064959 | 5064959 | 20240910024244_kkMXS | SK0003 | 2024-09-14T12:16:13.076Z | 2024-09-18T12:15:17.973Z |
5064903 | 5064903 | 20240910022435_JojB8 | SK0003 | 2024-09-14T12:16:09.138Z | 2024-09-18T12:15:17.720Z |
5064862 | 5064862 | 20240910021820_RSU2H | SK0003 | 2024-09-14T12:16:07.124Z | 2024-09-18T12:15:17.562Z |
5063541 | 5063541 | 20240909214100_kt8ya | SK0003 | 2024-09-14T12:14:05.859Z | 2024-09-18T12:15:14.160Z |
5060546 | 5060546 | 20240910203730_sAEc0 | SK0003 | 2024-09-14T12:09:07.137Z | 2024-09-19T12:21:32.582Z |
5060180 | 5060180 | 20240910200311_XYlKf | SK0003 | 2024-09-14T12:08:26.984Z | 2024-09-19T12:21:31.961Z |
5054601 | 5054601 | 20240908031727_V5NXj | SK0003 | 2024-09-13T12:16:48.162Z | 2024-09-16T12:21:16.174Z |
5054565 | 5054565 | 20240908031040_po1Xm | SK0003 | 2024-09-13T12:16:46.935Z | 2024-09-16T12:21:16.056Z |
5054515 | 5054515 | 20240908030330_RU65n | SK0003 | 2024-09-13T12:16:45.699Z | 2024-09-16T12:21:15.874Z |
5054231 | 5054231 | 20240908023030_F6p55 | SK0003 | 2024-09-13T12:16:34.628Z | 2024-09-16T12:21:14.595Z |
5053900 | 5053900 | 20240908014558_wG1Bd | SK0003 | 2024-09-13T12:16:21.174Z | 2024-09-16T12:21:13.086Z |
5053851 | 5053851 | 20240908014059_mBK7b | SK0003 | 2024-09-13T12:16:19.801Z | 2024-09-16T12:21:12.932Z |
5053396 | 5053396 | 20240908002808_kNMex | SK0003 | 2024-09-13T12:16:02.891Z | 2024-09-16T12:21:10.543Z |
5053371 | 5053371 | 20240908002140_HcBsj | SK0003 | 2024-09-13T12:16:01.927Z | 2024-09-16T12:21:10.442Z |
5053018 | 5053018 | 20240907230118_G1oDf | SK0003 | 2024-09-13T12:15:42.115Z | 2024-09-16T12:21:08.952Z |
5052540 | 5052540 | 20240907210031_XGxAh | SK0003 | 2024-09-13T12:15:13.184Z | 2024-09-16T12:21:06.192Z |
5052523 | 5052523 | 20240907205815_075PR | SK0003 | 2024-09-13T12:15:12.582Z | 2024-09-16T12:21:06.107Z |
5052282 | 5052282 | 20240907200837_hXs8Y | SK0003 | 2024-09-13T12:15:02.774Z | 2024-09-16T12:21:04.960Z |
5051795 | 5051795 | 20240907183952_CjOKa | SK0003 | 2024-09-13T12:14:34.206Z | 2024-09-16T12:21:01.943Z |
5039913 | 5039913 | 20240906022551_Z6Qx4 | SK0003 | 2024-09-12T12:15:50.642Z | 2024-09-14T12:23:05.803Z |
5039032 | 5039032 | 20240905230903_XufrM | SK0003 | 2024-09-12T12:15:13.364Z | 2024-09-14T12:22:59.882Z |
5038961 | 5038961 | 20240905224855_MA4GB | SK0003 | 2024-09-12T12:15:09.993Z | 2024-09-14T12:22:59.587Z |
5038731 | 5038731 | 20240905213408_Z8Etc | SK0003 | 2024-09-12T12:14:57.084Z | 2024-09-14T12:22:57.413Z |
5038656 | 5038656 | 20240905211840_y16eJ | SK0003 | 2024-09-12T12:14:53.861Z | 2024-09-14T12:22:57.074Z |
5038621 | 5038621 | 20240905211141_Y5Otq | SK0003 | 2024-09-12T12:14:51.506Z | 2024-09-14T12:22:56.674Z |
5038297 | 5038297 | 20240905190522_RJILB | SK0003 | 2024-09-12T12:14:31.962Z | 2024-09-14T12:22:55.544Z |
5033482 | 5033482 | 20240907030232_jghRo | SK0003 | 2024-09-12T12:09:34.206Z | 2024-09-15T12:21:30.210Z |
5033245 | 5033245 | 20240907024124_eIaT2 | SK0003 | 2024-09-12T12:09:02.083Z | 2024-09-15T12:21:29.357Z |
5032980 | 5032980 | 20240907021046_sPl8D | SK0003 | 2024-09-12T12:08:41.166Z | 2024-09-15T12:21:28.692Z |
5032962 | 5032962 | 20240907020718_27OnA | SK0003 | 2024-09-12T12:08:37.242Z | 2024-09-15T12:21:28.641Z |
5032341 | 5032341 | 20240907004853_DrWKy | SK0003 | 2024-09-12T12:07:08.906Z | 2024-09-15T12:21:26.196Z |
5032144 | 5032144 | 20240907001943_IcxJ3 | SK0003 | 2024-09-12T12:06:37.778Z | 2024-09-15T12:21:25.354Z |
5031787 | 5031787 | 20240906231739_muQd9 | SK0003 | 2024-09-12T12:05:48.525Z | 2024-09-15T12:21:24.306Z |
5031666 | 5031666 | 20240906225454_ID7Yi | SK0003 | 2024-09-12T12:05:23.487Z | 2024-09-15T12:21:23.827Z |
5031585 | 5031585 | 20240906223714_t3KwB | SK0003 | 2024-09-12T12:05:13.454Z | 2024-09-15T12:21:23.274Z |
5031536 | 5031536 | 20240906222303_pOjYn | SK0003 | 2024-09-12T12:05:07.635Z | 2024-09-15T12:21:22.827Z |
5031499 | 5031499 | 20240906221031_DjHWl | SK0003 | 2024-09-12T12:05:03.372Z | 2024-09-15T12:21:22.733Z |
5031458 | 5031458 | 20240906220014_MOt7K | SK0003 | 2024-09-12T12:04:54.769Z | 2024-09-15T12:21:22.527Z |
5031272 | 5031272 | 20240906210622_qOqi0 | SK0003 | 2024-09-12T12:04:24.975Z | 2024-09-15T12:21:21.871Z |
5026291 | 5026291 | 20240905025742_bh4Wj | SK0003 | 2024-09-11T12:12:13.518Z | 2024-09-13T12:19:57.527Z |
5026175 | 5026175 | 20240905023128_p0Od4 | SK0003 | 2024-09-11T12:12:01.566Z | 2024-09-13T12:19:57.064Z |
5026131 | 5026131 | 20240905022203_qbV24 | SK0003 | 2024-09-11T12:11:57.694Z | 2024-09-13T12:19:56.927Z |
5025779 | 5025779 | 20240905011403_zDpJG | SK0003 | 2024-09-11T12:11:00.848Z | 2024-09-13T12:19:55.608Z |
5025770 | 5025770 | 20240905011228_C2UhF | SK0003 | 2024-09-11T12:10:58.917Z | 2024-09-13T12:19:55.560Z |
5025697 | 5025697 | 20240905005743_2odIZ | SK0003 | 2024-09-11T12:10:48.098Z | 2024-09-13T12:19:55.230Z |
5025594 | 5025594 | 20240906022551_w4VYX | SK0003 | 2024-09-11T12:06:54.845Z | 2024-09-11T12:16:32.708Z |
5024615 | 5024615 | 20240905230903_hdURx | SK0003 | 2024-09-11T12:04:15.328Z | 2024-09-11T12:16:32.228Z |
5024544 | 5024544 | 20240905224855_O4Q3B | SK0003 | 2024-09-11T12:04:02.645Z | 2024-09-11T12:16:32.188Z |
5024306 | 5024306 | 20240905213408_uOKf3 | SK0003 | 2024-09-11T12:03:17.741Z | 2024-09-11T12:16:32.060Z |
5024226 | 5024226 | 20240905211840_dUjQC | SK0003 | 2024-09-11T12:03:00.334Z | 2024-09-11T12:16:32.016Z |
5024191 | 5024191 | 20240905211141_H2yUs | SK0003 | 2024-09-11T12:02:52.811Z | 2024-09-11T12:16:31.991Z |
5020741 | 5020741 | 20240905025742_eC2kQ | SK0003 | 2024-09-10T12:14:59.261Z | 2024-09-13T12:19:57.526Z |
5020612 | 5020612 | 20240905023128_F91Jc | SK0003 | 2024-09-10T12:14:49.282Z | 2024-09-10T12:16:55.194Z |
5020569 | 5020569 | 20240905022203_abtWC | SK0003 | 2024-09-10T12:14:44.049Z | 2024-09-13T12:19:56.912Z |
5020202 | 5020202 | 20240905011403_M2n32 | SK0003 | 2024-09-10T12:14:04.002Z | 2024-09-10T12:16:55.096Z |
5020189 | 5020189 | 20240905011228_vhGI3 | SK0003 | 2024-09-10T12:14:02.945Z | 2024-09-10T12:16:55.093Z |
5020116 | 5020116 | 20240905005743_bJ8PG | SK0003 | 2024-09-10T12:13:56.948Z | 2024-09-10T12:16:55.074Z |
5020042 | 5020042 | 20240905004517_W0f5O | SK0003 | 2024-09-10T12:13:51.681Z | 2024-09-13T12:19:54.901Z |
5019911 | 5019911 | 20240905001705_1qP4O | SK0003 | 2024-09-10T12:13:42.695Z | 2024-09-13T12:19:54.401Z |
5019102 | 5019102 | 20240904215104_03SCP | SK0003 | 2024-09-10T12:12:06.663Z | 2024-09-13T12:19:50.478Z |
5019068 | 5019068 | 20240904214010_tKkCu | SK0003 | 2024-09-10T12:12:01.646Z | 2024-09-13T12:19:50.331Z |
5018808 | 5018808 | 20240904203430_58fE7 | SK0003 | 2024-09-10T12:11:35.442Z | 2024-09-13T12:19:49.134Z |
5018788 | 5018788 | 20240904202340_w6396 | SK0003 | 2024-09-10T12:11:33.342Z | 2024-09-13T12:19:48.968Z |
5010400 | 5010400 | 20240904030256_fBZEr | SK0003 | 2024-09-09T12:08:45.004Z | 2024-09-12T12:19:27.243Z |
5009941 | 5009941 | 20240904021922_PfeB3 | SK0003 | 2024-09-09T12:08:15.247Z | 2024-09-12T12:19:25.021Z |
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);