participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
132 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 |
---|---|---|---|---|---|
5591231 | 5591231 | 20241122220313_0hFt2 | ZA0009 | 2024-11-24T14:19:37.158Z | 2024-11-24T14:21:11.427Z |
5588494 | 5588494 | 20241123224206_b74MN | ZA0009 | 2024-11-24T14:12:55.740Z | 2024-11-24T14:12:55.740Z |
5588350 | 5588350 | 20241123201145_sE9gO | ZA0009 | 2024-11-24T14:12:45.111Z | 2024-11-24T14:12:45.111Z |
5588235 | 5588235 | 20241123193955_TtZzD | ZA0009 | 2024-11-24T14:12:18.454Z | 2024-11-24T14:12:18.454Z |
5588161 | 5588161 | 20241123192032_Ank8A | ZA0009 | 2024-11-24T14:12:10.945Z | 2024-11-24T14:12:10.945Z |
5552648 | 5552648 | 20241117194631_SUd2D | ZA0009 | 2024-11-19T14:08:50.662Z | 2024-11-24T14:25:19.580Z |
5548207 | 5548207 | 20241116211920_Rdq3e | ZA0009 | 2024-11-18T14:08:27.245Z | 2024-11-24T14:25:30.137Z |
5543188 | 5543188 | 20241114224532_aE2Q4 | ZA0009 | 2024-11-16T14:05:41.475Z | 2024-11-23T14:26:18.135Z |
5541235 | 5541235 | 20241113213817_lt1iK | ZA0009 | 2024-11-15T14:07:03.778Z | 2024-11-22T14:24:17.350Z |
5541216 | 5541216 | 20241113200943_HeMNg | ZA0009 | 2024-11-15T14:06:57.606Z | 2024-11-22T14:24:17.063Z |
5537191 | 5537191 | 20241112205400_uDt2D | ZA0009 | 2024-11-14T14:11:16.200Z | 2024-11-21T14:26:09.579Z |
5537162 | 5537162 | 20241112204034_PJtFE | ZA0009 | 2024-11-14T14:11:09.959Z | 2024-11-21T14:26:09.418Z |
5537089 | 5537089 | 20241112202434_24mWz | ZA0009 | 2024-11-14T14:11:00.681Z | 2024-11-21T14:26:08.730Z |
5528751 | 5528751 | 20241111223140_hjWD2 | ZA0009 | 2024-11-13T14:11:23.027Z | 2024-11-20T14:25:34.933Z |
5528543 | 5528543 | 20241111212954_Qf23G | ZA0009 | 2024-11-13T14:11:04.908Z | 2024-11-20T14:25:32.070Z |
5515589 | 5515589 | 20241109220527_QsR8e | ZA0009 | 2024-11-11T14:11:15.602Z | 2024-11-18T14:26:26.911Z |
5515340 | 5515340 | 20241109203852_ZGPiU | ZA0009 | 2024-11-11T14:10:47.641Z | 2024-11-18T14:26:25.637Z |
5515156 | 5515156 | 20241109194138_BrVK3 | ZA0009 | 2024-11-11T14:10:12.316Z | 2024-11-18T14:26:24.569Z |
5515132 | 5515132 | 20241109193128_SJASE | ZA0009 | 2024-11-11T14:10:07.741Z | 2024-11-18T14:26:24.442Z |
5514993 | 5514993 | 20241109185257_HffOl | ZA0009 | 2024-11-11T14:09:51.998Z | 2024-11-18T14:26:23.727Z |
5508963 | 5508963 | 20241108210122_Ae7gX | ZA0009 | 2024-11-10T14:12:10.071Z | 2024-11-17T14:23:38.209Z |
5502908 | 5502908 | 20241107201106_7L33G | ZA0009 | 2024-11-09T14:12:11.786Z | 2024-11-16T14:28:00.475Z |
5502451 | 5502451 | 20241107183454_hr4HZ | ZA0009 | 2024-11-09T14:11:23.278Z | 2024-11-16T14:27:55.949Z |
5495923 | 5495923 | 20241106220615_jQ29J | ZA0009 | 2024-11-08T14:11:08.487Z | 2024-11-15T14:24:54.081Z |
5495775 | 5495775 | 20241106213318_Ah2A2 | ZA0009 | 2024-11-08T14:10:51.057Z | 2024-11-15T14:24:53.105Z |
5495679 | 5495679 | 20241106210050_po55S | ZA0009 | 2024-11-08T14:10:36.302Z | 2024-11-15T14:24:52.295Z |
5495604 | 5495604 | 20241106203035_1IJwx | ZA0009 | 2024-11-08T14:10:27.618Z | 2024-11-15T14:24:51.242Z |
5495595 | 5495595 | 20241106202853_q1y3i | ZA0009 | 2024-11-08T14:10:26.811Z | 2024-11-15T14:24:51.033Z |
5490387 | 5490387 | 20241105223155_uDQA0 | ZA0009 | 2024-11-07T14:13:57.743Z | 2024-11-14T14:23:19.281Z |
5490266 | 5490266 | 20241105215134_btp6c | ZA0009 | 2024-11-07T14:13:47.120Z | 2024-11-14T14:23:18.603Z |
5490224 | 5490224 | 20241105214436_ru5Jw | ZA0009 | 2024-11-07T14:13:36.949Z | 2024-11-14T14:23:18.332Z |
5489618 | 5489618 | 20241105192815_ctds0 | ZA0009 | 2024-11-07T14:12:19.558Z | 2024-11-14T14:23:14.248Z |
5489463 | 5489463 | 20241105190108_gD28H | ZA0009 | 2024-11-07T14:12:04.150Z | 2024-11-14T14:23:13.410Z |
5450682 | 5450682 | 20241031201812_n3KLQ | ZA0009 | 2024-11-02T12:15:44.259Z | 2024-11-09T14:24:17.490Z |
5441137 | 5441137 | 20241029205521_34EKs | ZA0009 | 2024-11-01T12:18:09.971Z | 2024-11-07T14:26:40.886Z |
5441111 | 5441111 | 20241029204825_u3DTu | ZA0009 | 2024-11-01T12:18:07.381Z | 2024-11-07T14:26:40.781Z |
5440422 | 5440422 | 20241030220906_YA2EP | ZA0009 | 2024-11-01T12:15:29.815Z | 2024-11-08T14:23:09.382Z |
5439905 | 5439905 | 20241030204700_dqdEg | ZA0009 | 2024-11-01T12:14:37.101Z | 2024-11-08T14:23:06.002Z |
5433274 | 5433274 | 20241029184353_LWFQH | ZA0009 | 2024-10-31T12:22:03.300Z | 2024-11-07T14:26:37.436Z |
5429802 | 5429802 | 20241028200702_8di5S | ZA0009 | 2024-10-31T12:17:03.266Z | 2024-11-06T14:27:17.597Z |
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 |
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);