participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
730 rows where station_code = "ZA0001" 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 |
---|---|---|---|---|---|
5451239 | 5451239 | 20241031231123_dukKn | ZA0001 | 2024-11-02T12:16:45.076Z | 2024-11-04T14:23:37.036Z |
5440425 | 5440425 | 20241030221017_1A33u | ZA0001 | 2024-11-01T12:15:30.225Z | 2024-11-04T14:25:02.646Z |
5440421 | 5440421 | 20241030220906_YA2EP | ZA0001 | 2024-11-01T12:15:29.815Z | 2024-11-04T14:25:02.624Z |
5439955 | 5439955 | 20241030205637_MnotY | ZA0001 | 2024-11-01T12:14:40.499Z | 2024-11-04T14:24:58.082Z |
5439904 | 5439904 | 20241030204700_dqdEg | ZA0001 | 2024-11-01T12:14:37.080Z | 2024-11-04T14:24:57.534Z |
5395530 | 5395530 | 20241025224957_iCDnj | ZA0001 | 2024-10-28T12:16:23.844Z | 2024-11-03T14:27:25.691Z |
5395388 | 5395388 | 20241025223848_WOrC3 | ZA0001 | 2024-10-28T12:16:11.896Z | 2024-11-03T14:27:25.421Z |
5394625 | 5394625 | 20241025210022_hN3IM | ZA0001 | 2024-10-28T12:15:06.610Z | 2024-11-03T14:27:21.912Z |
5394531 | 5394531 | 20241025204616_ax4G3 | ZA0001 | 2024-10-28T12:14:51.581Z | 2024-11-03T14:27:21.467Z |
5393896 | 5393896 | 20241025190622_4D0mz | ZA0001 | 2024-10-28T12:13:49.475Z | 2024-11-03T14:27:18.836Z |
5373901 | 5373901 | 20241024015924_gGbc6 | ZA0001 | 2024-10-26T12:20:30.280Z | 2024-11-01T12:26:58.552Z |
5373556 | 5373556 | 20241024014314_fZ2AI | ZA0001 | 2024-10-26T12:20:16.698Z | 2024-11-01T12:26:58.324Z |
5373485 | 5373485 | 20241024013951_2SePx | ZA0001 | 2024-10-26T12:20:13.765Z | 2024-11-01T12:26:58.294Z |
5373379 | 5373379 | 20241024013539_xEbE7 | ZA0001 | 2024-10-26T12:20:09.405Z | 2024-11-01T12:26:58.238Z |
5373281 | 5373281 | 20241024013137_FCPvg | ZA0001 | 2024-10-26T12:20:03.773Z | 2024-11-01T12:26:58.209Z |
5372226 | 5372226 | 20241024003926_EaANC | ZA0001 | 2024-10-26T12:19:15.381Z | 2024-11-01T12:26:57.315Z |
5372205 | 5372205 | 20241024003746_dVTAA | ZA0001 | 2024-10-26T12:19:14.341Z | 2024-11-01T12:26:57.307Z |
5371903 | 5371903 | 20241024000834_Xv37y | ZA0001 | 2024-10-26T12:18:50.931Z | 2024-11-01T12:26:56.784Z |
5371901 | 5371901 | 20241023232931_aIkYY | ZA0001 | 2024-10-26T12:18:35.930Z | 2024-11-01T12:26:56.076Z |
5371899 | 5371899 | 20241023231451_9M6S6 | ZA0001 | 2024-10-26T12:18:30.278Z | 2024-11-01T12:26:55.879Z |
5371897 | 5371897 | 20241023223141_5zM2H | ZA0001 | 2024-10-26T12:18:09.847Z | 2024-11-01T12:26:55.107Z |
5365449 | 5365449 | 20241023233320_Cinlu | ZA0001 | 2024-10-25T12:17:58.117Z | 2024-11-01T12:26:56.134Z |
5365278 | 5365278 | 20241023232428_EPbOV | ZA0001 | 2024-10-25T12:17:53.798Z | 2024-11-01T12:26:56.014Z |
5364408 | 5364408 | 20241023222633_7VzXH | ZA0001 | 2024-10-25T12:17:19.851Z | 2024-11-01T12:26:55.043Z |
5361640 | 5361640 | 20241023183225_bARBC | ZA0001 | 2024-10-25T12:13:03.766Z | 2024-11-01T12:26:50.401Z |
5354577 | 5354577 | 20241023023358_zGrHJ | ZA0001 | 2024-10-24T12:20:41.409Z | 2024-10-31T12:30:06.018Z |
5354331 | 5354331 | 20241023022029_ONEF4 | ZA0001 | 2024-10-24T12:20:28.304Z | 2024-10-31T12:30:05.650Z |
5354089 | 5354089 | 20241023020331_yB5hf | ZA0001 | 2024-10-24T12:20:14.405Z | 2024-10-31T12:30:05.355Z |
5353675 | 5353675 | 20241023013945_Kcj2E | ZA0001 | 2024-10-24T12:19:51.643Z | 2024-10-31T12:30:04.645Z |
5353518 | 5353518 | 20241023012918_2eYc0 | ZA0001 | 2024-10-24T12:19:45.316Z | 2024-10-31T12:30:04.322Z |
5353491 | 5353491 | 20241023012815_jJedM | ZA0001 | 2024-10-24T12:19:44.461Z | 2024-10-31T12:30:04.297Z |
5352998 | 5352998 | 20241023010034_jZBFx | ZA0001 | 2024-10-24T12:19:28.907Z | 2024-10-31T12:30:03.639Z |
5352537 | 5352537 | 20241023003819_kY5H9 | ZA0001 | 2024-10-24T12:18:55.666Z | 2024-10-31T12:30:02.869Z |
5352530 | 5352530 | 20241023003806_0x1Mf | ZA0001 | 2024-10-24T12:18:55.448Z | 2024-10-31T12:30:02.863Z |
5352197 | 5352197 | 20241023001715_nIrhQ | ZA0001 | 2024-10-24T12:18:29.713Z | 2024-10-31T12:30:02.289Z |
5351758 | 5351758 | 20241022235104_79VQq | ZA0001 | 2024-10-24T12:17:56.695Z | 2024-10-31T12:30:00.871Z |
5351620 | 5351620 | 20241022234119_ow46T | ZA0001 | 2024-10-24T12:17:43.123Z | 2024-10-31T12:30:00.613Z |
5351611 | 5351611 | 20241022234048_D6Dx2 | ZA0001 | 2024-10-24T12:17:42.284Z | 2024-10-31T12:30:00.594Z |
5351494 | 5351494 | 20241022233343_WpxTf | ZA0001 | 2024-10-24T12:17:36.470Z | 2024-10-31T12:30:00.470Z |
5351150 | 5351150 | 20241022230135_leL5G | ZA0001 | 2024-10-24T12:17:16.242Z | 2024-10-31T12:29:59.548Z |
5351145 | 5351145 | 20241022230106_YeOBc | ZA0001 | 2024-10-24T12:17:15.959Z | 2024-10-31T12:29:59.538Z |
5349261 | 5349261 | 20241022193757_KD2r3 | ZA0001 | 2024-10-24T12:13:22.568Z | 2024-10-31T12:29:54.950Z |
5338571 | 5338571 | 20241021200036_izdfL | ZA0001 | 2024-10-23T12:11:24.419Z | 2024-10-30T12:26:42.510Z |
5338294 | 5338294 | 20241021190849_Z8Vap | ZA0001 | 2024-10-23T12:10:39.992Z | 2024-10-30T12:26:42.133Z |
5326860 | 5326860 | 20241019213110_3dmtO | ZA0001 | 2024-10-21T12:10:33.820Z | 2024-10-28T12:26:42.782Z |
5326201 | 5326201 | 20241020212117_XyO5s | ZA0001 | 2024-10-21T12:07:48.255Z | 2024-10-29T12:26:33.621Z |
5326194 | 5326194 | 20241020210229_I0ZXw | ZA0001 | 2024-10-21T12:07:47.455Z | 2024-10-29T12:26:33.599Z |
5316475 | 5316475 | 20241015221440_QaGW8 | ZA0001 | 2024-10-17T12:06:43.147Z | 2024-10-24T12:27:56.613Z |
5311988 | 5311988 | 20241015023136_ImwY3 | ZA0001 | 2024-10-16T12:09:51.423Z | 2024-10-23T12:24:47.249Z |
5311908 | 5311908 | 20241015021820_Y1R95 | ZA0001 | 2024-10-16T12:09:46.725Z | 2024-10-23T12:24:46.726Z |
5292533 | 5292533 | 20241011234511_APtqF | ZA0001 | 2024-10-13T12:16:09.121Z | 2024-10-20T12:24:47.321Z |
5291698 | 5291698 | 20241011214358_I47od | ZA0001 | 2024-10-13T12:15:01.215Z | 2024-10-20T12:24:34.952Z |
5291577 | 5291577 | 20241011212320_Owcwi | ZA0001 | 2024-10-13T12:14:49.251Z | 2024-10-20T12:24:33.417Z |
5290593 | 5290593 | 20241011182934_2CkYn | ZA0001 | 2024-10-13T12:12:53.616Z | 2024-10-20T12:24:17.897Z |
5238365 | 5238365 | 20241005022837_5U3FB | ZA0001 | 2024-10-07T12:04:15.087Z | 2024-10-14T12:24:16.270Z |
5210454 | 5210454 | 20241001213528_5u3S9 | ZA0001 | 2024-10-03T12:15:08.606Z | 2024-10-10T12:24:46.953Z |
5199213 | 5199213 | 20240929230111_2AvP3 | ZA0001 | 2024-10-01T12:15:55.136Z | 2024-10-07T12:21:38.763Z |
5199151 | 5199151 | 20240929223513_HQDqU | ZA0001 | 2024-10-01T12:15:49.738Z | 2024-10-07T12:21:38.379Z |
5192487 | 5192487 | 20240928224120_QkvFt | ZA0001 | 2024-09-30T12:18:42.589Z | 2024-10-06T12:28:25.756Z |
5154930 | 5154930 | 20240922180914_UVtj6 | ZA0001 | 2024-09-24T12:10:52.895Z | 2024-09-30T12:22:49.154Z |
5145800 | 5145800 | 20240921222034_6WFwa | ZA0001 | 2024-09-23T12:01:02.580Z | 2024-09-30T12:22:33.266Z |
5090348 | 5090348 | 20240912012214_Wieg8 | ZA0001 | 2024-09-16T12:12:15.472Z | 2024-09-20T12:21:44.892Z |
5090229 | 5090229 | 20240912011641_diIdC | ZA0001 | 2024-09-16T12:12:07.334Z | 2024-09-20T12:21:44.704Z |
5089610 | 5089610 | 20240912005105_7kb32 | ZA0001 | 2024-09-16T12:11:31.805Z | 2024-09-20T12:21:42.970Z |
5089373 | 5089373 | 20240912003816_F6nL3 | ZA0001 | 2024-09-16T12:11:22.088Z | 2024-09-20T12:21:42.040Z |
5079939 | 5079939 | 20240911032218_c0mjU | ZA0001 | 2024-09-15T12:16:42.660Z | 2024-09-19T12:21:42.906Z |
5079589 | 5079589 | 20240911030431_10oPE | ZA0001 | 2024-09-15T12:16:27.287Z | 2024-09-19T12:21:42.436Z |
5079294 | 5079294 | 20240911024722_R6mPZ | ZA0001 | 2024-09-15T12:16:14.510Z | 2024-09-19T12:21:41.408Z |
5078905 | 5078905 | 20240911022009_c3Ras | ZA0001 | 2024-09-15T12:15:55.281Z | 2024-09-19T12:21:40.809Z |
5078242 | 5078242 | 20240911014436_YJOZF | ZA0001 | 2024-09-15T12:15:27.723Z | 2024-09-19T12:21:40.109Z |
5077429 | 5077429 | 20240911005107_dfne2 | ZA0001 | 2024-09-15T12:14:45.119Z | 2024-09-19T12:21:38.994Z |
5077408 | 5077408 | 20240911004955_2rJJD | ZA0001 | 2024-09-15T12:14:43.178Z | 2024-09-19T12:21:38.974Z |
5077319 | 5077319 | 20240911004436_cRLiM | ZA0001 | 2024-09-15T12:14:38.223Z | 2024-09-19T12:21:38.656Z |
5077196 | 5077196 | 20240911003221_FH8gj | ZA0001 | 2024-09-15T12:14:29.530Z | 2024-09-19T12:21:38.508Z |
5077181 | 5077181 | 20240911003054_wGb0T | ZA0001 | 2024-09-15T12:14:27.717Z | 2024-09-19T12:21:38.317Z |
5076942 | 5076942 | 20240911001505_VTEOg | ZA0001 | 2024-09-15T12:14:14.004Z | 2024-09-19T12:21:37.868Z |
5076644 | 5076644 | 20240910235411_dob6I | ZA0001 | 2024-09-15T12:13:49.204Z | 2024-09-19T12:21:37.420Z |
5076419 | 5076419 | 20240910233337_3A43F | ZA0001 | 2024-09-15T12:13:33.412Z | 2024-09-19T12:21:37.051Z |
5076309 | 5076309 | 20240910232009_GO2gv | ZA0001 | 2024-09-15T12:13:27.240Z | 2024-09-19T12:21:36.704Z |
5075966 | 5075966 | 20240910230211_2UnB0 | ZA0001 | 2024-09-15T12:13:13.548Z | 2024-09-19T12:21:36.260Z |
5072182 | 5072182 | 20240911194503_w0uC4 | ZA0001 | 2024-09-15T12:04:50.375Z | 2024-09-20T12:21:25.557Z |
5072110 | 5072110 | 20240911193759_tnNgg | ZA0001 | 2024-09-15T12:04:41.075Z | 2024-09-20T12:21:25.034Z |
5064951 | 5064951 | 20240910024043_112bv | ZA0001 | 2024-09-14T12:16:12.315Z | 2024-09-18T12:15:17.911Z |
5064904 | 5064904 | 20240910022500_AjtMo | ZA0001 | 2024-09-14T12:16:09.204Z | 2024-09-18T12:15:17.728Z |
5064837 | 5064837 | 20240910021405_FlAzY | ZA0001 | 2024-09-14T12:16:05.505Z | 2024-09-18T12:15:17.497Z |
5064546 | 5064546 | 20240910013104_zlpOv | ZA0001 | 2024-09-14T12:15:38.165Z | 2024-09-18T12:15:16.824Z |
5064365 | 5064365 | 20240910005416_OWrlF | ZA0001 | 2024-09-14T12:15:19.884Z | 2024-09-18T12:15:16.369Z |
5064076 | 5064076 | 20240909234823_fPL88 | ZA0001 | 2024-09-14T12:14:48.875Z | 2024-09-18T12:15:15.477Z |
5064039 | 5064039 | 20240909233619_jKKhE | ZA0001 | 2024-09-14T12:14:45.506Z | 2024-09-18T12:15:15.324Z |
5063739 | 5063739 | 20240909223150_qk4yn | ZA0001 | 2024-09-14T12:14:17.875Z | 2024-09-18T12:15:14.470Z |
5063020 | 5063020 | 20240909193910_cGcwY | ZA0001 | 2024-09-14T12:13:18.860Z | 2024-09-18T12:15:12.897Z |
5047340 | 5047340 | 20240909033350_2jxZf | ZA0001 | 2024-09-13T12:08:49.710Z | 2024-09-17T12:19:02.103Z |
5047039 | 5047039 | 20240909022135_iFFvN | ZA0001 | 2024-09-13T12:08:10.738Z | 2024-09-17T12:19:00.883Z |
5047037 | 5047037 | 20240909022056_IPWxL | ZA0001 | 2024-09-13T12:08:10.507Z | 2024-09-17T12:19:00.881Z |
5046527 | 5046527 | 20240909000436_dkDhd | ZA0001 | 2024-09-13T12:06:51.826Z | 2024-09-17T12:18:59.466Z |
5039293 | 5039293 | 20240906001315_89qKY | ZA0001 | 2024-09-12T12:15:25.249Z | 2024-09-14T12:23:01.252Z |
5039255 | 5039255 | 20240906000253_hP3zn | ZA0001 | 2024-09-12T12:15:22.904Z | 2024-09-14T12:23:01.085Z |
5038318 | 5038318 | 20240905192140_3ZEiu | ZA0001 | 2024-09-12T12:14:33.126Z | 2024-09-14T12:22:55.580Z |
5030741 | 5030741 | 20240906180324_A5rks | ZA0001 | 2024-09-12T12:02:52.340Z | 2024-09-15T12:21:19.531Z |
5024919 | 5024919 | 20240906001315_nAxOW | ZA0001 | 2024-09-11T12:05:09.472Z | 2024-09-11T12:16:32.383Z |
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);