participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,317 rows where station_code = "NZ003C" 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 |
---|---|---|---|---|---|
5460965 | 5460965 | 20241101152616_vWeTS | NZ003C | 2024-11-03T14:14:37.253Z | 2024-11-03T14:19:33.647Z |
5460550 | 5460550 | 20241101142933_08ElS | NZ003C | 2024-11-03T14:13:58.317Z | 2024-11-03T14:19:33.572Z |
5460509 | 5460509 | 20241101142407_ngqfX | NZ003C | 2024-11-03T14:13:53.567Z | 2024-11-03T14:19:33.563Z |
5460493 | 5460493 | 20241101142325_A4ici | NZ003C | 2024-11-03T14:13:51.387Z | 2024-11-03T14:19:33.561Z |
5460424 | 5460424 | 20241101140512_4NYFz | NZ003C | 2024-11-03T14:13:43.165Z | 2024-11-03T14:19:33.542Z |
5460273 | 5460273 | 20241101132827_FgKmF | NZ003C | 2024-11-03T14:13:32.167Z | 2024-11-03T14:19:33.511Z |
5460183 | 5460183 | 20241101130300_pvYoi | NZ003C | 2024-11-03T14:13:27.117Z | 2024-11-03T14:19:33.494Z |
5459725 | 5459725 | 20241101114343_zMsTU | NZ003C | 2024-11-03T14:12:30.958Z | 2024-11-03T14:19:33.406Z |
5459107 | 5459107 | 20241101100824_Pt74c | NZ003C | 2024-11-03T14:11:20.708Z | 2024-11-03T14:19:33.270Z |
5458702 | 5458702 | 20241101090419_NXfAv | NZ003C | 2024-11-03T14:10:29.168Z | 2024-11-03T14:19:33.179Z |
5458626 | 5458626 | 20241101085012_cOz8Q | NZ003C | 2024-11-03T14:10:10.578Z | 2024-11-03T14:19:33.162Z |
5456651 | 5456651 | 20241102115815_My3Po | NZ003C | 2024-11-03T14:05:13.706Z | 2024-11-03T14:05:13.706Z |
5456526 | 5456526 | 20241102113930_BKWLy | NZ003C | 2024-11-03T14:04:55.371Z | 2024-11-03T14:04:55.371Z |
5449610 | 5449610 | 20241031160011_vTRyn | NZ003C | 2024-11-02T12:13:11.761Z | 2024-11-03T14:20:55.675Z |
5449563 | 5449563 | 20241031155354_58Ugo | NZ003C | 2024-11-02T12:13:06.444Z | 2024-11-03T14:20:54.907Z |
5449529 | 5449529 | 20241031154756_pyeOQ | NZ003C | 2024-11-02T12:13:03.761Z | 2024-11-03T14:20:54.275Z |
5449468 | 5449468 | 20241031153954_n9T9E | NZ003C | 2024-11-02T12:12:57.346Z | 2024-11-03T14:20:53.327Z |
5449455 | 5449455 | 20241031153819_g3OVb | NZ003C | 2024-11-02T12:12:56.170Z | 2024-11-03T14:20:53.304Z |
5449373 | 5449373 | 20241031152614_0PsXi | NZ003C | 2024-11-02T12:12:47.628Z | 2024-11-03T14:20:52.102Z |
5449300 | 5449300 | 20241031151752_v39ny | NZ003C | 2024-11-02T12:12:27.568Z | 2024-11-03T14:20:50.987Z |
5449246 | 5449246 | 20241031150956_SidMs | NZ003C | 2024-11-02T12:12:20.248Z | 2024-11-03T14:20:49.846Z |
5449211 | 5449211 | 20241031150522_wsWPJ | NZ003C | 2024-11-02T12:12:18.066Z | 2024-11-03T14:20:49.500Z |
5449186 | 5449186 | 20241031150254_ovnly | NZ003C | 2024-11-02T12:12:14.035Z | 2024-11-03T14:20:49.357Z |
5449174 | 5449174 | 20241031150153_6rg4X | NZ003C | 2024-11-02T12:12:12.769Z | 2024-11-03T14:20:49.317Z |
5449031 | 5449031 | 20241031144431_4cmd0 | NZ003C | 2024-11-02T12:11:59.268Z | 2024-11-03T14:20:47.476Z |
5448742 | 5448742 | 20241031141212_9gS30 | NZ003C | 2024-11-02T12:11:23.105Z | 2024-11-03T14:20:41.863Z |
5448737 | 5448737 | 20241031141144_ERKld | NZ003C | 2024-11-02T12:11:22.478Z | 2024-11-03T14:20:41.856Z |
5448664 | 5448664 | 20241031140230_qnR3u | NZ003C | 2024-11-02T12:11:16.385Z | 2024-11-03T14:20:41.035Z |
5448560 | 5448560 | 20241031134611_DEn2g | NZ003C | 2024-11-02T12:11:05.712Z | 2024-11-03T14:20:39.560Z |
5448512 | 5448512 | 20241031134135_1eN94 | NZ003C | 2024-11-02T12:10:58.003Z | 2024-11-03T14:20:38.951Z |
5448492 | 5448492 | 20241031133740_YvoEL | NZ003C | 2024-11-02T12:10:52.378Z | 2024-11-03T14:20:38.636Z |
5448490 | 5448490 | 20241031133728_MJ1Bp | NZ003C | 2024-11-02T12:10:51.137Z | 2024-11-03T14:20:38.630Z |
5448307 | 5448307 | 20241031131139_kkYom | NZ003C | 2024-11-02T12:10:31.224Z | 2024-11-03T14:20:35.183Z |
5448297 | 5448297 | 20241031130838_fWjks | NZ003C | 2024-11-02T12:10:30.181Z | 2024-11-03T14:20:35.108Z |
5448260 | 5448260 | 20241031130356_IGqyp | NZ003C | 2024-11-02T12:10:25.663Z | 2024-11-03T14:20:34.906Z |
5448230 | 5448230 | 20241031130053_NsKx4 | NZ003C | 2024-11-02T12:10:22.651Z | 2024-11-03T14:20:34.354Z |
5448201 | 5448201 | 20241031125833_pRl3S | NZ003C | 2024-11-02T12:10:15.049Z | 2024-11-03T14:20:34.105Z |
5448169 | 5448169 | 20241031125235_5qile | NZ003C | 2024-11-02T12:10:08.965Z | 2024-11-03T14:20:33.782Z |
5448112 | 5448112 | 20241031124356_sQvET | NZ003C | 2024-11-02T12:09:59.352Z | 2024-11-03T14:20:32.871Z |
5447939 | 5447939 | 20241031122450_IWZDt | NZ003C | 2024-11-02T12:09:28.237Z | 2024-11-03T14:20:30.620Z |
5447930 | 5447930 | 20241031122351_F23kG | NZ003C | 2024-11-02T12:09:27.319Z | 2024-11-03T14:20:30.579Z |
5447852 | 5447852 | 20241031121644_CVd3O | NZ003C | 2024-11-02T12:09:18.090Z | 2024-11-03T14:20:29.510Z |
5447280 | 5447280 | 20241031112701_mdVpm | NZ003C | 2024-11-02T12:07:40.937Z | 2024-11-03T14:20:20.298Z |
5446673 | 5446673 | 20241031102044_rESW3 | NZ003C | 2024-11-02T12:06:01.258Z | 2024-11-03T14:20:05.834Z |
5446101 | 5446101 | 20241031092754_IRIyB | NZ003C | 2024-11-02T12:04:15.040Z | 2024-11-03T14:19:55.291Z |
5446072 | 5446072 | 20241031092213_jifQh | NZ003C | 2024-11-02T12:04:08.370Z | 2024-11-03T14:19:54.737Z |
5437990 | 5437990 | 20241030161046_ghYU2 | NZ003C | 2024-11-01T12:10:49.611Z | 2024-11-03T14:22:41.132Z |
5437922 | 5437922 | 20241030160244_UJTxA | NZ003C | 2024-11-01T12:10:43.215Z | 2024-11-03T14:22:40.976Z |
5437646 | 5437646 | 20241030153155_Xmhdf | NZ003C | 2024-11-01T12:10:08.704Z | 2024-11-03T14:22:40.194Z |
5437627 | 5437627 | 20241030152952_nyk5Q | NZ003C | 2024-11-01T12:10:06.977Z | 2024-11-03T14:22:40.161Z |
5437625 | 5437625 | 20241030152923_Dlb3G | NZ003C | 2024-11-01T12:10:06.709Z | 2024-11-03T14:22:40.160Z |
5437566 | 5437566 | 20241030152127_QVMTI | NZ003C | 2024-11-01T12:10:01.030Z | 2024-11-03T14:22:40.009Z |
5437506 | 5437506 | 20241030151600_h1dne | NZ003C | 2024-11-01T12:09:55.552Z | 2024-11-03T14:22:39.784Z |
5437463 | 5437463 | 20241030151020_Euln2 | NZ003C | 2024-11-01T12:09:41.754Z | 2024-11-03T14:22:39.648Z |
5437424 | 5437424 | 20241030150600_ajE57 | NZ003C | 2024-11-01T12:09:34.412Z | 2024-11-03T14:22:39.567Z |
5437340 | 5437340 | 20241030145707_rt3Ib | NZ003C | 2024-11-01T12:09:25.978Z | 2024-11-03T14:22:39.217Z |
5437250 | 5437250 | 20241030144814_wA8AZ | NZ003C | 2024-11-01T12:09:17.704Z | 2024-11-03T14:22:38.946Z |
5437200 | 5437200 | 20241030144129_IyZhc | NZ003C | 2024-11-01T12:09:13.850Z | 2024-11-03T14:22:38.864Z |
5437137 | 5437137 | 20241030143153_j5DOV | NZ003C | 2024-11-01T12:09:07.442Z | 2024-11-03T14:22:38.701Z |
5437110 | 5437110 | 20241030142853_442Xl | NZ003C | 2024-11-01T12:08:55.652Z | 2024-11-03T14:22:38.579Z |
5436992 | 5436992 | 20241030141525_M2spy | NZ003C | 2024-11-01T12:08:40.868Z | 2024-11-03T14:22:38.245Z |
5436983 | 5436983 | 20241030141418_NeUDA | NZ003C | 2024-11-01T12:08:39.796Z | 2024-11-03T14:22:38.208Z |
5436835 | 5436835 | 20241030135514_3dJ7l | NZ003C | 2024-11-01T12:08:27.012Z | 2024-11-03T14:22:37.847Z |
5436808 | 5436808 | 20241030135117_AD0WU | NZ003C | 2024-11-01T12:08:25.076Z | 2024-11-03T14:22:37.779Z |
5436780 | 5436780 | 20241030134610_t8RkV | NZ003C | 2024-11-01T12:08:16.422Z | 2024-11-03T14:22:37.697Z |
5436720 | 5436720 | 20241030134127_6vg53 | NZ003C | 2024-11-01T12:08:07.671Z | 2024-11-03T14:22:37.574Z |
5436672 | 5436672 | 20241030133619_33DHB | NZ003C | 2024-11-01T12:08:03.863Z | 2024-11-03T14:22:37.473Z |
5436474 | 5436474 | 20241030131052_zOCOT | NZ003C | 2024-11-01T12:07:44.146Z | 2024-11-03T14:22:36.781Z |
5436411 | 5436411 | 20241030130421_sYnWh | NZ003C | 2024-11-01T12:07:30.695Z | 2024-11-03T14:22:36.520Z |
5436045 | 5436045 | 20241030122256_g2NRo | NZ003C | 2024-11-01T12:06:37.907Z | 2024-11-03T14:22:35.156Z |
5435927 | 5435927 | 20241030121108_U1dlJ | NZ003C | 2024-11-01T12:06:23.151Z | 2024-11-03T14:22:34.541Z |
5435829 | 5435829 | 20241030120135_X2JjT | NZ003C | 2024-11-01T12:06:01.423Z | 2024-11-03T14:22:34.204Z |
5435679 | 5435679 | 20241030114916_SJ6jC | NZ003C | 2024-11-01T12:05:45.329Z | 2024-11-03T14:22:33.493Z |
5435519 | 5435519 | 20241030113807_jEVEq | NZ003C | 2024-11-01T12:05:21.229Z | 2024-11-03T14:22:33.021Z |
5435304 | 5435304 | 20241030111512_gYv2u | NZ003C | 2024-11-01T12:04:46.252Z | 2024-11-03T14:22:31.946Z |
5435290 | 5435290 | 20241030111411_Y1N4o | NZ003C | 2024-11-01T12:04:42.649Z | 2024-11-03T14:22:31.898Z |
5435219 | 5435219 | 20241030110422_ECDms | NZ003C | 2024-11-01T12:04:32.533Z | 2024-11-03T14:22:31.574Z |
5435123 | 5435123 | 20241030105212_kN3bl | NZ003C | 2024-11-01T12:04:20.969Z | 2024-11-03T14:22:30.434Z |
5435028 | 5435028 | 20241030104023_GvQTe | NZ003C | 2024-11-01T12:04:00.235Z | 2024-11-03T14:22:28.696Z |
5434936 | 5434936 | 20241030102727_7xbW6 | NZ003C | 2024-11-01T12:03:48.578Z | 2024-11-03T14:22:27.913Z |
5434904 | 5434904 | 20241030102331_acRPw | NZ003C | 2024-11-01T12:03:43.020Z | 2024-11-03T14:22:27.177Z |
5434403 | 5434403 | 20241030091654_22AAQ | NZ003C | 2024-11-01T12:02:11.790Z | 2024-11-03T14:22:20.939Z |
5434191 | 5434191 | 20241030083625_2uUFG | NZ003C | 2024-11-01T12:01:29.438Z | 2024-11-03T14:22:17.946Z |
5427985 | 5427985 | 20241028160945_X9gTQ | NZ003C | 2024-10-31T12:14:22.104Z | 2024-11-03T14:24:49.421Z |
5427906 | 5427906 | 20241028155913_2Jk51 | NZ003C | 2024-10-31T12:14:12.859Z | 2024-11-03T14:24:49.301Z |
5427883 | 5427883 | 20241028155639_pIi8U | NZ003C | 2024-10-31T12:14:08.604Z | 2024-11-03T14:24:49.249Z |
5427666 | 5427666 | 20241028152919_kEtie | NZ003C | 2024-10-31T12:13:46.321Z | 2024-11-03T14:24:48.297Z |
5427397 | 5427397 | 20241028150202_WeE2G | NZ003C | 2024-10-31T12:13:30.157Z | 2024-11-03T14:24:47.606Z |
5427179 | 5427179 | 20241028144019_4pZWc | NZ003C | 2024-10-31T12:13:18.356Z | 2024-11-03T14:24:46.315Z |
5426607 | 5426607 | 20241028133311_UJS3y | NZ003C | 2024-10-31T12:12:16.360Z | 2024-11-03T14:24:44.090Z |
5422630 | 5422630 | 20241028132233_xjx2J | NZ003C | 2024-10-30T12:20:29.042Z | 2024-11-03T14:24:42.971Z |
5422582 | 5422582 | 20241028131717_d4APK | NZ003C | 2024-10-30T12:20:27.987Z | 2024-11-03T14:24:42.706Z |
5422330 | 5422330 | 20241028124941_Hb23r | NZ003C | 2024-10-30T12:20:25.520Z | 2024-11-03T14:24:41.894Z |
5422309 | 5422309 | 20241028124727_opbUa | NZ003C | 2024-10-30T12:20:25.344Z | 2024-11-03T14:24:41.861Z |
5422252 | 5422252 | 20241028123712_UCgji | NZ003C | 2024-10-30T12:20:24.472Z | 2024-11-03T14:24:41.418Z |
5422225 | 5422225 | 20241028123351_ZhM4E | NZ003C | 2024-10-30T12:20:23.951Z | 2024-11-03T14:24:41.326Z |
5422153 | 5422153 | 20241028122158_u7u2x | NZ003C | 2024-10-30T12:20:22.927Z | 2024-11-03T14:24:41.168Z |
5422132 | 5422132 | 20241028121919_FlSlv | NZ003C | 2024-10-30T12:20:22.621Z | 2024-11-03T14:24:41.101Z |
5421971 | 5421971 | 20241028120425_kZYjg | NZ003C | 2024-10-30T12:20:19.371Z | 2024-11-03T14:24:39.974Z |
5421904 | 5421904 | 20241028115753_x2iPu | NZ003C | 2024-10-30T12:20:17.459Z | 2024-11-03T14:24:39.733Z |
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);