names

54 rows where place_id = 592224

✎ 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
3606982 1869846 1869846 defendant Farewell William husbandman 592224 592224 Farewell, William, of Todenham, husbandman 1
3607201 1869917 1869917 defendant Herdgrey William yeoman 592224 592224 Herdgrey, William, of Todenham, yeoman 4
3618216 1873321 1873321 defendant Wolyngton William merchant 592224 592224 Wolyngton, William, of Todenham, merchant 0
3618217 1873321 1873321 defendant Wolyngton John husbandman 592224 592224 Wolyngton, John, of Todenham, husbandman 1
3618915 1873526 1873526 plaintiff Hevenigham Thomas, senior   592224 592224 Hevenigham, Thomas, senior, of Todenham 0
3639981 1907320 1907320 defendant Castell Robert husbandman 592224 592224 Castell, Robert, of Todenham, husbandman 0
3656094 1912158 1912158 defendant Wyllyngton William husbandman 592224 592224 Wyllyngton, William, of Todenham, husbandman 0
3656113 1912165 1912165 defendant Wyllyngton William husbandman 592224 592224 Wyllyngton, William, of Todenham, husbandman 0
3657591 1912636 1912636 defendant Wyllyngton Nicholas husbandman 592224 592224 Wyllyngton, Nicholas, of Todenham, husbandman 0
3664175 1914744 1914744 defendant Wellys Thomas gent 592224 592224 Wellys, Thomas, of Todenham, gent 1
3748252 1941380 1941380 defendant Poler George husbandman 592224 592224 Poler, George, of Todenham, husbandman 5
3748253 1941380 1941380 defendant Warde John husbandman 592224 592224 Warde, John, of Todenham, husbandman 6
3748619 1941499 1941499 defendant Poler George husbandman 592224 592224 Poler, George, of Todenham, husbandman 5
3748620 1941499 1941499 defendant Warde John husbandman 592224 592224 Warde, John, of Todenham, husbandman 6
3839865 1970403 1970403 plaintiff Wyllyngton John (legal representative) 592224 592224 Wyllyngton, John, of Todenham, executor of 0
4449616 2184827 2184827 defendant Buk John   592224 592224 Buk, John, of Todenham 0
4451252 2185351 2185351 plaintiff Hethe Roger de   592224 592224 Hethe, Roger de, of Todenham, parson 0
4473310 2192311 2192311 defendant Egate Edmund   592224 592224 Egate, Edmund, of Todenham 0
4473311 2192311 2192311 defendant Dyne Richard   592224 592224 Dyne, Richard, of Todenham 1
4485376 2196130 2196130 plaintiff Pype Thomas   592224 592224 Pype, Thomas, of Todenham, parson 0
4543965 2214019 2214019 plaintiff Bakhot John   592224 592224 Bakhot, John, of Todenham 0
4580997 2225535 2225535 plaintiff Don Richard chaplain 592224 592224 Don, Richard, of Todenham, chaplain 0
4608701 2233826 2233826 defendant Harneys Richard   592224 592224 Harneys, Richard, of Todenham 2
4637526 2242527 2242527 defendant Harneys Richard   592224 592224 Harneys, Richard, of Todenham 2
4640822 2243416 2243416 defendant Clerk Robert chaplain 592224 592224 Clerk, Robert, of Todenham, chaplain 1
4640823 2243416 2243416 defendant dil Medwe Adam   592224 592224 dil Medwe, Adam, of Todenham 2
4650483 2246160 2246160 defendant Dene John   592224 592224 Dene, John, of Todenham 0
4739022 2277295 2277295 defendant Broun William   592224 592224 Broun, William, of Todenham, shepherd 3
4743292 2278564 2278564 defendant Daubeney Robert husbandman 592224 592224 Daubeney, Robert, of Todenham, husbandman 0
4756991 2282558 2282558 defendant Polle Thomas smith 592224 592224 Polle, Thomas, of Todenham, smith 0
4756992 2282558 2282558 defendant Curray Christine widow 592224 592224 Curray, Christine, of Todenham, widow 1
4756994 2282558 2282558 defendant Gadircold John husbandman 592224 592224 Gadircold, John, of Todenham, husbandman 3
4772645 2287414 2287414 defendant Bekeswell John gent 592224 592224 Bekeswell, John, of Todenham, gent 0
4777659 2289009 2289009 defendant Daubeneye Robert woolman 592224 592224 Daubeneye, Robert, of Todenham, woolman 0
4777660 2289009 2289009 defendant Kempe Thomas woolman 592224 592224 Kempe, Thomas, of Todenham, woolman 1
4784219 2291063 2291063 defendant Broune Richard yeoman 592224 592224 Broune, Richard, of Todenham, yeoman 0
4797973 2295550 2295550 defendant Bekeswell John gent 592224 592224 Bekeswell, John, of Todenham, gent 0
4849870 2311431 2311431 defendant Sekford John yeoman 592224 592224 Sekford, John, of Todenham, yeoman 2
4865106 2316060 2316060 defendant Draweswerd John butcher 592224 592224 Draweswerd, John, of Todenham, butcher 0
4865111 2316061 2316061 defendant Draweswerd John butcher 592224 592224 Draweswerd, John, of Todenham, butcher 0
4877480 2319915 2319915 defendant Forthe Richard carpenter 592224 592224 Forthe, Richard, of Todenham, carpenter 0
4892959 2324525 2324525 defendant Cook Edmund farmer 592224 592224 Cook, Edmund, of Todenham, farmer 0
4892960 2324525 2324525 defendant Leveryngton Andrew yeoman 592224 592224 Leveryngton, Andrew, of Todenham, yeoman 1
4956024 2343767 2343767 defendant Hamond John, junior husbandman 592224 592224 Hamond, John, junior, of Todenham, husbandman 0
4968340 2347494 2347494 defendant Bristowe John husbandman 592224 592224 Bristowe, John, of Todenham, husbandman 0
5019853 2362685 2362685 defendant Mynter John yeoman 592224 592224 Mynter, John, of Todenham, yeoman 2
5251659 2430624 2430624 defendant Leyke Walter husbandman 592224 592224 Leyke, Walter, of Todenham, husbandman 0
5259163 2432981 2432981 defendant Foster John husbandman 592224 592224 Foster, John, of Todenham, husbandman 0
5325615 2452738 2452738 defendant Bretyngham Thomas husbandman 592224 592224 Bretyngham, Thomas, of Todenham, husbandman 3
5337165 2456187 2456187 defendant Grubbe Thomas husbandman 592224 592224 Grubbe, Thomas, of Todenham, husbandman 3
5585835 2530621 2530621 defendant Skitlade Alan husbandman 592224 592224 Skitlade, Alan, of Todenham, husbandman 0
5585838 2530622 2530622 defendant Gathyrcold Robert husbandman 592224 592224 Gathyrcold, Robert, of Todenham, husbandman 0
5596136 2533707 2533707 defendant Wellys Thomas gent 592224 592224 Wellys, Thomas, of Todenham, gent 0
5610130 2546877 2546877 plaintiff atte Helle John   592224 592224 atte Helle, John, of Todenham, on his own account 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);