participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,185 rows where station_code = "CZ000M" 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 |
---|---|---|---|---|---|
5131488 | 5131488 | 20240915200149_tMpU8 | CZ000M | 2024-09-19T12:15:06.190Z | 2024-09-19T12:15:06.190Z |
5079817 | 5079817 | 20240911031449_nDmj3 | CZ000M | 2024-09-15T12:16:37.563Z | 2024-09-19T12:21:42.684Z |
5078796 | 5078796 | 20240911021555_xMk3H | CZ000M | 2024-09-15T12:15:52.274Z | 2024-09-19T12:21:40.715Z |
5078262 | 5078262 | 20240911014633_WNbRX | CZ000M | 2024-09-15T12:15:30.866Z | 2024-09-19T12:21:40.131Z |
5078233 | 5078233 | 20240911014405_Dsf3Y | CZ000M | 2024-09-15T12:15:26.249Z | 2024-09-19T12:21:40.081Z |
5078231 | 5078231 | 20240911014405_q49rr | CZ000M | 2024-09-15T12:15:25.547Z | 2024-09-19T12:21:40.079Z |
5077742 | 5077742 | 20240911011340_ehq5k | CZ000M | 2024-09-15T12:15:02.604Z | 2024-09-19T12:21:39.590Z |
5077477 | 5077477 | 20240911005749_OuKaK | CZ000M | 2024-09-15T12:14:47.965Z | 2024-09-19T12:21:39.100Z |
5060156 | 5060156 | 20240910195957_5gCVx | CZ000M | 2024-09-14T12:08:24.787Z | 2024-09-19T12:21:31.874Z |
5059942 | 5059942 | 20240910192257_UVGJ3 | CZ000M | 2024-09-14T12:07:46.854Z | 2024-09-19T12:21:31.485Z |
5054325 | 5054325 | 20240908024012_Wx7Vq | CZ000M | 2024-09-13T12:16:38.266Z | 2024-09-16T12:21:14.932Z |
5054273 | 5054273 | 20240908023540_S6ibH | CZ000M | 2024-09-13T12:16:35.998Z | 2024-09-16T12:21:14.721Z |
5054064 | 5054064 | 20240908020528_Bsp2X | CZ000M | 2024-09-13T12:16:27.967Z | 2024-09-16T12:21:13.867Z |
5054060 | 5054060 | 20240908020500_3hf7b | CZ000M | 2024-09-13T12:16:27.727Z | 2024-09-16T12:21:13.855Z |
5053847 | 5053847 | 20240908014058_Gc6FK | CZ000M | 2024-09-13T12:16:19.741Z | 2024-09-16T12:21:12.908Z |
5053845 | 5053845 | 20240908013915_4Totl | CZ000M | 2024-09-13T12:16:19.643Z | 2024-09-16T12:21:12.904Z |
5053783 | 5053783 | 20240908012941_4tzJ6 | CZ000M | 2024-09-13T12:16:17.396Z | 2024-09-16T12:21:12.771Z |
5053751 | 5053751 | 20240908012338_N5fZZ | CZ000M | 2024-09-13T12:16:16.507Z | 2024-09-16T12:21:12.642Z |
5053667 | 5053667 | 20240908011344_dM4Ij | CZ000M | 2024-09-13T12:16:12.894Z | 2024-09-16T12:21:12.341Z |
5053629 | 5053629 | 20240908010938_YLpJk | CZ000M | 2024-09-13T12:16:10.928Z | 2024-09-16T12:21:12.190Z |
5053545 | 5053545 | 20240908005402_3FpLh | CZ000M | 2024-09-13T12:16:08.192Z | 2024-09-16T12:21:11.888Z |
5053481 | 5053481 | 20240908004250_ddgpk | CZ000M | 2024-09-13T12:16:05.677Z | 2024-09-16T12:21:11.565Z |
5053330 | 5053330 | 20240908001114_Ncwbe | CZ000M | 2024-09-13T12:15:58.983Z | 2024-09-16T12:21:10.337Z |
5053139 | 5053139 | 20240907233246_edNdv | CZ000M | 2024-09-13T12:15:49.152Z | 2024-09-16T12:21:09.730Z |
5053078 | 5053078 | 20240907231727_IC5sD | CZ000M | 2024-09-13T12:15:45.167Z | 2024-09-16T12:21:09.436Z |
5053047 | 5053047 | 20240907230911_HHR1h | CZ000M | 2024-09-13T12:15:43.499Z | 2024-09-16T12:21:09.177Z |
5052987 | 5052987 | 20240907225537_3AOZc | CZ000M | 2024-09-13T12:15:40.310Z | 2024-09-16T12:21:08.865Z |
5052949 | 5052949 | 20240907224524_6cgxT | CZ000M | 2024-09-13T12:15:37.698Z | 2024-09-16T12:21:08.675Z |
5052908 | 5052908 | 20240907223346_4aELH | CZ000M | 2024-09-13T12:15:35.484Z | 2024-09-16T12:21:08.565Z |
5052902 | 5052902 | 20240907223247_XxnfZ | CZ000M | 2024-09-13T12:15:35.243Z | 2024-09-16T12:21:08.549Z |
5052887 | 5052887 | 20240907222955_lrBRj | CZ000M | 2024-09-13T12:15:34.175Z | 2024-09-16T12:21:08.464Z |
5052785 | 5052785 | 20240907220533_ywSvW | CZ000M | 2024-09-13T12:15:26.685Z | 2024-09-16T12:21:07.676Z |
5052776 | 5052776 | 20240907220234_TWDfo | CZ000M | 2024-09-13T12:15:26.455Z | 2024-09-16T12:21:07.641Z |
5052462 | 5052462 | 20240907204656_v24ol | CZ000M | 2024-09-13T12:15:09.824Z | 2024-09-16T12:21:05.671Z |
5052365 | 5052365 | 20240907202738_FC1bf | CZ000M | 2024-09-13T12:15:05.600Z | 2024-09-16T12:21:05.259Z |
5052279 | 5052279 | 20240907200809_JGJ58 | CZ000M | 2024-09-13T12:15:02.638Z | 2024-09-16T12:21:04.946Z |
5052230 | 5052230 | 20240907200041_dE3PD | CZ000M | 2024-09-13T12:15:01.004Z | 2024-09-16T12:21:04.701Z |
5052049 | 5052049 | 20240907193108_6u3ka | CZ000M | 2024-09-13T12:14:54.868Z | 2024-09-16T12:21:03.344Z |
5040178 | 5040178 | 20240906031104_6R32B | CZ000M | 2024-09-12T12:16:01.130Z | 2024-09-14T12:23:08.105Z |
5040151 | 5040151 | 20240906030614_f9QQY | CZ000M | 2024-09-12T12:15:59.493Z | 2024-09-14T12:23:07.844Z |
5039996 | 5039996 | 20240906024252_HsWZ9 | CZ000M | 2024-09-12T12:15:54.125Z | 2024-09-14T12:23:06.471Z |
5039830 | 5039830 | 20240906020556_i3pte | CZ000M | 2024-09-12T12:15:46.534Z | 2024-09-14T12:23:05.236Z |
5039663 | 5039663 | 20240906014726_wQvIp | CZ000M | 2024-09-12T12:15:41.492Z | 2024-09-14T12:23:03.913Z |
5039653 | 5039653 | 20240906014631_xH3pQ | CZ000M | 2024-09-12T12:15:41.309Z | 2024-09-14T12:23:03.896Z |
5039632 | 5039632 | 20240906014014_wgN32 | CZ000M | 2024-09-12T12:15:39.629Z | 2024-09-14T12:23:03.843Z |
5039621 | 5039621 | 20240906013536_9NMy6 | CZ000M | 2024-09-12T12:15:39.028Z | 2024-09-14T12:23:03.772Z |
5039514 | 5039514 | 20240906011631_XBD29 | CZ000M | 2024-09-12T12:15:36.245Z | 2024-09-14T12:23:03.221Z |
5039249 | 5039249 | 20240906000105_Oz9iI | CZ000M | 2024-09-12T12:15:22.570Z | 2024-09-14T12:23:01.071Z |
5039228 | 5039228 | 20240905235524_u23ES | CZ000M | 2024-09-12T12:15:21.816Z | 2024-09-14T12:23:01.006Z |
5039204 | 5039204 | 20240905234919_iEWDn | CZ000M | 2024-09-12T12:15:21.062Z | 2024-09-14T12:23:00.771Z |
5039173 | 5039173 | 20240905234453_3qTO3 | CZ000M | 2024-09-12T12:15:19.904Z | 2024-09-14T12:23:00.637Z |
5039019 | 5039019 | 20240905230422_62khp | CZ000M | 2024-09-12T12:15:12.761Z | 2024-09-14T12:22:59.795Z |
5039016 | 5039016 | 20240905230330_MZ736 | CZ000M | 2024-09-12T12:15:12.685Z | 2024-09-14T12:22:59.782Z |
5038901 | 5038901 | 20240905223015_BMOfQ | CZ000M | 2024-09-12T12:15:06.600Z | 2024-09-14T12:22:59.163Z |
5038860 | 5038860 | 20240905222125_D2mOB | CZ000M | 2024-09-12T12:15:04.789Z | 2024-09-14T12:22:58.664Z |
5038668 | 5038668 | 20240905212052_TOyjh | CZ000M | 2024-09-12T12:14:54.243Z | 2024-09-14T12:22:57.096Z |
5038641 | 5038641 | 20240905211705_wMwo8 | CZ000M | 2024-09-12T12:14:52.534Z | 2024-09-14T12:22:56.972Z |
5038472 | 5038472 | 20240905202613_COL7P | CZ000M | 2024-09-12T12:14:43.104Z | 2024-09-14T12:22:56.217Z |
5038463 | 5038463 | 20240905202302_zWLCQ | CZ000M | 2024-09-12T12:14:42.550Z | 2024-09-14T12:22:56.168Z |
5033374 | 5033374 | 20240907025253_TSF0c | CZ000M | 2024-09-12T12:09:20.602Z | 2024-09-15T12:21:29.929Z |
5033308 | 5033308 | 20240907024722_R2D1M | CZ000M | 2024-09-12T12:09:06.519Z | 2024-09-15T12:21:29.575Z |
5033301 | 5033301 | 20240907024515_iK9aa | CZ000M | 2024-09-12T12:09:06.036Z | 2024-09-15T12:21:29.564Z |
5033258 | 5033258 | 20240907024153_0GJQn | CZ000M | 2024-09-12T12:09:03.017Z | 2024-09-15T12:21:29.471Z |
5033249 | 5033249 | 20240907024141_BCaSU | CZ000M | 2024-09-12T12:09:02.451Z | 2024-09-15T12:21:29.360Z |
5033205 | 5033205 | 20240907023754_wNn2M | CZ000M | 2024-09-12T12:08:57.470Z | 2024-09-15T12:21:29.187Z |
5033192 | 5033192 | 20240907023521_HGXtC | CZ000M | 2024-09-12T12:08:55.998Z | 2024-09-15T12:21:29.172Z |
5033137 | 5033137 | 20240907022830_Fp3pE | CZ000M | 2024-09-12T12:08:51.891Z | 2024-09-15T12:21:29.038Z |
5033105 | 5033105 | 20240907022522_CrdZy | CZ000M | 2024-09-12T12:08:49.647Z | 2024-09-15T12:21:29.009Z |
5033052 | 5033052 | 20240907021948_n2CpE | CZ000M | 2024-09-12T12:08:45.958Z | 2024-09-15T12:21:28.921Z |
5033003 | 5033003 | 20240907021304_Oy3uE | CZ000M | 2024-09-12T12:08:42.510Z | 2024-09-15T12:21:28.772Z |
5032893 | 5032893 | 20240907020019_9NE3L | CZ000M | 2024-09-12T12:08:17.533Z | 2024-09-15T12:21:28.147Z |
5032861 | 5032861 | 20240907015650_NvE7L | CZ000M | 2024-09-12T12:08:12.065Z | 2024-09-15T12:21:28.096Z |
5032714 | 5032714 | 20240907013854_8DXCf | CZ000M | 2024-09-12T12:07:53.553Z | 2024-09-15T12:21:27.544Z |
5032664 | 5032664 | 20240907012638_ite0O | CZ000M | 2024-09-12T12:07:49.627Z | 2024-09-15T12:21:27.304Z |
5032496 | 5032496 | 20240907010906_Yi6Ef | CZ000M | 2024-09-12T12:07:24.756Z | 2024-09-15T12:21:26.635Z |
5032490 | 5032490 | 20240907010806_H233q | CZ000M | 2024-09-12T12:07:24.183Z | 2024-09-15T12:21:26.599Z |
5032395 | 5032395 | 20240907005631_UOJWU | CZ000M | 2024-09-12T12:07:14.132Z | 2024-09-15T12:21:26.322Z |
5032232 | 5032232 | 20240907003254_aSuG7 | CZ000M | 2024-09-12T12:06:47.117Z | 2024-09-15T12:21:25.680Z |
5032193 | 5032193 | 20240907002530_1Hn0Q | CZ000M | 2024-09-12T12:06:44.044Z | 2024-09-15T12:21:25.575Z |
5032051 | 5032051 | 20240907000128_WbCeX | CZ000M | 2024-09-12T12:06:27.819Z | 2024-09-15T12:21:25.157Z |
5031991 | 5031991 | 20240906235013_RCRxo | CZ000M | 2024-09-12T12:06:21.409Z | 2024-09-15T12:21:24.951Z |
5031943 | 5031943 | 20240906234428_bhgZ3 | CZ000M | 2024-09-12T12:06:08.150Z | 2024-09-15T12:21:24.833Z |
5031886 | 5031886 | 20240906233545_sZGRM | CZ000M | 2024-09-12T12:06:00.239Z | 2024-09-15T12:21:24.613Z |
5031374 | 5031374 | 20240906213433_u38e7 | CZ000M | 2024-09-12T12:04:38.737Z | 2024-09-15T12:21:22.133Z |
5031188 | 5031188 | 20240906204822_kZ508 | CZ000M | 2024-09-12T12:04:14.290Z | 2024-09-15T12:21:21.670Z |
5031155 | 5031155 | 20240906204151_cSp1C | CZ000M | 2024-09-12T12:04:03.432Z | 2024-09-15T12:21:21.587Z |
5031089 | 5031089 | 20240906202401_MkN4H | CZ000M | 2024-09-12T12:03:53.297Z | 2024-09-15T12:21:21.390Z |
5031062 | 5031062 | 20240906201711_je9OU | CZ000M | 2024-09-12T12:03:49.930Z | 2024-09-15T12:21:21.272Z |
5030946 | 5030946 | 20240906193737_MjdrN | CZ000M | 2024-09-12T12:03:27.739Z | 2024-09-15T12:21:20.517Z |
5030801 | 5030801 | 20240906184314_oqA4e | CZ000M | 2024-09-12T12:03:07.080Z | 2024-09-15T12:21:19.773Z |
5026233 | 5026233 | 20240905024553_J5Ph0 | CZ000M | 2024-09-11T12:12:06.837Z | 2024-09-13T12:19:57.211Z |
5026215 | 5026215 | 20240905024051_2WYYj | CZ000M | 2024-09-11T12:12:05.271Z | 2024-09-13T12:19:57.182Z |
5026206 | 5026206 | 20240905023944_yoGGm | CZ000M | 2024-09-11T12:12:04.659Z | 2024-09-13T12:19:57.167Z |
5026155 | 5026155 | 20240905022427_jXdnC | CZ000M | 2024-09-11T12:11:59.491Z | 2024-09-13T12:19:56.971Z |
5025672 | 5025672 | 20240905005345_muMgw | CZ000M | 2024-09-11T12:10:45.313Z | 2024-09-13T12:19:55.142Z |
5025500 | 5025500 | 20240906020556_ignpU | CZ000M | 2024-09-11T12:06:43.058Z | 2024-09-11T12:16:32.656Z |
5025389 | 5025389 | 20240906015618_tLKhk | CZ000M | 2024-09-11T12:06:24.650Z | 2024-09-11T12:16:32.609Z |
5025326 | 5025326 | 20240906014726_ehaRI | CZ000M | 2024-09-11T12:06:13.946Z | 2024-09-11T12:16:32.579Z |
5025317 | 5025317 | 20240906014631_uAq2E | CZ000M | 2024-09-11T12:06:12.820Z | 2024-09-11T12:16:32.575Z |
5025296 | 5025296 | 20240906014014_SVlX0 | CZ000M | 2024-09-11T12:06:10.160Z | 2024-09-11T12:16:32.563Z |
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);