names

37 rows where place_id = 653439

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3928576 1999898 1999898 plaintiff Bond Anthony   653439 653439 Bond, Anthony, of London, scrivenor 0
4553561 2217045 2217045 defendant Seman Martin   653439 653439 Seman, Martin, of London, scrivenor 0
4584118 2226453 2226453 defendant Wanstall William   653439 653439 Wanstall, William, of London, scrivenor 3
4604981 2232719 2232719 defendant Tannere John   653439 653439 Tannere, John, of London, scrivenor 0
4616554 2236174 2236174 defendant Tannere John   653439 653439 Tannere, John, of London, scrivenor 0
4727165 2273757 2273757 defendant Payn John   653439 653439 Payn, John, of London, scrivenor 0
4750132 2280511 2280511 plaintiff Tannere John   653439 653439 Tannere, John, of London, scrivenor 2
4760465 2283625 2283625 defendant Kyngesmyll William   653439 653439 Kyngesmyll, William, of London, scrivenor 0
4763633 2284613 2284613 plaintiff Elene Walter   653439 653439 Elene, Walter, of London, scrivenor 1
4769050 2286298 2286298 defendant Scryvener Henry   653439 653439 Scryvener, Henry, of London, scrivenor 2
4770046 2286603 2286603 plaintiff Tanner John   653439 653439 Tanner, John, of London, scrivenor 2
4803590 2297309 2297309 defendant Wade Robert   653439 653439 Wade, Robert, of London, scrivenor 1
4841790 2308966 2308966 defendant Melton John   653439 653439 Melton, John, of London, scrivenor 0
4844489 2309792 2309792 defendant Wryter John   653439 653439 Wryter, John, of London, scrivenor 0
4845651 2310150 2310150 defendant Lyndesay Richard   653439 653439 Lyndesay, Richard, of London, scrivenor 0
4928547 2335357 2335357 defendant Clerk Thomas   653439 653439 Clerk, Thomas, of London, scrivenor 0
5001644 2357374 2357374 plaintiff Molton John   653439 653439 Molton, John, of London, scrivenor 0
5038922 2368287 2368287 plaintiff Stodeley John   653439 653439 Stodeley, John, of London, scrivenor 2
5041865 2369166 2369166 defendant Stones Nicholas   653439 653439 (Stones, Nicholas, of London, scrivenor 1
5160018 2404030 2404030 defendant Stifford William   653439 653439 Stifford, William, of London, scrivenor 1
5200567 2415925 2415925 defendant Asshburn Henry   653439 653439 Asshburn, Henry, of London, scrivenor 0
5303465 2446031 2446031 defendant Parker John   653439 653439 Parker, John, of London, scrivenor 3
5373871 2467425 2467425 plaintiff Morecok John   653439 653439 Morecok, John, of London, scrivenor 0
5373873 2467426 2467426 plaintiff Morecok John   653439 653439 Morecok, John, of London, scrivenor 0
5380271 2469404 2469404 defendant Nele alias Purser John   653439 653439 Nele alias Purser, John, of London, scrivenor 1
5383968 2470502 2470502 defendant Belham Richard   653439 653439 Belham, Richard, of London, scrivenor 0
5383971 2470503 2470503 defendant Delham Richard   653439 653439 Delham, Richard, of London, scrivenor 0
5384634 2470690 2470690 defendant Nele John   653439 653439 Nele, John, of London, scrivenor 1
5387479 2471490 2471490 defendant Plowefeld William   653439 653439 Plowefeld, William, of London, scrivenor 1
5396545 2474100 2474100 defendant Nele John   653439 653439 Nele, John, of London, scrivenor 1
5396560 2474106 2474106 defendant Nele John   653439 653439 Nele, John, of London, scrivenor 0
5409852 2477913 2477913 defendant Nele John   653439 653439 Nele, John, of London, scrivenor 0
5412950 2478820 2478820 defendant Plowfeld William   653439 653439 Plowfeld, William, of London, scrivenor 1
5423474 2481981 2481981 defendant Nele John   653439 653439 Nele, John, of London, scrivenor 0
5459383 2492722 2492722 defendant Wollaston John   653439 653439 Wollaston, John, of London, scrivenor 0
5461408 2493364 2493364 plaintiff Morecok John   653439 653439 Morecok, John, of London, scrivenor 0
5471076 2496289 2496289 defendant Wollerton John   653439 653439 Wollerton, John, of London, scrivenor 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);