names

33 rows where place_id = 587639

✎ 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
3592021 1865119 1865119 defendant Tyte Thomas mariner 587639 587639 Tyte, Thomas, of St Osith, Essex, mariner 1
3592472 1865261 1865261 defendant Page John merchant 587639 587639 Page, John, of St Osith, Essex, merchant, son of Page, William, junior, of St Osith, merchant 0
3599775 1867573 1867573 defendant Page John yeoman 587639 587639 Page, John, of St Osith, Essex, yeoman 0
3601611 1868160 1868160 defendant Page John, senior merchant 587639 587639 Page, John, senior, of St Osith, Essex, merchant 0
3604196 1868978 1868978 defendant Harleweyn John husbandman 587639 587639 Harleweyn, John, of St Osith, Essex, husbandman 0
3605624 1869424 1869424 defendant Page John, junior yeoman 587639 587639 Page, John, junior, of St Osith, Essex, yeoman 0
3616820 1872889 1872889 defendant Broun Thomas fuller 587639 587639 Broun, Thomas, of St Osith, Essex, fuller 1
3617503 1873095 1873095 plaintiff Fox William yeoman 587639 587639 Fox, William, of St Osith, Essex, yeoman 0
4700865 2265670 2265670 defendant Flete Richard yeoman 587639 587639 Flete, Richard, of St Osith, Essex, yeoman 1
4809100 2299024 2299024 defendant Frethe John yeoman 587639 587639 Frethe, John, of St Osith, Essex, yeoman 1
4809112 2299025 2299025 defendant Bryght John yeoman 587639 587639 Bryght, John, of St Osith, Essex, yeoman 5
4841371 2308835 2308835 defendant Hunt John yeoman 587639 587639 Hunt, John, of St Osith, Essex, yeoman 3
4848324 2310946 2310946 defendant Hunte John yeoman 587639 587639 Hunte, John, of St Osith, Essex, yeoman 2
4848332 2310948 2310948 defendant Barkere William butcher 587639 587639 Barkere, William, of St Osith, Essex, butcher 0
4868445 2317103 2317103 defendant Revenhale John husbandman 587639 587639 Revenhale, John, of St Osith, Essex, husbandman 0
4911287 2330035 2330035 defendant Burman John fuller 587639 587639 Burman, John, of St Osith, Essex, fuller 1
4923848 2333902 2333902 defendant Byrd Thomas pedder 587639 587639 Byrd, Thomas, of St Osith, Essex, pedder 1
4952157 2342613 2342613 defendant Meke Thomas chapman 587639 587639 Meke, Thomas, of St Osith, Essex, chapman 0
4952706 2342767 2342767 defendant Meke Thomas chapman 587639 587639 Meke, Thomas, of St Osith, Essex, chapman 0
4980071 2350990 2350990 defendant Dere Thomas shipman 587639 587639 Dere, Thomas, of St Osith, Essex, shipman 1
5040819 2368870 2368870 defendant Skylle Robert   587639 587639 Skylle, Robert, of St Osith, Essex, mason 0
5041794 2369147 2369147 defendant Meke Thomas shipman 587639 587639 Meke, Thomas, of St Osith, Essex, shipman 0
5133801 2396378 2396378 defendant Dymmok John husbandman 587639 587639 Dymmok, John, of St Osith, Essex, husbandman 0
5153678 2402233 2402233 defendant Dymmok John husbandman 587639 587639 Dymmok, John, of St Osith, Essex, husbandman 0
5153681 2402234 2402234 defendant Dymmok John husbandman 587639 587639 Dymmok, John, of St Osith, Essex, husbandman 0
5170999 2407243 2407243 defendant Dymmok John husbandman 587639 587639 Dymmok, John, of St Osith, Essex, husbandman 0
5352692 2460932 2460932 defendant Hasplonde James yeoman 587639 587639 Hasplonde, James, of St Osith, Essex, yeoman 2
5380733 2469541 2469541 defendant Page John husbandman 587639 587639 Page, John, of St Osith, Essex, husbandman 0
5385809 2471009 2471009 defendant Page John husbandman 587639 587639 Page, John, of St Osith, Essex, husbandman 0
5446366 2488807 2488807 defendant Kyrkeby Thomas husbandman 587639 587639 Kyrkeby, Thomas, of St Osith, Essex, husbandman 2
5509325 2507767 2507767 defendant Aspyllond James yeoman 587639 587639 Aspyllond, James, of St Osith, Essex, yeoman 2
5527572 2513202 2513202 defendant Cook Thomas, senior butcher 587639 587639 Cook, Thomas, senior, of St Osith, Essex, butcher 1
5569112 2525517 2525517 defendant Chandeler Thomas husbandman 587639 587639 Chandeler, Thomas, of St Osith, Essex, husbandman 3

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);