participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
99 rows where station_code = "ZA0009" 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 |
---|---|---|---|---|---|
5450682 | 5450682 | 20241031201812_n3KLQ | ZA0009 | 2024-11-02T12:15:44.259Z | 2024-11-05T14:24:03.291Z |
5441137 | 5441137 | 20241029205521_34EKs | ZA0009 | 2024-11-01T12:18:09.971Z | 2024-11-05T14:25:58.528Z |
5441111 | 5441111 | 20241029204825_u3DTu | ZA0009 | 2024-11-01T12:18:07.381Z | 2024-11-05T14:25:58.097Z |
5440422 | 5440422 | 20241030220906_YA2EP | ZA0009 | 2024-11-01T12:15:29.815Z | 2024-11-05T14:25:17.117Z |
5439905 | 5439905 | 20241030204700_dqdEg | ZA0009 | 2024-11-01T12:14:37.101Z | 2024-11-05T14:25:14.541Z |
5433274 | 5433274 | 20241029184353_LWFQH | ZA0009 | 2024-10-31T12:22:03.300Z | 2024-11-05T14:25:54.567Z |
5429802 | 5429802 | 20241028200702_8di5S | ZA0009 | 2024-10-31T12:17:03.266Z | 2024-11-05T14:26:32.643Z |
5403815 | 5403815 | 20241026223306_2zrGO | ZA0009 | 2024-10-29T12:10:15.550Z | 2024-11-04T14:28:49.785Z |
5403723 | 5403723 | 20241026222515_iC7rO | ZA0009 | 2024-10-29T12:10:09.841Z | 2024-11-04T14:28:49.520Z |
5395531 | 5395531 | 20241025224957_iCDnj | ZA0009 | 2024-10-28T12:16:23.844Z | 2024-11-03T14:27:25.691Z |
5394878 | 5394878 | 20241025213844_3t6Xp | ZA0009 | 2024-10-28T12:15:36.653Z | 2024-11-03T14:27:23.256Z |
5394725 | 5394725 | 20241025211613_Tvbh9 | ZA0009 | 2024-10-28T12:15:18.164Z | 2024-11-03T14:27:22.411Z |
5394362 | 5394362 | 20241025202115_EEVmn | ZA0009 | 2024-10-28T12:14:29.426Z | 2024-11-03T14:27:21.016Z |
5384980 | 5384980 | 20241024213013_96eHx | ZA0009 | 2024-10-27T12:18:06.707Z | 2024-11-02T12:28:28.840Z |
5384335 | 5384335 | 20241024195644_we08O | ZA0009 | 2024-10-27T12:16:57.272Z | 2024-11-02T12:28:26.967Z |
5383558 | 5383558 | 20241024183310_FUkG5 | ZA0009 | 2024-10-27T12:15:44.258Z | 2024-11-02T12:28:25.756Z |
5364409 | 5364409 | 20241023222633_7VzXH | ZA0009 | 2024-10-25T12:17:19.851Z | 2024-11-01T12:26:55.043Z |
5363797 | 5363797 | 20241023214512_VaPBS | ZA0009 | 2024-10-25T12:16:46.994Z | 2024-11-01T12:26:53.636Z |
5363212 | 5363212 | 20241023203634_p2hJ6 | ZA0009 | 2024-10-25T12:15:41.493Z | 2024-11-01T12:26:52.961Z |
5362838 | 5362838 | 20241023200424_nxhLD | ZA0009 | 2024-10-25T12:15:12.003Z | 2024-11-01T12:26:52.473Z |
5362653 | 5362653 | 20241023195141_O0uVh | ZA0009 | 2024-10-25T12:14:55.905Z | 2024-11-01T12:26:52.181Z |
5362088 | 5362088 | 20241023190701_8dBlp | ZA0009 | 2024-10-25T12:13:50.756Z | 2024-11-01T12:26:50.988Z |
5351151 | 5351151 | 20241022230135_leL5G | ZA0009 | 2024-10-24T12:17:16.242Z | 2024-10-31T12:29:59.548Z |
5350789 | 5350789 | 20241022222904_AbLhf | ZA0009 | 2024-10-24T12:16:33.248Z | 2024-10-31T12:29:58.790Z |
5350584 | 5350584 | 20241022220517_pyAjY | ZA0009 | 2024-10-24T12:16:01.074Z | 2024-10-31T12:29:58.492Z |
5350457 | 5350457 | 20241022215158_AgLGv | ZA0009 | 2024-10-24T12:15:46.634Z | 2024-10-31T12:29:58.209Z |
5326825 | 5326825 | 20241019204946_IIHCL | ZA0009 | 2024-10-21T12:10:25.358Z | 2024-10-28T12:26:42.567Z |
5326736 | 5326736 | 20241019195547_AcAt6 | ZA0009 | 2024-10-21T12:10:13.955Z | 2024-10-28T12:26:42.350Z |
5326198 | 5326198 | 20241020210958_phxrR | ZA0009 | 2024-10-21T12:07:47.710Z | 2024-10-29T12:26:33.606Z |
5323114 | 5323114 | 20241018211306_la402 | ZA0009 | 2024-10-20T12:05:03.804Z | 2024-10-27T12:28:49.520Z |
5316476 | 5316476 | 20241015221440_QaGW8 | ZA0009 | 2024-10-17T12:06:43.159Z | 2024-10-24T12:27:56.613Z |
5311043 | 5311043 | 20241014224057_G3CNj | ZA0009 | 2024-10-16T12:08:11.823Z | 2024-10-23T12:24:40.794Z |
5311000 | 5311000 | 20241014222332_JwSQU | ZA0009 | 2024-10-16T12:08:06.610Z | 2024-10-23T12:24:40.531Z |
5310974 | 5310974 | 20241014220941_3z8o2 | ZA0009 | 2024-10-16T12:08:05.035Z | 2024-10-23T12:24:40.410Z |
5300865 | 5300865 | 20241012220230_Nuz59 | ZA0009 | 2024-10-14T12:14:33.295Z | 2024-10-21T12:23:53.516Z |
5299951 | 5299951 | 20241012194956_gp1DC | ZA0009 | 2024-10-14T12:13:19.790Z | 2024-10-21T12:23:45.237Z |
5290594 | 5290594 | 20241011182934_2CkYn | ZA0009 | 2024-10-13T12:12:53.627Z | 2024-10-20T12:24:17.897Z |
5274676 | 5274676 | 20241009224803_LELB3 | ZA0009 | 2024-10-11T12:14:45.614Z | 2024-10-18T12:22:10.762Z |
5274562 | 5274562 | 20241009215435_4Llcu | ZA0009 | 2024-10-11T12:14:38.055Z | 2024-10-18T12:22:10.014Z |
5273917 | 5273917 | 20241009190338_cYWeH | ZA0009 | 2024-10-11T12:13:29.379Z | 2024-10-18T12:22:05.265Z |
5267696 | 5267696 | 20241008215445_svKXg | ZA0009 | 2024-10-10T12:14:23.892Z | 2024-10-17T12:20:10.490Z |
5267614 | 5267614 | 20241008211810_6tSJJ | ZA0009 | 2024-10-10T12:14:12.538Z | 2024-10-17T12:20:10.032Z |
5267325 | 5267325 | 20241008194419_Lo5lD | ZA0009 | 2024-10-10T12:13:50.528Z | 2024-10-17T12:20:08.961Z |
5267152 | 5267152 | 20241008185627_WKlZE | ZA0009 | 2024-10-10T12:13:31.502Z | 2024-10-17T12:20:08.343Z |
5245136 | 5245136 | 20241005220509_EM38o | ZA0009 | 2024-10-07T12:15:31.640Z | 2024-10-14T12:24:34.655Z |
5244512 | 5244512 | 20241005201833_DJ8xa | ZA0009 | 2024-10-07T12:14:57.044Z | 2024-10-14T12:24:33.754Z |
5225623 | 5225623 | 20241003230230_FpCjK | ZA0009 | 2024-10-05T12:19:59.143Z | 2024-10-12T12:25:10.517Z |
5225387 | 5225387 | 20241003222924_cElb3 | ZA0009 | 2024-10-05T12:19:41.576Z | 2024-10-12T12:25:09.942Z |
5224967 | 5224967 | 20241003214848_sFGFk | ZA0009 | 2024-10-05T12:19:15.865Z | 2024-10-12T12:25:09.421Z |
5224715 | 5224715 | 20241003211535_2JVUd | ZA0009 | 2024-10-05T12:19:00.363Z | 2024-10-12T12:25:08.866Z |
5224192 | 5224192 | 20241003201336_mzupN | ZA0009 | 2024-10-05T12:18:15.140Z | 2024-10-12T12:25:07.696Z |
5223686 | 5223686 | 20241003192107_bs2iK | ZA0009 | 2024-10-05T12:17:25.575Z | 2024-10-12T12:25:06.900Z |
5210539 | 5210539 | 20241001222527_KL2LP | ZA0009 | 2024-10-03T12:15:19.124Z | 2024-10-10T12:24:47.267Z |
5210523 | 5210523 | 20241001221819_aCFox | ZA0009 | 2024-10-03T12:15:17.504Z | 2024-10-10T12:24:47.253Z |
5210402 | 5210402 | 20241001205831_YpIbU | ZA0009 | 2024-10-03T12:15:02.636Z | 2024-10-10T12:24:46.783Z |
5210340 | 5210340 | 20241001203115_YyjIe | ZA0009 | 2024-10-03T12:14:58.176Z | 2024-10-10T12:24:46.521Z |
5210191 | 5210191 | 20241001193115_6TqUQ | ZA0009 | 2024-10-03T12:14:47.071Z | 2024-10-10T12:24:45.726Z |
5210160 | 5210160 | 20241001192115_ji98R | ZA0009 | 2024-10-03T12:14:44.300Z | 2024-10-10T12:24:45.573Z |
5210024 | 5210024 | 20241001182748_q4i9m | ZA0009 | 2024-10-03T12:14:16.372Z | 2024-10-10T12:24:44.599Z |
5205065 | 5205065 | 20240930215802_bHM8v | ZA0009 | 2024-10-02T12:12:20.014Z | 2024-10-09T12:29:15.414Z |
5204997 | 5204997 | 20240930214525_qfFy8 | ZA0009 | 2024-10-02T12:12:16.043Z | 2024-10-09T12:29:15.329Z |
5204071 | 5204071 | 20240930183949_3fDWn | ZA0009 | 2024-10-02T12:11:07.321Z | 2024-10-09T12:29:12.385Z |
5199214 | 5199214 | 20240929230111_2AvP3 | ZA0009 | 2024-10-01T12:15:55.137Z | 2024-10-07T12:21:38.763Z |
5192488 | 5192488 | 20240928224120_QkvFt | ZA0009 | 2024-09-30T12:18:42.589Z | 2024-10-06T12:28:25.756Z |
5175332 | 5175332 | 20240926220751_wwWwE | ZA0009 | 2024-09-28T12:16:57.219Z | 2024-10-04T12:25:35.407Z |
5174943 | 5174943 | 20240926190017_LYOb2 | ZA0009 | 2024-09-28T12:16:19.551Z | 2024-10-04T12:25:32.713Z |
5168814 | 5168814 | 20240925215352_LuAqh | ZA0009 | 2024-09-27T12:10:42.802Z | 2024-10-03T12:25:35.590Z |
5165545 | 5165545 | 20240925223644_CxFMy | ZA0009 | 2024-09-27T12:00:07.966Z | 2024-10-04T12:25:05.460Z |
5155138 | 5155138 | 20240922202955_XN28B | ZA0009 | 2024-09-24T12:11:16.331Z | 2024-09-30T12:22:50.464Z |
5155033 | 5155033 | 20240922191432_IgDdj | ZA0009 | 2024-09-24T12:11:05.294Z | 2024-09-30T12:22:49.992Z |
5154935 | 5154935 | 20240922181022_0Q27k | ZA0009 | 2024-09-24T12:10:53.176Z | 2024-09-30T12:22:49.185Z |
5145765 | 5145765 | 20240921221104_UddVn | ZA0009 | 2024-09-23T12:00:57.948Z | 2024-09-30T12:22:33.012Z |
5145407 | 5145407 | 20240920194151_RUAH5 | ZA0009 | 2024-09-22T12:11:36.527Z | 2024-09-28T12:23:28.266Z |
5141979 | 5141979 | 20240920224153_2vYMT | ZA0009 | 2024-09-22T12:01:11.019Z | 2024-09-29T12:21:59.541Z |
5141896 | 5141896 | 20240920221025_Pku67 | ZA0009 | 2024-09-22T12:01:00.493Z | 2024-09-29T12:21:58.864Z |
5141886 | 5141886 | 20240920220519_UYfqR | ZA0009 | 2024-09-22T12:00:58.795Z | 2024-09-29T12:21:58.821Z |
5141819 | 5141819 | 20240920213326_nlWQf | ZA0009 | 2024-09-22T12:00:49.863Z | 2024-09-29T12:21:58.439Z |
5090349 | 5090349 | 20240912012214_Wieg8 | ZA0009 | 2024-09-16T12:12:15.473Z | 2024-09-20T12:21:44.892Z |
5090342 | 5090342 | 20240912012142_Uxmsk | ZA0009 | 2024-09-16T12:12:14.852Z | 2024-09-20T12:21:44.877Z |
5086789 | 5086789 | 20240912224900_1bXgG | ZA0009 | 2024-09-16T12:06:03.546Z | 2024-09-21T12:16:11.750Z |
5069132 | 5069132 | 20240910211301_kfXqR | ZA0009 | 2024-09-14T12:19:46.434Z | 2024-09-19T12:21:33.714Z |
5052453 | 5052453 | 20240907204507_YAi28 | ZA0009 | 2024-09-13T12:15:09.573Z | 2024-09-16T12:21:05.607Z |
5052147 | 5052147 | 20240907194740_z8lgY | ZA0009 | 2024-09-13T12:14:58.621Z | 2024-09-16T12:21:03.992Z |
5051636 | 5051636 | 20240907175853_QZc2R | ZA0009 | 2024-09-13T12:14:26.170Z | 2024-09-16T12:21:01.440Z |
5046040 | 5046040 | 20240908204748_668qJ | ZA0009 | 2024-09-13T12:05:39.125Z | 2024-09-17T12:18:58.437Z |
5045801 | 5045801 | 20240908192848_QKBgy | ZA0009 | 2024-09-13T12:04:59.816Z | 2024-09-17T12:18:57.384Z |
5038999 | 5038999 | 20240905225858_33Y2M | ZA0009 | 2024-09-12T12:15:11.914Z | 2024-09-14T12:22:59.719Z |
5038835 | 5038835 | 20240905221430_ubFSi | ZA0009 | 2024-09-12T12:15:04.041Z | 2024-09-14T12:22:58.345Z |
5038745 | 5038745 | 20240905213640_o7z2n | ZA0009 | 2024-09-12T12:14:57.437Z | 2024-09-14T12:22:57.652Z |
5038549 | 5038549 | 20240905204819_YYUfA | ZA0009 | 2024-09-12T12:14:46.736Z | 2024-09-14T12:22:56.382Z |
5031595 | 5031595 | 20240906224041_jdh1S | ZA0009 | 2024-09-12T12:05:14.486Z | 2024-09-15T12:21:23.396Z |
5030797 | 5030797 | 20240906184105_68Zki | ZA0009 | 2024-09-12T12:03:06.426Z | 2024-09-15T12:21:19.744Z |
5030638 | 5030638 | 20240906172521_ffa53 | ZA0009 | 2024-09-12T12:02:32.029Z | 2024-09-15T12:21:19.383Z |
5024582 | 5024582 | 20240905225858_afJmF | ZA0009 | 2024-09-11T12:04:08.191Z | 2024-09-11T12:16:32.210Z |
5024414 | 5024414 | 20240905221430_JVYta | ZA0009 | 2024-09-11T12:03:37.729Z | 2024-09-11T12:16:32.127Z |
5024320 | 5024320 | 20240905213640_4EBCN | ZA0009 | 2024-09-11T12:03:19.763Z | 2024-09-11T12:16:32.070Z |
4989031 | 4989031 | 20240901222500_vyOrZ | ZA0009 | 2024-09-07T12:08:22.765Z | 2024-09-10T12:19:16.526Z |
4989002 | 4989002 | 20240901222010_ucESK | ZA0009 | 2024-09-07T12:08:19.733Z | 2024-09-10T12:19:16.311Z |
4988056 | 4988056 | 20240901194656_B3ydP | ZA0009 | 2024-09-07T12:06:46.743Z | 2024-09-10T12:19:12.399Z |
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);