names

50 rows where place_id = 598815

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3627955 1903599 1903599 defendant Salter Robert   598815 598815 Salter, Robert, of Norton Subcors, paten maker 0
3634176 1905491 1905491 defendant Salter Robert husbandman 598815 598815 Salter, Robert, of Norton Subcors, husbandman 0
3696182 1925026 1925026 defendant Hustynges Thomas yeoman 598815 598815 Hustynges, Thomas, of Norton Subcors, yeoman 0
3710027 1929446 1929446 defendant Hustynges Thomas yeoman 598815 598815 Hustynges, Thomas, of Norton Subcors, yeoman 0
3762997 1946057 1946057 defendant Kykk William husbandman 598815 598815 Kykk, William, of Norton Subcors, husbandman 1
3769795 1948208 1948208 defendant Middelton John husbandman 598815 598815 Middelton, John, of Norton Subcors, husbandman 0
3769796 1948208 1948208 defendant Kykk William husbandman 598815 598815 Kykk, William, of Norton Subcors, husbandman 1
3787606 1953912 1953912 defendant Midelton John husbandman 598815 598815 Midelton, John, of Norton Subcors, husbandman 0
3803852 1959119 1959119 defendant Hoystyng Thomas husbandman 598815 598815 Hoystyng, Thomas, of Norton Subcors, husbandman 0
3821265 1964541 1964541 defendant Hoystyng Thomas husbandman 598815 598815 Hoystyng, Thomas, of Norton Subcors, husbandman 0
4003630 2026063 2026063 defendant Wale John husbandman 598815 598815 Wale, John, of Norton Subcors, husbandman 0
4244359 2111091 2111091 defendant Emery Jeremy clerk 598815 598815 Emery, Jeremy, of Norton Subcors, clerk 0
4244364 2111092 2111092 defendant Emery Jeremiah clerk 598815 598815 Emery, Jeremiah, of Norton Subcors, clerk 0
4319484 2136924 2136924 defendant Freman John yeoman 598815 598815 Freman, John, of Norton Subcors, yeoman 0
4319485 2136924 2136924 defendant Chamberleyn Thomas yeoman 598815 598815 Chamberleyn, Thomas, of Norton Subcors, yeoman 1
4340309 2143875 2143875 defendant Cullender William husbandman 598815 598815 Cullender, William, of Norton Subcors, husbandman 0
4348538 2146741 2146741 defendant Davy John husbandman 598815 598815 Davy, John, of Norton Subcors, husbandman 0
4352635 2148155 2148155 defendant Emerye Jerome (legal representative) 598815 598815 Emerye, Jerome, of Norton Subcors, clerk, administratrix of 0
4352636 2148155 2148155 defendant Emery Alice widow 598815 598815 Emery, Alice, of Norton Subcors, widow 1
4394893 2162876 2162876 defendant Willis William blacksmith 598815 598815 Willis, William, of Norton Subcors, blacksmith 0
4399440 2164401 2164401 defendant Flegge Miles clothworker 598815 598815 Flegge, Miles, of Norton Subcors, clothworker 0
4399441 2164401 2164401 defendant Emerye Jerome (legal representative) 598815 598815 Emerye, Jerome, of Norton Subcors, clerk, administratrix of 1
4399442 2164401 2164401 defendant Emerye Alice widow 598815 598815 Emerye, Alice, of Norton Subcors, widow 2
4402682 2165481 2165481 defendant Davye John yeoman 598815 598815 Davye, John, of Norton Subcors, yeoman 0
4762802 2284345 2284345 defendant Crane John husbandman 598815 598815 Crane, John, of Norton Subcors, husbandman 3
4762803 2284345 2284345 defendant Couper John husbandman 598815 598815 Couper, John, of Norton Subcors, husbandman 4
4779634 2289616 2289616 defendant Sexteyn John husbandman 598815 598815 Sexteyn, John, of Norton Subcors, husbandman 0
4884291 2321993 2321993 defendant Weston Alexander yeoman 598815 598815 Weston, Alexander, of Norton Subcors, yeoman 3
4897798 2325975 2325975 defendant Smyth Richard husbandman 598815 598815 Smyth, Richard, of Norton Subcors, husbandman 0
4916676 2331726 2331726 defendant Smyth John   598815 598815 Smyth, John, of Norton Subcors 2
4916686 2331726 2331726 defendant Smyth Richard   598815 598815 Smyth, Richard, of Norton Subcors 12
4916687 2331726 2331726 defendant Multon John yeoman 598815 598815 Multon, John, of Norton Subcors, yeoman 13
4916702 2331727 2331727 defendant Smyth Richard   598815 598815 Smyth, Richard, of Norton Subcors 12
4916708 2331729 2331729 defendant Smyth Richard husbandman 598815 598815 Smyth, Richard, of Norton Subcors, husbandman 0
4942877 2339745 2339745 defendant Lammes Robert yeoman 598815 598815 Lammes, Robert, of Norton Subcors, yeoman 0
4948811 2341609 2341609 defendant Westbrook William clerk 598815 598815 Westbrook, William, of Norton Subcors, clerk 0
4949904 2341945 2341945 defendant Multon John husbandman 598815 598815 Multon, John, of Norton Subcors, husbandman 8
4954598 2343333 2343333 defendant Weston Alexander yeoman 598815 598815 Weston, Alexander, of Norton Subcors, yeoman 0
4954599 2343333 2343333 defendant Kyckys John carpenter 598815 598815 Kyckys, John, of Norton Subcors, carpenter 1
4954600 2343333 2343333 defendant Multon John yeoman 598815 598815 Multon, John, of Norton Subcors, yeoman 2
4955477 2343601 2343601 defendant Westbrook William clerk 598815 598815 Westbrook, William, of Norton Subcors, clerk 0
4962220 2345602 2345602 defendant Multon John yeoman 598815 598815 Multon, John, of Norton Subcors, yeoman 2
4969679 2347877 2347877 defendant Smyth William husbandman 598815 598815 Smyth, William, of Norton Subcors, husbandman 2
5032353 2366341 2366341 defendant Woderove Richard husbandman 598815 598815 Woderove, Richard, of Norton Subcors, husbandman 1
5063242 2375537 2375537 plaintiff Hubberd John   598815 598815 Hubberd, John, of Norton Subcors 0
5063243 2375537 2375537 defendant Lammes Robert yeoman 598815 598815 Lammes, Robert, of Norton Subcors, yeoman 0
5182047 2410497 2410497 defendant Kyckys Geoffrey laborer 598815 598815 Kyckys, Geoffrey, of Norton Subcors, laborer 5
5272041 2436904 2436904 defendant Launes Robert husbandman 598815 598815 Launes, Robert, of Norton Subcors, husbandman 2
5328449 2453583 2453583 defendant Weston William husbandman 598815 598815 Weston, William, of Norton Subcors, husbandman 4
5604722 2536341 2536341 defendant Salter Robert   598815 598815 Salter, Robert, of Norton Subcors, patin maker 1

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