names

77 rows where place_id = 598503

✎ 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
3588341 1864004 1864004 plaintiff Beene John (legal representative) 598503 598503 Beene, John, of Sterston, executors of 0
3632801 1905070 1905070 defendant Goldsmyth William husbandman 598503 598503 Goldsmyth, William, of Sterston, husbandman 0
3676772 1918771 1918771 plaintiff Kene Thomas   598503 598503 Kene, Thomas, of Sterston 0
3678008 1919164 1919164 defendant Leman William husbandman 598503 598503 Leman, William, of Sterston, husbandman 1
3685400 1921587 1921587 defendant Cley William husbandman 598503 598503 Cley, William, of Sterston, husbandman 0
3704845 1927808 1927808 defendant Grymmesby Simon husbandman 598503 598503 Grymmesby, Simon, of Sterston, husbandman 2
3704848 1927810 1927810 plaintiff Goldsmyth William   598503 598503 Goldsmyth, William, of Sterston 0
3706104 1928203 1928203 defendant Kane Thomas yeoman 598503 598503 Kane, Thomas, of Sterston, yeoman 0
3731862 1936195 1936195 defendant Goldesmyth William yeoman 598503 598503 Goldesmyth, William, of Sterston, yeoman 0
3736776 1937752 1937752 defendant Estowe Robert husbandman 598503 598503 Estowe, Robert, of Sterston, husbandman 0
3736778 1937753 1937753 defendant Estowe Robert husbandman 598503 598503 Estowe, Robert, of Sterston, husbandman 0
3736781 1937754 1937754 defendant Kempe Thomas husbandman 598503 598503 Kempe, Thomas, of Sterston, husbandman 1
3738158 1938148 1938148 defendant Goldsmyth Thomas husbandman 598503 598503 Goldsmyth, Thomas, of Sterston, husbandman 1
3749941 1941898 1941898 defendant Estowe Robert husbandman 598503 598503 Estowe, Robert, of Sterston, husbandman 0
3762967 1946048 1946048 defendant Kene Thomas yeoman 598503 598503 Kene, Thomas, of Sterston, yeoman 0
3762982 1946052 1946052 defendant Kene Thomas yeoman 598503 598503 Kene, Thomas, of Sterston, yeoman 0
3765174 1946770 1946770 defendant Estowe Robert husbandman 598503 598503 Estowe, Robert, of Sterston, husbandman 0
3765176 1946771 1946771 defendant Estowe Robert husbandman 598503 598503 Estowe, Robert, of Sterston, husbandman 0
3767538 1947484 1947484 defendant Goldsmyth William husbandman 598503 598503 Goldsmyth, William, of Sterston, husbandman 2
3773811 1949522 1949522 defendant Fykeis Thomas   598503 598503 Fykeis, Thomas, of Sterston, wool chapman 0
3783154 1952489 1952489 defendant Claxton Thomas husbandman 598503 598503 Claxton, Thomas, of Sterston, husbandman 1
3783907 1952742 1952742 plaintiff Loman William   598503 598503 Loman, William, of Sterston, administrators of 0
3801206 1958298 1958298 defendant Fykeis Joan widow 598503 598503 Fykeis, Joan, of Sterston, widow 1
3804237 1959258 1959258 defendant Fykeys Joan widow 598503 598503 Fykeys, Joan, of Sterston, widow 1
3806344 1959899 1959899 defendant Kene Thomas gent 598503 598503 Kene, Thomas, of Sterston, gent 1
3830478 1967411 1967411 defendant Wrettys John, senior husbandman 598503 598503 Wrettys, John, senior, of Sterston, husbandman 0
3830809 1967518 1967518 defendant Kemp Thomas husbandman 598503 598503 Kemp, Thomas, of Sterston, husbandman 0
3849402 1973410 1973410 defendant Cotney Roland clerk 598503 598503 Cotney, Roland, of Sterston, clerk 0
3919164 1996736 1996736 plaintiff Kene Thomas   598503 598503 Kene, Thomas, of Sterston 0
3919166 1996736 1996736 defendant Cotney Roland clerk 598503 598503 Cotney, Roland, of Sterston, clerk 1
4044421 2040458 2040458 plaintiff Reade William   598503 598503 Reade, William, of Sterston 0
4044423 2040459 2040459 plaintiff Reade William   598503 598503 Reade, William, of Sterston 0
4219466 2102309 2102309 defendant Flatman Thomas yeoman 598503 598503 Flatman, Thomas, of Sterston, yeoman 0
4226551 2104762 2104762 defendant Buninge Anne widow 598503 598503 Buninge, Anne, of Sterston, widow 0
4226552 2104762 2104762 defendant Buninge Robert husbandman 598503 598503 Buninge, Robert, of Sterston, husbandman 1
4226553 2104762 2104762 defendant Buninge Thomas husbandman 598503 598503 Buninge, Thomas, of Sterston, husbandman 2
4253693 2114226 2114226 defendant Bunynge Anne widow 598503 598503 Bunynge, Anne, of Sterston, widow 0
4253694 2114226 2114226 defendant Bunynge Robert husbandman 598503 598503 Bunynge, Robert, of Sterston, husbandman 1
4253695 2114226 2114226 defendant Bunynge Thomas husbandman 598503 598503 Bunynge, Thomas, of Sterston, husbandman 2
4286054 2125068 2125068 defendant Lebold John tailor 598503 598503 Lebold, John, of Sterston, tailor 0
4288202 2125827 2125827 defendant Whiting John   598503 598503 Whiting, John, of Sterston, "lathryver" 0
4288203 2125827 2125827 defendant Corbyn Robert joiner 598503 598503 Corbyn, Robert, of Sterston, joiner 1
4292878 2127519 2127519 defendant Flatman Robert, junior yeoman 598503 598503 Flatman, Robert, junior, of Sterston, yeoman 0
4310147 2133703 2133703 defendant Flatman Robert, junior yeoman 598503 598503 Flatman, Robert, junior, of Sterston, yeoman 0
4315109 2135398 2135398 defendant Lebolde John tailor 598503 598503 Lebolde, John, of Sterston, tailor 1
4315110 2135398 2135398 defendant Robwoode Thomas yeoman 598503 598503 Robwoode, Thomas, of Sterston, yeoman 2
4335842 2142266 2142266 defendant Whitinge Robert joiner 598503 598503 Whitinge, Robert, of Sterston, joiner 0
4335843 2142266 2142266 defendant Whitinge John   598503 598503 Whitinge, John, of Sterston, "lath ryver" 1
4352216 2148010 2148010 defendant Flatman Katherine widow 598503 598503 Flatman, Katherine, of Sterston, widow 0
4352219 2148010 2148010 defendant Flatman Thomas yeoman 598503 598503 Flatman, Thomas, of Sterston, yeoman 3
4550825 2216194 2216194 defendant Burgeys John   598503 598503 Burgeys, John, of Sterston 0
4576488 2224158 2224158 defendant Skynnere William   598503 598503 Skynnere, William, of Sterston 3
4583125 2226143 2226143 plaintiff Floteman John   598503 598503 Floteman, John, of Sterston 0
4754346 2281739 2281739 defendant Rees John husbandman 598503 598503 Rees, John, of Sterston, husbandman 2
4923825 2333893 2333893 defendant Bocher John husbandman 598503 598503 Bocher, John, of Sterston, husbandman 2
5120803 2392515 2392515 defendant Penne John yeoman 598503 598503 Penne,John, of Sterston, yeoman 2
5172301 2407624 2407624 defendant Poytras John yeoman 598503 598503 Poytras, John, of Sterston, yeoman 0
5276646 2438251 2438251 defendant Bloxnawe John   598503 598503 Bloxnawe, John, of Sterston, administrators of 0
5365279 2464816 2464816 plaintiff Beene John yeoman 598503 598503 Beene, John, of Sterston, yeoman 0
5379298 2469117 2469117 defendant Leman Thomas husbandman 598503 598503 Leman, Thomas, of Sterston, husbandman 1
5379696 2469234 2469234 defendant Johnson William fuller 598503 598503 Johnson, William, of Sterston, fuller 2
5379697 2469234 2469234 defendant Arneoppe John husbandman 598503 598503 Arneoppe, John, of Sterston, husbandman 3
5384197 2470568 2470568 plaintiff Beeme John   598503 598503 Beeme. John, of Sterston 0
5399227 2474849 2474849 plaintiff Deene John yeoman 598503 598503 Deene, John, of Sterston, yeoman 0
5409733 2477888 2477888 plaintiff Boone John yeoman 598503 598503 Boone, John, of Sterston, yeoman 0
5426869 2482982 2482982 plaintiff Deene John yeoman 598503 598503 Deene, John, of Sterston, yeoman 0
5426871 2482983 2482983 plaintiff Deene John yeoman 598503 598503 Deene, John, of Sterston, yeoman 0
5445121 2488428 2488428 defendant Bene John husbandman 598503 598503 Bene, John, of Sterston, husbandman 1
5490205 2501955 2501955 plaintiff Bene John (legal representative) 598503 598503 Bene, John, of Sterston, executors of 0
5490206 2501955 2501955 plaintiff Leman Thomas   598503 598503 (Leman, Thomas, of Sterston 1
5505141 2506517 2506517 plaintiff Bene John (legal representative) 598503 598503 Bene, John, of Sterston, executors of 0
5522168 2511748 2511748 defendant Holande John yeoman 598503 598503 Holande, John, of Sterston, yeoman 0
5532514 2514713 2514713 plaintiff Wodward John   598503 598503 Wodward, John, of Sterston 1
5553439 2521043 2521043 defendant Broun John clerk 598503 598503 Broun, John, of Sterston, clerk 5
5553472 2521051 2521051 defendant Broun John clerk 598503 598503 Broun, John, of Sterston, clerk 4
5595822 2533605 2533605 defendant Dade John husbandman 598503 598503 Dade, John, of Sterston, husbandman 1
5607527 2537249 2537249 defendant Feld John husbandman 598503 598503 Feld, John, of Sterston, husbandman 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);