names

56 rows where place_id = 632994

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3810079 1961043 1961043 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 1
3834084 1968600 1968600 plaintiff Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
3865089 1978528 1978528 plaintiff Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
3879147 1983279 1983279 plaintiff Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
4015547 2030258 2030258 plaintiff Smythe Richard   632994 632994 Smythe, Richard, of Aston, Yorks 0
4046758 2041295 2041295 plaintiff Smythe Richard   632994 632994 Smythe, Richard, of Aston, Yorks 0
4147876 2077393 2077393 defendant Egden Richard yeoman 632994 632994 Egden, Richard, of Aston, Yorks, yeoman 1
4302583 2131020 2131020 defendant Poge George esq 632994 632994 Poge, George, of Aston, Yorks, esq 0
4880231 2320729 2320729 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, gent, son of Melton, John, knight 1
4880237 2320730 2320730 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, gent, son of Melton, John, knight 1
4942762 2339707 2339707 defendant Quyxsley John gent 632994 632994 Quyxsley, John, of Aston, Yorks, gent 1
5140247 2398248 2398248 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5140332 2398279 2398279 defendant Melton or Metton John   632994 632994 Melton or Metton, John, of Aston, Yorks, knight 0
5140336 2398280 2398280 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5141475 2398624 2398624 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 1
5150672 2401346 2401346 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knght 0
5150675 2401347 2401347 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5159484 2403888 2403888 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knght 0
5159487 2403889 2403889 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5162594 2404781 2404781 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 1
5162597 2404782 2404782 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 1
5169099 2406700 2406700 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5169102 2406701 2406701 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5174602 2408271 2408271 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5174605 2408272 2408272 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5176580 2408834 2408834 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 1
5198822 2415408 2415408 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5213479 2419674 2419674 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5225334 2423081 2423081 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5225421 2423113 2423113 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5227361 2423629 2423629 defendant Wythes Alan yeoman 632994 632994 Wythes, Alan, of Aston, Yorks, yeoman 2
5235402 2425937 2425937 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5271611 2436793 2436793 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5279755 2439161 2439161 defendant Melton John esq 632994 632994 Melton, John, of Aston, Yorks, esq 0
5279759 2439162 2439162 defendant Melton John esq 632994 632994 Melton, John, of Aston, Yorks, esq 0
5311698 2448520 2448520 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5336448 2455968 2455968 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight, administrators of 0
5373530 2467319 2467319 defendant Melton Robert esq 632994 632994 Melton, Robert, of Aston, Yorks, esq 1
5382158 2469956 2469956 defendant Kmelton John   632994 632994 Kmelton, John, of Aston, Yorks, knight 0
5390426 2472324 2472324 defendant Melton Robert esq 632994 632994 Melton, Robert, of Aston, Yorks, esq 1
5390429 2472325 2472325 defendant Melton Robert esq 632994 632994 Melton, Robert, of Aston, Yorks, esq 0
5416875 2479965 2479965 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5433228 2484903 2484903 defendant Melton Robert esq 632994 632994 Melton, Robert, of Aston, Yorks, esq 3
5433858 2485093 2485093 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5433866 2485094 2485094 defendant Melton Robert esq 632994 632994 Melton, Robert, of Aston, Yorks, esq 1
5433908 2485101 2485101 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5433909 2485101 2485101 defendant Melton Robert esq 632994 632994 Melton, Robert, of Aston, Yorks, esq 1
5449052 2489610 2489610 defendant Melton Robert esq 632994 632994 Melton, Robert, of Aston, Yorks, esq 3
5508359 2507489 2507489 defendant Amelton John   632994 632994 Amelton, John, of Aston, Yorks, knight 2
5508364 2507490 2507490 defendant Amelton John   632994 632994 Amelton, John, of Aston, Yorks, knight 3
5514397 2509351 2509351 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 2
5514407 2509353 2509353 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5544369 2518346 2518346 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5544588 2518417 2518417 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 0
5572377 2526471 2526471 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, knight 3
5579090 2528532 2528532 defendant Melton John   632994 632994 Melton, John, of Aston, Yorks, esq, son of Melton, John, knight 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);