participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
46 rows where station_code = "ZA000A" 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 |
---|---|---|---|---|---|
5451240 | 5451240 | 20241031231123_dukKn | ZA000A | 2024-11-02T12:16:45.088Z | 2024-11-05T14:24:08.883Z |
5439956 | 5439956 | 20241030205637_MnotY | ZA000A | 2024-11-01T12:14:40.499Z | 2024-11-05T14:25:14.709Z |
5403182 | 5403182 | 20241026212640_2n4Bl | ZA000A | 2024-10-29T12:09:10.987Z | 2024-11-04T14:28:47.927Z |
5365450 | 5365450 | 20241023233320_Cinlu | ZA000A | 2024-10-25T12:17:58.117Z | 2024-11-01T12:26:56.134Z |
5365279 | 5365279 | 20241023232428_EPbOV | ZA000A | 2024-10-25T12:17:53.798Z | 2024-11-01T12:26:56.014Z |
5362089 | 5362089 | 20241023190701_8dBlp | ZA000A | 2024-10-25T12:13:50.756Z | 2024-11-01T12:26:50.988Z |
5323115 | 5323115 | 20241018211306_la402 | ZA000A | 2024-10-20T12:05:03.834Z | 2024-10-27T12:28:49.520Z |
5292534 | 5292534 | 20241011234511_APtqF | ZA000A | 2024-10-13T12:16:09.121Z | 2024-10-20T12:24:47.321Z |
5245137 | 5245137 | 20241005220509_EM38o | ZA000A | 2024-10-07T12:15:31.640Z | 2024-10-14T12:24:34.655Z |
5238285 | 5238285 | 20241005022031_4vc23 | ZA000A | 2024-10-07T12:04:03.215Z | 2024-10-14T12:24:15.952Z |
5225624 | 5225624 | 20241003230230_FpCjK | ZA000A | 2024-10-05T12:19:59.143Z | 2024-10-12T12:25:10.517Z |
5224716 | 5224716 | 20241003211535_2JVUd | ZA000A | 2024-10-05T12:19:00.363Z | 2024-10-12T12:25:08.866Z |
3985812 | 3985812 | 20240218014619_nrJUU | ZA000A | 2024-02-19T14:06:36.003Z | 2024-02-26T14:16:54.262Z |
3985721 | 3985721 | 20240218001523_FQ5nt | ZA000A | 2024-02-19T14:06:12.918Z | 2024-02-26T14:16:49.231Z |
3952966 | 3952966 | 20240212023859_0ObpU | ZA000A | 2024-02-13T14:07:04.801Z | 2024-02-20T14:25:57.890Z |
3935938 | 3935938 | 20240208012828_kq7De | ZA000A | 2024-02-09T14:05:58.920Z | 2024-02-16T14:18:30.689Z |
3873010 | 3873010 | 20240120012306_uUAQg | ZA000A | 2024-01-23T14:08:03.368Z | 2024-01-28T14:19:10.681Z |
3861087 | 3861087 | 20240118222612_OMK45 | ZA000A | 2024-01-21T14:19:06.797Z | 2024-01-26T14:23:02.310Z |
3815878 | 3815878 | 20240112003719_8HMQ0 | ZA000A | 2024-01-15T14:18:14.706Z | 2024-01-20T14:23:01.910Z |
3568562 | 3568562 | 20231211004640_iL7U8 | ZA000A | 2024-01-06T00:05:12.844Z | 2024-01-06T00:05:12.844Z |
3567864 | 3567864 | 20231210211259_wZURg | ZA000A | 2024-01-06T00:05:12.763Z | 2024-01-06T00:05:12.763Z |
3513957 | 3513957 | 20231204221027_om2l2 | ZA000A | 2024-01-06T00:04:59.045Z | 2024-01-06T00:04:59.045Z |
3356890 | 3356890 | 20231110021224_nl2WL | ZA000A | 2024-01-06T00:04:12.700Z | 2024-01-06T00:04:12.700Z |
3286613 | 3286613 | 20231029012155_1MIlc | ZA000A | 2024-01-06T00:03:33.717Z | 2024-01-06T00:03:33.717Z |
3254412 | 3254412 | 20231023013221_7jx0o | ZA000A | 2024-01-06T00:03:21.795Z | 2024-01-06T00:03:21.795Z |
2981335 | 2981335 | 20230912020811_Dy63W | ZA000A | 2024-01-06T00:01:45.052Z | 2024-01-06T00:01:45.052Z |
2981204 | 2981204 | 20230912013550_F4olx | ZA000A | 2024-01-06T00:01:45.035Z | 2024-01-06T00:01:45.035Z |
2857845 | 2857845 | 20230820001827_qL7U2 | ZA000A | 2024-01-06T00:01:03.625Z | 2024-01-06T00:01:03.625Z |
2855780 | 2855780 | 20230819215946_iDlln | ZA000A | 2024-01-06T00:01:03.461Z | 2024-01-06T00:01:03.461Z |
2838042 | 2838042 | 20230816233302_S7q0Q | ZA000A | 2024-01-06T00:00:57.545Z | 2024-01-06T00:00:57.545Z |
2720542 | 2720542 | 20230808015031_BEGdI | ZA000A | 2024-01-06T00:00:20.248Z | 2024-01-06T00:00:20.248Z |
2652364 | 2652364 | 20230724225955_eCujo | ZA000A | 2024-01-05T23:59:51.004Z | 2024-01-05T23:59:51.004Z |
2648377 | 2648377 | 20230723211709_E0Z2j | ZA000A | 2024-01-05T23:59:48.018Z | 2024-01-05T23:59:48.018Z |
2636564 | 2636564 | 20230720230948_9KVVl | ZA000A | 2024-01-05T23:59:41.491Z | 2024-01-05T23:59:41.491Z |
2636560 | 2636560 | 20230720230851_WlCAO | ZA000A | 2024-01-05T23:59:41.490Z | 2024-01-05T23:59:41.490Z |
2615440 | 2615440 | 20230716003006_QlwIW | ZA000A | 2024-01-05T23:59:33.053Z | 2024-01-05T23:59:33.053Z |
2577283 | 2577283 | 20230701021708_OWt3J | ZA000A | 2024-01-05T23:59:11.554Z | 2024-01-05T23:59:11.554Z |
2557274 | 2557274 | 20230624030403_QKQKU | ZA000A | 2024-01-05T23:58:56.996Z | 2024-01-05T23:58:56.996Z |
2554700 | 2554700 | 20230623034400_tikGN | ZA000A | 2024-01-05T23:58:55.511Z | 2024-01-05T23:58:55.511Z |
2550085 | 2550085 | 20230621040229_56dow | ZA000A | 2024-01-05T23:58:52.049Z | 2024-01-05T23:58:52.049Z |
2541030 | 2541030 | 20230617030159_qXS3o | ZA000A | 2024-01-05T23:58:41.929Z | 2024-01-05T23:58:41.929Z |
2540841 | 2540841 | 20230617012430_5xg2o | ZA000A | 2024-01-05T23:58:41.801Z | 2024-01-05T23:58:41.801Z |
2519890 | 2519890 | 20230611022906_YSuLe | ZA000A | 2024-01-05T23:58:29.570Z | 2024-01-05T23:58:29.570Z |
2511770 | 2511770 | 20230607021943_sm6Uh | ZA000A | 2024-01-05T23:58:21.244Z | 2024-01-05T23:58:21.244Z |
2366328 | 2366328 | 20230405033459_nEw4G | ZA000A | 2024-01-05T23:56:38.076Z | 2024-01-05T23:56:38.076Z |
2351630 | 2351630 | 20230327192158_zq2dj | ZA000A | 2024-01-05T23:56:27.297Z | 2024-01-05T23:56:27.297Z |
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);