participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
752 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 |
---|---|---|---|---|---|
5548718 | 5548718 | 20241117012045_45agf | ZA0001 | 2024-11-18T14:10:03.514Z | 2024-11-23T14:25:41.290Z |
5541234 | 5541234 | 20241113213817_lt1iK | ZA0001 | 2024-11-15T14:07:03.774Z | 2024-11-22T14:24:17.350Z |
5537415 | 5537415 | 20241112224621_83TfZ | ZA0001 | 2024-11-14T14:11:46.472Z | 2024-11-21T14:26:12.798Z |
5528750 | 5528750 | 20241111223140_hjWD2 | ZA0001 | 2024-11-13T14:11:23.027Z | 2024-11-20T14:25:34.933Z |
5528521 | 5528521 | 20241111212137_sDh4a | ZA0001 | 2024-11-13T14:11:02.880Z | 2024-11-20T14:25:31.825Z |
5528185 | 5528185 | 20241111195039_ACfvA | ZA0001 | 2024-11-13T14:10:13.576Z | 2024-11-20T14:25:26.392Z |
5523258 | 5523258 | 20241111004727_yRoQM | ZA0001 | 2024-11-12T14:15:10.505Z | 2024-11-19T14:22:10.861Z |
5515328 | 5515328 | 20241109203635_bsgSP | ZA0001 | 2024-11-11T14:10:45.444Z | 2024-11-18T14:26:25.528Z |
5515272 | 5515272 | 20241109201054_fZux0 | ZA0001 | 2024-11-11T14:10:32.268Z | 2024-11-18T14:26:25.220Z |
5515131 | 5515131 | 20241109193128_SJASE | ZA0001 | 2024-11-11T14:10:07.726Z | 2024-11-18T14:26:24.442Z |
5496430 | 5496430 | 20241107002402_q3Sqa | ZA0001 | 2024-11-08T14:12:09.143Z | 2024-11-15T14:24:57.763Z |
5496304 | 5496304 | 20241106235220_S9uMI | ZA0001 | 2024-11-08T14:11:56.476Z | 2024-11-15T14:24:56.592Z |
5496127 | 5496127 | 20241106230259_DQ4jP | ZA0001 | 2024-11-08T14:11:36.630Z | 2024-11-15T14:24:55.476Z |
5495922 | 5495922 | 20241106220615_jQ29J | ZA0001 | 2024-11-08T14:11:08.487Z | 2024-11-15T14:24:54.081Z |
5495774 | 5495774 | 20241106213318_Ah2A2 | ZA0001 | 2024-11-08T14:10:51.057Z | 2024-11-15T14:24:53.105Z |
5495678 | 5495678 | 20241106210050_po55S | ZA0001 | 2024-11-08T14:10:36.302Z | 2024-11-15T14:24:52.295Z |
5495032 | 5495032 | 20241106182234_9NJVU | ZA0001 | 2024-11-08T14:09:05.100Z | 2024-11-15T14:24:45.739Z |
5490386 | 5490386 | 20241105223155_uDQA0 | ZA0001 | 2024-11-07T14:13:57.743Z | 2024-11-14T14:23:19.281Z |
5490338 | 5490338 | 20241105221529_45sar | ZA0001 | 2024-11-07T14:13:54.011Z | 2024-11-14T14:23:18.984Z |
5490265 | 5490265 | 20241105215134_btp6c | ZA0001 | 2024-11-07T14:13:47.120Z | 2024-11-14T14:23:18.603Z |
5490248 | 5490248 | 20241105214734_FTrSR | ZA0001 | 2024-11-07T14:13:43.430Z | 2024-11-14T14:23:18.392Z |
5490222 | 5490222 | 20241105214436_ru5Jw | ZA0001 | 2024-11-07T14:13:36.939Z | 2024-11-14T14:23:18.332Z |
5451239 | 5451239 | 20241031231123_dukKn | ZA0001 | 2024-11-02T12:16:45.076Z | 2024-11-09T14:24:22.531Z |
5440425 | 5440425 | 20241030221017_1A33u | ZA0001 | 2024-11-01T12:15:30.225Z | 2024-11-08T14:23:09.414Z |
5440421 | 5440421 | 20241030220906_YA2EP | ZA0001 | 2024-11-01T12:15:29.815Z | 2024-11-08T14:23:09.382Z |
5439955 | 5439955 | 20241030205637_MnotY | ZA0001 | 2024-11-01T12:14:40.499Z | 2024-11-08T14:23:06.483Z |
5439904 | 5439904 | 20241030204700_dqdEg | ZA0001 | 2024-11-01T12:14:37.080Z | 2024-11-08T14:23:06.002Z |
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 |
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);