names

65 rows where place_id = 626243

✎ 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
3768923 1947933 1947933 defendant Wilson Elizabeth widow 626243 626243 Wilson, Elizabeth, of Billesby, widow 0
3768924 1947933 1947933 defendant Wilson William yeoman 626243 626243 Wilson, William, of Billesby, yeoman 1
3820010 1964140 1964140 defendant Lynley Thomas mercer 626243 626243 Lynley, Thomas, of Billesby, mercer 0
4055901 2044492 2044492 defendant Forcett Thomas gent or esq 626243 626243 Forcett, Thomas, of Billesby, gent or esq 0
4062510 2046882 2046882 plaintiff Forsett Thomas esq 626243 626243 Forsett, Thomas, of Billesby, esq 0
4189196 2091714 2091714 defendant Swane William yeoman 626243 626243 Swane, William, of Billesby, yeoman 0
4189200 2091716 2091716 defendant Davison John yeoman 626243 626243 Davison, John, of Billesby, yeoman 0
4440874 2182062 2182062 defendant Pynder William   626243 626243 Pynder, William, of Billesby 0
4443788 2183029 2183029 plaintiff Chaumberlayn William   626243 626243 Chaumberlayn, William, of Billesby 0
4489608 2197468 2197468 defendant Jolanson Robert   626243 626243 Jolanson, Robert, of Billesby 0
4490466 2197713 2197713 defendant Gerberge Thomas   626243 626243 Gerberge, Thomas, of Billesby 0
4539492 2212610 2212610 plaintiff Walker Richard   626243 626243 Walker, Richard, of Billesby 0
4550648 2216145 2216145 defendant Malthorp Robert de chaplain 626243 626243 Malthorp, Robert de, of Billesby, chaplain 0
4679685 2259261 2259261 defendant Wryght Andrew carpenter 626243 626243 Wryght, Andrew, of Billesby, carpenter 2
4680210 2259418 2259418 defendant Forset Robert gent 626243 626243 Forset, Robert, of Billesby, gent 1
4683494 2260438 2260438 defendant Forset Robert husbandman 626243 626243 Forset, Robert, of Billesby, husbandman 1
4688434 2261949 2261949 defendant Houlyn Robert butcher 626243 626243 Houlyn, Robert, of Billesby, butcher 0
4691115 2262741 2262741 defendant Clerk Richard butcher 626243 626243 Clerk, Richard, of Billesby, butcher 0
4691116 2262741 2262741 defendant Honlyn Robert butcher 626243 626243 Honlyn, Robert, of Billesby, butcher 1
4694254 2263703 2263703 defendant Clerk Richard butcher 626243 626243 Clerk, Richard, of Billesby, butcher 0
4758845 2283119 2283119 defendant Clerk Richard husbandman 626243 626243 Clerk, Richard, of Billesby, husbandman 0
4758847 2283120 2283120 defendant Clerk Richard husbandman 626243 626243 Clerk, Richard, of Billesby, husbandman 0
4764076 2284753 2284753 defendant Saleby Andrew   626243 626243 Saleby, Andrew, of Billesby, wright 0
4787207 2292065 2292065 defendant Clerk Richard butcher 626243 626243 Clerk, Richard, of Billesby, butcher 0
4787209 2292066 2292066 defendant Clerk Richard butcher 626243 626243 Clerk, Richard, of Billesby, butcher 0
4792346 2293692 2293692 defendant Clerk Richard husbandman 626243 626243 Clerk, Richard, of Billesby, husbandman 0
4804231 2297510 2297510 defendant Ferrour John husbandman 626243 626243 Ferrour, John, of Billesby, husbandman 0
4804235 2297511 2297511 defendant Granne William weaver 626243 626243 Granne, William, of Billesby, weaver 2
4860177 2314543 2314543 defendant Ferour or Smith John husbandman 626243 626243 Ferour or Smith, John, of Billesby, husbandman 1
4860178 2314543 2314543 defendant Croft John husbandman 626243 626243 Croft, John, of Billesby, husbandman 2
4880516 2320817 2320817 defendant Bower John husbandman 626243 626243 Bower, John, of Billesby, husbandman 4
4897448 2325863 2325863 defendant Pynder John husbandman 626243 626243 Pynder, John, of Billesby, husbandman 1
4899072 2326352 2326352 defendant Pynder John husbandman 626243 626243 Pynder, John, of Billesby, husbandman 1
4902421 2327372 2327372 defendant Pynder John husbandman 626243 626243 Pynder, John, of Billesby, husbandman 1
4903799 2327807 2327807 defendant Vele William laborer 626243 626243 Vele, William, of Billesby, laborer 2
5009983 2359792 2359792 defendant Peper Thomas husbandman 626243 626243 Peper, Thomas, of Billesby, husbandman 0
5061959 2375179 2375179 plaintiff Hardbene John   626243 626243 Hardbene, John, of Billesby 0
5061966 2375180 2375180 plaintiff Hardbene John   626243 626243 Hardbene, John, of Billesby 0
5074006 2378713 2378713 defendant Pepyr Thomas husbandman 626243 626243 Pepyr, Thomas, of Billesby, husbandman 0
5086000 2382297 2382297 plaintiff Hardbene John   626243 626243 Hardbene, John, of Billesby 0
5099457 2386277 2386277 defendant Pynder Richard husbandman 626243 626243 Pynder, Richard, of Billesby, husbandman 0
5099459 2386277 2386277 defendant Lourdewyn Thomas weaver 626243 626243 Lourdewyn,Thomas, of Billesby, weaver 2
5121233 2392640 2392640 defendant Warde John gent 626243 626243 Warde, John, of Billesby, gent 0
5150688 2401350 2401350 defendant Bere Roger husbandman 626243 626243 Bere, Roger, of Billesby, husbandman 1
5191106 2413138 2413138 defendant Peper Thomas husbandman 626243 626243 Peper, Thomas, of Billesby, husbandman 0
5191984 2413386 2413386 defendant Trussell John gent 626243 626243 Trussell, John, of Billesby, gent 1
5207210 2417849 2417849 defendant Peper Thomas husbandman 626243 626243 Peper, Thomas, of Billesby, husbandman 0
5219104 2421313 2421313 defendant Affordby John   626243 626243 Affordby, John, of Billesby, son of Affordby, William 0
5238744 2426924 2426924 plaintiff Hardbene John   626243 626243 Hardbene, John, of Billesby 0
5258679 2432836 2432836 defendant Asfordby John gent 626243 626243 Asfordby, John, of Billesby, gent 0
5258680 2432836 2432836 defendant White John thatcher 626243 626243 together with White, John, of Billesby, thatcher 1
5258681 2432836 2432836 defendant Western Robert husbandman 626243 626243 Western, Robert, of Billesby, husbandman 2
5258687 2432837 2432837 defendant Asfordby John   626243 626243 Asfordby, John, of Billesby, son of Asfordby, William 0
5265767 2435045 2435045 defendant Foule Simon husbandman 626243 626243 Foule, Simon, of Billesby, husbandman 0
5362522 2463929 2463929 plaintiff Trussell Thomas   626243 626243 Trussell, Thomas, of Billesby 0
5419382 2480715 2480715 defendant Affordby John gent 626243 626243 Affordby, John, of Billesby, gent 0
5419383 2480715 2480715 defendant Pynder William husbandman 626243 626243 Pynder, William, of Billesby, husbandman 1
5419384 2480715 2480715 defendant Mawer Walter husbandman 626243 626243 Mawer, Walter, of Billesby, husbandman 2
5419385 2480715 2480715 defendant Poterell Thomas husbandman 626243 626243 Poterell, Thomas, of Billesby, husbandman 3
5419386 2480715 2480715 defendant Pynder Robert husbandman 626243 626243 Pynder, Robert, of Billesby, husbandman 4
5419387 2480715 2480715 defendant Westren Henry husbandman 626243 626243 Westren, Henry, of Billesby, husbandman 5
5419388 2480715 2480715 defendant Est Robert husbandman 626243 626243 Est, Robert, of Billesby, husbandman 6
5419389 2480715 2480715 defendant Fen Robert husbandman 626243 626243 Fen, Robert, of Billesby, husbandman 7
5489153 2501639 2501639 defendant Pynder William husbandman 626243 626243 Pynder, William, of Billesby, husbandman 0
5615214 2548553 2548553 defendant atte Waterland Adam chaplain 626243 626243 atte Waterland, Adam, of Billesby, chaplain 4

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