names

55 rows where place_id = 587355

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591171 1864861 1864861 defendant Forde John husbandman 587355 587355 Forde, John, of Wartlyng, husbandman 0
3700182 1926288 1926288 defendant Gyrdeler Richard laborer 587355 587355 Gyrdeler, Richard, of Wartlyng, laborer 2
3700183 1926288 1926288 defendant Russell John laborer 587355 587355 Russell, John, of Wartlyng, laborer 3
3709383 1929232 1929232 defendant Clement Robert butcher 587355 587355 Clement, Robert, of Wartlyng, butcher 1
3741550 1939226 1939226 defendant Colbrond Thomas butcher 587355 587355 Colbrond, Thomas, of Wartlyng, butcher 0
3741551 1939226 1939226 defendant Olyvere William butcher 587355 587355 Olyvere, William, of Wartlyng, butcher 1
3744424 1940158 1940158 defendant Colbrand Thomas butcher 587355 587355 Colbrand, Thomas, of Wartlyng, butcher 0
3777545 1950728 1950728 defendant Comber John yeoman 587355 587355 Comber, John, of Wartlyng, yeoman 0
3780735 1951709 1951709 defendant Wylson John butcher 587355 587355 Wylson, John, of Wartlyng, butcher 1
4058480 2045422 2045422 plaintiff Cheseman John husbandman 587355 587355 Cheseman, John, of Wartlyng, husbandman 0
4058481 2045422 2045422 plaintiff Typpett John husbandman 587355 587355 Typpett, John, of Wartlyng, husbandman 1
4058482 2045422 2045422 defendant Master Richard carpenter 587355 587355 Master, Richard, of Wartlyng, or of Herstmounceux, carpenter 0
4079548 2052983 2052983 defendant Cardye Thomas yeoman 587355 587355 Cardye, Thomas, of Wartlyng, yeoman 0
4093092 2057846 2057846 defendant Pynchyn John yeoman 587355 587355 Pynchyn, John, of Wartlyng, yeoman 0
4102629 2061240 2061240 defendant Rose Robert sawyer 587355 587355 Rose, Robert, of Wartlyng, sawyer 0
4104144 2061756 2061756 defendant Rogers alias Masters Richard carpenter 587355 587355 Rogers alias Masters, Richard, of Wartlyng, carpenter 0
4104145 2061756 2061756 defendant Gregorye Richard yeoman 587355 587355 Gregorye, Richard, of Wartlyng, yeoman 1
4104146 2061756 2061756 defendant Woodlande John yeoman 587355 587355 Woodlande, John, of Wartlyng, yeoman 2
4104148 2061757 2061757 defendant Rogers alias Masters Richard carpenter 587355 587355 Rogers alias Masters, Richard, of Wartlyng, carpenter 0
4104149 2061757 2061757 defendant Gregorye Richard yeoman 587355 587355 Gregorye, Richard, of Wartlyng, yeoman 1
4104150 2061757 2061757 defendant Woodlande John yeoman 587355 587355 Woodlande, John, of Wartlyng, yeoman 2
4108634 2063343 2063343 defendant Master alias Rogers Richard carpenter 587355 587355 Master alias Rogers, Richard, of Wartlyng, carpenter 0
4123807 2068812 2068812 defendant Snowe Thomas yeoman 587355 587355 Snowe, Thomas, of Wartlyng, yeoman 0
4126630 2069810 2069810 defendant Masters alias Rogers Richard carpenter 587355 587355 Masters alias Rogers, Richard, of Wartlyng, carpenter 0
4128606 2070522 2070522 defendant Mayster alias Rogers Richard carpenter 587355 587355 Mayster alias Rogers, Richard, of Wartlyng, carpenter 2
4128610 2070523 2070523 defendant Masters alias Rogers Richard carpenter 587355 587355 Masters alias Rogers, Richard, of Wartlyng, carpenter 2
4132585 2071972 2071972 defendant Messant Henry husbandman 587355 587355 Messant, Henry, of Wartlyng, husbandman 1
4141418 2075155 2075155 defendant Martyn John husbandman 587355 587355 Martyn, John, of Wartlyng, husbandman 1
4154572 2079691 2079691 defendant Brett James yeoman 587355 587355 Brett, James, of Wartlyng, yeoman 0
4167836 2084236 2084236 defendant Snowe Thomas husbandman 587355 587355 Snowe, Thomas, of Wartlyng, husbandman 0
4168001 2084294 2084294 defendant Snowe Thomas husbandman 587355 587355 Snowe, Thomas, of Wartlyng, husbandman 0
4171009 2085343 2085343 defendant Danyell Robert yeoman 587355 587355 Danyell, Robert, of Wartlyng, yeoman 1
4172321 2085784 2085784 defendant Dufford Arthur smith 587355 587355 Dufford, Arthur, of Wartlyng, smith 2
4172322 2085784 2085784 defendant Kyngeswell Richard tailor 587355 587355 Kyngeswell, Richard, of Wartlyng, tailor 3
4177606 2087644 2087644 defendant Baldocke John husbandman 587355 587355 Baldocke, John, of Wartlyng, husbandman 0
4183529 2089721 2089721 defendant Assheburnham Thomas gent 587355 587355 Assheburnham, Thomas, of Wartlyng, gent 0
4184920 2090233 2090233 defendant Martyn John husbandman 587355 587355 Martyn, John, of Wartlyng, husbandman 1
4189395 2091791 2091791 defendant Chesman John yeoman 587355 587355 Chesman, John, of Wartlyng, yeoman 0
4189398 2091792 2091792 defendant Pont Edward yeoman 587355 587355 Pont, Edward, of Wartlyng, yeoman 0
4189401 2091793 2091793 defendant Snowe Thomas yeoman 587355 587355 Snowe, Thomas, of Wartlyng, yeoman 0
4189404 2091794 2091794 defendant Snowe Thomas yeoman 587355 587355 Snowe, Thomas, of Wartlyng, yeoman 0
4189405 2091794 2091794 defendant Pont Edward yeoman 587355 587355 Pont, Edward, of Wartlyng, yeoman 1
4189406 2091794 2091794 defendant Chesman of Cheesman John yeoman 587355 587355 Chesman of Cheesman, John, of Wartlyng, yeoman 2
4812379 2299983 2299983 defendant Ponte William husbandman 587355 587355 Ponte, William, of Wartlyng, husbandman 3
5101309 2386793 2386793 defendant Spencer Richard butcher 587355 587355 Spencer, Richard, of Wartlyng, butcher 0
5229934 2424372 2424372 defendant Colbrand John, junior laborer 587355 587355 Colbrand, John, junior, of Wartlyng, laborer 4
5229935 2424372 2424372 defendant Colbrand Thomas laborer 587355 587355 Colbrand, Thomas, of Wartlyng, laborer 5
5236766 2426338 2426338 defendant Colbronde Thomas carpenter 587355 587355 Colbronde, Thomas, of Wartlyng, carpenter 0
5351576 2460592 2460592 defendant A Forthe John husbandman 587355 587355 A Forthe, John, of Wartlyng, husbandman 0
5373757 2467385 2467385 defendant Mille Richard yeoman 587355 587355 Mille, Richard, of Wartlyng, yeoman 0
5506958 2507092 2507092 plaintiff Colbrod Ralph   587355 587355 Colbrod, Ralph, of Wartlyng 0
5581351 2529236 2529236 defendant Brighnok John husbandman 587355 587355 Brighnok, John, of Wartlyng, husbandman 0
5581353 2529237 2529237 defendant Brighnok John husbandman 587355 587355 Brighnok, John, of Wartlyng, husbandman 0
5602763 2535743 2535743 defendant Carpenter Thomas yeoman 587355 587355 Carpenter, Thomas, of Wartlyng, yeoman 0
5607914 2537380 2537380 defendant Myll Alice (legal representative) 587355 587355 Myll, Alice, of Wartlyng, widow, executrix of Myll, Richard, of Wartlyng, yeoman, administrator of 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);