participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,743 rows where station_code = "NZ001A" 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 |
---|---|---|---|---|---|
5494041 | 5494041 | 20241107152133_HnM3i | NZ001A | 2024-11-08T14:05:17.331Z | 2024-11-08T14:05:17.331Z |
5494011 | 5494011 | 20241107151019_Ag0Jf | NZ001A | 2024-11-08T14:05:15.352Z | 2024-11-08T14:05:15.352Z |
5493888 | 5493888 | 20241107142742_kgQR2 | NZ001A | 2024-11-08T14:04:49.500Z | 2024-11-08T14:04:49.500Z |
5493833 | 5493833 | 20241107140135_abRvW | NZ001A | 2024-11-08T14:04:42.769Z | 2024-11-08T14:04:42.769Z |
5493806 | 5493806 | 20241107135505_XeNlz | NZ001A | 2024-11-08T14:04:40.577Z | 2024-11-08T14:04:40.577Z |
5493730 | 5493730 | 20241107131057_9v7Na | NZ001A | 2024-11-08T14:04:32.430Z | 2024-11-08T14:04:32.430Z |
5493680 | 5493680 | 20241107130036_tI8Sw | NZ001A | 2024-11-08T14:04:28.995Z | 2024-11-08T14:04:28.995Z |
5493637 | 5493637 | 20241107125040_2jJkF | NZ001A | 2024-11-08T14:04:24.361Z | 2024-11-08T14:04:24.361Z |
5493348 | 5493348 | 20241107115224_DLxpV | NZ001A | 2024-11-08T14:03:35.698Z | 2024-11-08T14:03:35.698Z |
5493019 | 5493019 | 20241107103735_jk0cP | NZ001A | 2024-11-08T14:02:43.631Z | 2024-11-08T14:02:43.631Z |
5493015 | 5493015 | 20241107103713_HQUJX | NZ001A | 2024-11-08T14:02:43.335Z | 2024-11-08T14:02:43.335Z |
5492567 | 5492567 | 20241107090321_HvEvx | NZ001A | 2024-11-08T14:01:26.852Z | 2024-11-08T14:01:26.852Z |
5487342 | 5487342 | 20241106154018_DjeBg | NZ001A | 2024-11-07T14:05:34.278Z | 2024-11-08T14:14:34.492Z |
5486818 | 5486818 | 20241106133722_9e3tV | NZ001A | 2024-11-07T14:04:11.717Z | 2024-11-08T14:14:34.343Z |
5486773 | 5486773 | 20241106131845_DAFH0 | NZ001A | 2024-11-07T14:04:00.082Z | 2024-11-08T14:14:34.328Z |
5474072 | 5474072 | 20241103154820_nDPyn | NZ001A | 2024-11-05T14:10:06.489Z | 2024-11-08T14:19:20.527Z |
5474042 | 5474042 | 20241103154216_Ua7mL | NZ001A | 2024-11-05T14:10:02.615Z | 2024-11-08T14:19:20.208Z |
5473999 | 5473999 | 20241103153552_dKMNY | NZ001A | 2024-11-05T14:09:59.118Z | 2024-11-08T14:19:19.745Z |
5473940 | 5473940 | 20241103152407_7vZ2d | NZ001A | 2024-11-05T14:09:54.673Z | 2024-11-08T14:19:19.417Z |
5473763 | 5473763 | 20241103150021_dLPNY | NZ001A | 2024-11-05T14:09:42.289Z | 2024-11-08T14:19:18.703Z |
5473754 | 5473754 | 20241103145905_d7U6T | NZ001A | 2024-11-05T14:09:41.347Z | 2024-11-08T14:19:18.691Z |
5473678 | 5473678 | 20241103144853_J8lxx | NZ001A | 2024-11-05T14:09:23.398Z | 2024-11-08T14:19:18.341Z |
5473119 | 5473119 | 20241103132957_EtBe9 | NZ001A | 2024-11-05T14:08:19.394Z | 2024-11-08T14:19:13.684Z |
5472841 | 5472841 | 20241103125101_H7z23 | NZ001A | 2024-11-05T14:07:47.082Z | 2024-11-08T14:19:10.913Z |
5472796 | 5472796 | 20241103124407_yZ9Fd | NZ001A | 2024-11-05T14:07:43.506Z | 2024-11-08T14:19:10.507Z |
5472486 | 5472486 | 20241104152016_0HoPv | NZ001A | 2024-11-05T14:05:56.517Z | 2024-11-08T14:17:53.767Z |
5472484 | 5472484 | 20241104151537_IP962 | NZ001A | 2024-11-05T14:05:56.271Z | 2024-11-08T14:17:53.613Z |
5471507 | 5471507 | 20241104115548_XfGS0 | NZ001A | 2024-11-05T14:03:50.504Z | 2024-11-08T14:17:34.741Z |
5470937 | 5470937 | 20241104100928_smIt0 | NZ001A | 2024-11-05T14:02:19.603Z | 2024-11-08T14:17:22.575Z |
5470849 | 5470849 | 20241104095620_RKJh9 | NZ001A | 2024-11-05T14:02:04.612Z | 2024-11-08T14:17:20.558Z |
5470759 | 5470759 | 20241104094134_9Rvny | NZ001A | 2024-11-05T14:01:45.656Z | 2024-11-08T14:17:19.156Z |
5470748 | 5470748 | 20241104093655_OMRyY | NZ001A | 2024-11-05T14:01:43.430Z | 2024-11-08T14:17:18.813Z |
5465946 | 5465946 | 20241102153044_UszTz | NZ001A | 2024-11-04T14:07:30.266Z | 2024-11-08T14:20:41.388Z |
5465524 | 5465524 | 20241102085550_Fvbnt | NZ001A | 2024-11-04T14:04:30.893Z | 2024-11-08T14:20:23.020Z |
5465316 | 5465316 | 20241103112308_B4iBm | NZ001A | 2024-11-04T14:03:18.846Z | 2024-11-08T14:19:07.446Z |
5461061 | 5461061 | 20241101154429_YzVU0 | NZ001A | 2024-11-03T14:14:41.355Z | 2024-11-08T14:21:40.992Z |
5460948 | 5460948 | 20241101152435_pxQce | NZ001A | 2024-11-03T14:14:35.750Z | 2024-11-08T14:21:40.628Z |
5460907 | 5460907 | 20241101151839_Nrqif | NZ001A | 2024-11-03T14:14:33.607Z | 2024-11-08T14:21:40.355Z |
5460847 | 5460847 | 20241101151243_jnBuj | NZ001A | 2024-11-03T14:14:31.485Z | 2024-11-08T14:21:40.293Z |
5460662 | 5460662 | 20241101144442_BcwYD | NZ001A | 2024-11-03T14:14:10.333Z | 2024-11-08T14:21:39.292Z |
5460630 | 5460630 | 20241101144036_Hj271 | NZ001A | 2024-11-03T14:14:05.917Z | 2024-11-08T14:21:39.248Z |
5460352 | 5460352 | 20241101135636_uJRO2 | NZ001A | 2024-11-03T14:13:37.890Z | 2024-11-08T14:21:38.505Z |
5460271 | 5460271 | 20241101132640_uS8IX | NZ001A | 2024-11-03T14:13:31.970Z | 2024-11-08T14:21:38.190Z |
5457753 | 5457753 | 20241102152052_FlNEZ | NZ001A | 2024-11-03T14:07:58.374Z | 2024-11-08T14:20:40.970Z |
5457344 | 5457344 | 20241102141803_mzm9G | NZ001A | 2024-11-03T14:07:09.326Z | 2024-11-08T14:20:38.954Z |
5457022 | 5457022 | 20241102131349_jRGe8 | NZ001A | 2024-11-03T14:06:23.152Z | 2024-11-08T14:20:37.195Z |
5449543 | 5449543 | 20241031155005_7D06Y | NZ001A | 2024-11-02T12:13:04.930Z | 2024-11-08T14:22:19.629Z |
5449466 | 5449466 | 20241031153954_n9T9E | NZ001A | 2024-11-02T12:12:57.346Z | 2024-11-08T14:22:19.366Z |
5449417 | 5449417 | 20241031153456_2Gp7d | NZ001A | 2024-11-02T12:12:51.418Z | 2024-11-08T14:22:19.213Z |
5449403 | 5449403 | 20241031153348_0TktX | NZ001A | 2024-11-02T12:12:50.593Z | 2024-11-08T14:22:19.168Z |
5449322 | 5449322 | 20241031151925_WMwO2 | NZ001A | 2024-11-02T12:12:31.331Z | 2024-11-08T14:22:18.959Z |
5449298 | 5449298 | 20241031151752_v39ny | NZ001A | 2024-11-02T12:12:27.568Z | 2024-11-08T14:22:18.876Z |
5449114 | 5449114 | 20241031145543_ELOQs | NZ001A | 2024-11-02T12:12:06.850Z | 2024-11-08T14:22:18.405Z |
5449022 | 5449022 | 20241031144302_s18kE | NZ001A | 2024-11-02T12:11:58.575Z | 2024-11-08T14:22:18.243Z |
5448681 | 5448681 | 20241031140519_WulVD | NZ001A | 2024-11-02T12:11:18.498Z | 2024-11-08T14:22:17.096Z |
5448601 | 5448601 | 20241031135138_VoqcQ | NZ001A | 2024-11-02T12:11:10.255Z | 2024-11-08T14:22:16.844Z |
5448579 | 5448579 | 20241031135017_0tv0d | NZ001A | 2024-11-02T12:11:08.399Z | 2024-11-08T14:22:16.779Z |
5448494 | 5448494 | 20241031133845_if6b3 | NZ001A | 2024-11-02T12:10:53.154Z | 2024-11-08T14:22:16.632Z |
5448374 | 5448374 | 20241031132226_Q2wzo | NZ001A | 2024-11-02T12:10:39.076Z | 2024-11-08T14:22:16.116Z |
5448038 | 5448038 | 20241031123547_4x0yI | NZ001A | 2024-11-02T12:09:49.556Z | 2024-11-08T14:22:14.419Z |
5447936 | 5447936 | 20241031122450_IWZDt | NZ001A | 2024-11-02T12:09:28.237Z | 2024-11-08T14:22:14.088Z |
5447877 | 5447877 | 20241031121958_6fw8E | NZ001A | 2024-11-02T12:09:22.625Z | 2024-11-08T14:22:13.893Z |
5447805 | 5447805 | 20241031121227_MrCT3 | NZ001A | 2024-11-02T12:09:09.303Z | 2024-11-08T14:22:13.555Z |
5447763 | 5447763 | 20241031120853_BLFOU | NZ001A | 2024-11-02T12:09:03.068Z | 2024-11-08T14:22:13.471Z |
5447422 | 5447422 | 20241031114002_sU228 | NZ001A | 2024-11-02T12:08:07.709Z | 2024-11-08T14:22:11.855Z |
5447325 | 5447325 | 20241031113022_Nb9uo | NZ001A | 2024-11-02T12:07:46.404Z | 2024-11-08T14:22:11.550Z |
5447278 | 5447278 | 20241031112701_mdVpm | NZ001A | 2024-11-02T12:07:40.937Z | 2024-11-08T14:22:11.398Z |
5447143 | 5447143 | 20241031111211_jZCay | NZ001A | 2024-11-02T12:07:22.536Z | 2024-11-08T14:22:10.719Z |
5446600 | 5446600 | 20241031101422_QVPqE | NZ001A | 2024-11-02T12:05:44.634Z | 2024-11-08T14:22:07.856Z |
5437782 | 5437782 | 20241030154203_h06QR | NZ001A | 2024-11-01T12:10:18.919Z | 2024-11-08T14:22:58.134Z |
5437649 | 5437649 | 20241030153157_VGBwG | NZ001A | 2024-11-01T12:10:09.023Z | 2024-11-08T14:22:57.606Z |
5437131 | 5437131 | 20241030143134_glBYj | NZ001A | 2024-11-01T12:09:06.106Z | 2024-11-08T14:22:56.698Z |
5437033 | 5437033 | 20241030142214_RVZV8 | NZ001A | 2024-11-01T12:08:46.473Z | 2024-11-08T14:22:56.385Z |
5436970 | 5436970 | 20241030141157_9foaM | NZ001A | 2024-11-01T12:08:38.995Z | 2024-11-08T14:22:55.863Z |
5435764 | 5435764 | 20241030115528_XBoR7 | NZ001A | 2024-11-01T12:05:51.893Z | 2024-11-08T14:22:51.681Z |
5435683 | 5435683 | 20241030114934_SWRGQ | NZ001A | 2024-11-01T12:05:45.678Z | 2024-11-08T14:22:51.373Z |
5435676 | 5435676 | 20241030114916_SJ6jC | NZ001A | 2024-11-01T12:05:45.329Z | 2024-11-08T14:22:51.352Z |
5435139 | 5435139 | 20241030105324_RLw8v | NZ001A | 2024-11-01T12:04:22.900Z | 2024-11-08T14:22:49.387Z |
5435100 | 5435100 | 20241030105030_G3Ycp | NZ001A | 2024-11-01T12:04:18.730Z | 2024-11-08T14:22:49.177Z |
5434882 | 5434882 | 20241030102242_jFLSx | NZ001A | 2024-11-01T12:03:40.834Z | 2024-11-08T14:22:48.236Z |
5434494 | 5434494 | 20241030093412_vhaYJ | NZ001A | 2024-11-01T12:02:31.077Z | 2024-11-08T14:22:46.763Z |
5434011 | 5434011 | 20241030080021_K6lPW | NZ001A | 2024-11-01T12:00:48.783Z | 2024-11-08T14:22:44.490Z |
5433715 | 5433715 | 20241027094033_Wd5ux | NZ001A | 2024-10-31T12:23:08.403Z | 2024-11-05T14:26:56.898Z |
5427993 | 5427993 | 20241028161116_WmT1r | NZ001A | 2024-10-31T12:14:23.887Z | 2024-11-06T14:27:12.880Z |
5427376 | 5427376 | 20241028150120_60X2u | NZ001A | 2024-10-31T12:13:29.039Z | 2024-11-06T14:27:11.709Z |
5426602 | 5426602 | 20241028133311_UJS3y | NZ001A | 2024-10-31T12:12:16.360Z | 2024-11-06T14:27:10.446Z |
5426545 | 5426545 | 20241028083423_tgRxz | NZ001A | 2024-10-31T12:10:43.287Z | 2024-11-06T14:27:04.069Z |
5424725 | 5424725 | 20241029150444_kPpqv | NZ001A | 2024-10-31T12:05:54.753Z | 2024-11-07T14:26:32.587Z |
5424449 | 5424449 | 20241029142907_mUYXP | NZ001A | 2024-10-31T12:05:05.664Z | 2024-11-07T14:26:31.691Z |
5424213 | 5424213 | 20241029133953_qdU80 | NZ001A | 2024-10-31T12:04:18.109Z | 2024-11-07T14:26:30.665Z |
5423908 | 5423908 | 20241029122233_6OhFK | NZ001A | 2024-10-31T12:03:09.987Z | 2024-11-07T14:26:29.537Z |
5423613 | 5423613 | 20241029111203_RrddT | NZ001A | 2024-10-31T12:02:09.471Z | 2024-11-07T14:26:27.211Z |
5422626 | 5422626 | 20241028132233_xjx2J | NZ001A | 2024-10-30T12:20:29.042Z | 2024-11-06T14:27:10.358Z |
5422456 | 5422456 | 20241028130447_enVxK | NZ001A | 2024-10-30T12:20:26.976Z | 2024-11-06T14:27:10.206Z |
5422148 | 5422148 | 20241028122146_3CfNr | NZ001A | 2024-10-30T12:20:22.908Z | 2024-11-06T14:27:09.476Z |
5421986 | 5421986 | 20241028120522_71jHM | NZ001A | 2024-10-30T12:20:19.622Z | 2024-11-06T14:27:08.942Z |
5421730 | 5421730 | 20241028112651_6rsMq | NZ001A | 2024-10-30T12:20:13.679Z | 2024-11-06T14:27:08.355Z |
5421712 | 5421712 | 20241028112504_Wx8F8 | NZ001A | 2024-10-30T12:20:13.241Z | 2024-11-06T14:27:08.325Z |
5416634 | 5416634 | 20241027162208_kxwUo | NZ001A | 2024-10-30T12:11:58.449Z | 2024-11-05T14:27:05.091Z |
5416584 | 5416584 | 20241027161155_BfSQs | NZ001A | 2024-10-30T12:11:49.039Z | 2024-11-05T14:27:05.052Z |
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);