names

70 rows where place_id = 624814

✎ 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
3760456 1945274 1945274 defendant Brady William merchant 624814 624814 Brady, William, of Berwyk, merchant 1
3803784 1959096 1959096 defendant Cane or Cave Thomas   624814 624814 Cane or Cave, Thomas, of Berwyk 0
3902862 1991190 1991190 defendant Thornton John yeoman 624814 624814 Thornton, John, of Berwyk, yeoman 1
4464047 2189426 2189426 plaintiff Wale John   624814 624814 Wale, John, of Berwyk, parson, on his own account 0
4467041 2190362 2190362 defendant Mayr John   624814 624814 Mayr, John, of Berwyk 1
4467044 2190362 2190362 defendant Chapman Adam   624814 624814 Chapman, Adam, of Berwyk 4
4467047 2190363 2190363 defendant Mayr John   624814 624814 Mayr, John, of Berwyk 1
4467050 2190363 2190363 defendant Chapman Adam   624814 624814 Chapman, Adam, of Berwyk 4
4476407 2193286 2193286 plaintiff Poleyn Robert   624814 624814 (Poleyn, Robert, of Berwyk, parson 1
4480416 2194544 2194544 defendant Pert John, senior   624814 624814 Pert, John, senior, of Berwyk 0
4482184 2195138 2195138 defendant Saundres Roger   624814 624814 Saundres, Roger, of Berwyk 0
4541374 2213198 2213198 defendant Nywe William   624814 624814 Nywe, William, of Berwyk 2
4541459 2213224 2213224 defendant Fyssh Henry   624814 624814 Fyssh, Henry, of Berwyk 7
4544203 2214103 2214103 defendant Chapman William   624814 624814 Chapman, William, of Berwyk 0
4554173 2217230 2217230 defendant Carvyle Robert   624814 624814 Carvyle, Robert, of Berwyk 0
4554174 2217230 2217230 defendant Carvyle Stephen   624814 624814 Carvyle, Stephen, of Berwyk 1
4579060 2224930 2224930 defendant Fulbes John   624814 624814 Fulbes, John, of Berwyk 0
4579062 2224931 2224931 defendant Saundre Roger   624814 624814 Saundre, Roger, of Berwyk 0
4582166 2225860 2225860 defendant Trug Robert   624814 624814 Trug, Robert, of Berwyk 0
4723322 2272604 2272604 defendant Profott Robert husbandman 624814 624814 Profott, Robert, of Berwyk, husbandman 0
4737675 2276890 2276890 defendant Felipp Robert husbandman 624814 624814 Felipp, Robert, of Berwyk, husbandman 1
4737676 2276890 2276890 defendant Saunder Roger husbandman 624814 624814 Saunder, Roger, of Berwyk, husbandman 2
4762273 2284182 2284182 defendant Wilston Richard husbandman 624814 624814 Wilston, Richard, of Berwyk, husbandman 0
4762374 2284214 2284214 defendant Bernard John husbandman 624814 624814 Bernard, John, of Berwyk, husbandman 0
4803348 2297239 2297239 defendant Rose John husbandman 624814 624814 Rose, John, of Berwyk, husbandman 1
4804667 2297655 2297655 defendant More Robert   624814 624814 More, Robert, of Berwyk, parson 1
4832611 2306223 2306223 defendant Spycer Thomas yeoman 624814 624814 Spycer, Thomas, of Berwyk, yeoman 2
4837790 2307753 2307753 defendant Nelot Thomas husbandman 624814 624814 Nelot, Thomas, of Berwyk, husbandman 0
4844778 2309888 2309888 plaintiff Norham John merchant 624814 624814 Norham, John, of Berwyk, merchant 0
4844781 2309889 2309889 plaintiff Norham John merchant 624814 624814 Norham, John, of Berwyk, merchant 0
4847851 2310815 2310815 defendant Short Richard laborer 624814 624814 Short, Richard, of Berwyk, laborer 1
4847852 2310815 2310815 defendant Susauns John laborer 624814 624814 Susauns, John, of Berwyk, laborer 2
4854270 2312746 2312746 defendant Webster William, sen husbandman 624814 624814 Webster, William, sen, of Berwyk, husbandman 0
4855003 2312917 2312917 defendant Bernard John yeoman 624814 624814 Bernard, John, of Berwyk, yeoman 4
4869358 2317385 2317385 defendant Gade Thomas laborer 624814 624814 Gade, Thomas, of Berwyk, laborer 0
4874139 2318853 2318853 defendant Milton Richard husbandman 624814 624814 Milton, Richard, of Berwyk, husbandman 0
4883077 2321631 2321631 defendant Herpyn John husbandman 624814 624814 Herpyn, John, of Berwyk, husbandman 0
4883078 2321631 2321631 defendant Byrche William husbandman 624814 624814 Byrche, William, of Berwyk, husbandman 1
4883079 2321631 2321631 defendant Marsshall Richard husbandman 624814 624814 Marsshall, Richard, of Berwyk, husbandman 2
4883080 2321631 2321631 defendant Symson Thomas husbandman 624814 624814 Symson, Thomas, of Berwyk, husbandman 3
4883081 2321631 2321631 defendant Stereland Richard husbandman 624814 624814 Stereland, Richard, of Berwyk, husbandman 4
4940270 2338982 2338982 defendant Gryndon Thomas merchant 624814 624814 Gryndon, Thomas, of Berwyk, merchant 3
4999013 2356586 2356586 defendant Smyth John husbandman 624814 624814 Smyth, John, of Berwyk, husbandman 1
5035374 2367204 2367204 defendant Hervy William husbandman 624814 624814 Hervy, William, of Berwyk, husbandman 2
5057954 2373953 2373953 defendant Jaklyn John husbandman 624814 624814 Jaklyn, John, of Berwyk, husbandman 2
5109039 2389062 2389062 defendant Tylney Edmund clerk 624814 624814 Tylney, Edmund, of Berwyk, clerk 0
5110878 2389578 2389578 defendant Pegge John husbandman 624814 624814 Pegge, John, of Berwyk, husbandman 0
5113620 2390375 2390375 defendant Porter Edward laborer 624814 624814 Porter, Edward, of Berwyk, laborer 0
5134433 2396565 2396565 defendant Wero Robert   624814 624814 Wero, Robert, of Berwyk 3
5154308 2402418 2402418 defendant Wro Robert smith 624814 624814 Wro, Robert, of Berwyk, smith 3
5154309 2402418 2402418 defendant Byrch William butcher 624814 624814 Byrch, William, of Berwyk, butcher 4
5171419 2407366 2407366 defendant Wro Robert smith 624814 624814 Wro, Robert, of Berwyk, smith 3
5171420 2407366 2407366 defendant Byrch William butcher 624814 624814 Byrch, William, of Berwyk, butcher 4
5174233 2408164 2408164 defendant Barnysdale Robert husbandman 624814 624814 Barnysdale, Robert, of Berwyk, husbandman 0
5189834 2412772 2412772 defendant Wrom_ Robert smith 624814 624814 Wrom_, Robert, of Berwyk, smith 2
5189835 2412772 2412772 defendant Birch William butcher 624814 624814 Birch, William, of Berwyk, butcher 3
5321752 2451579 2451579 defendant Betton William gent 624814 624814 Betton, William, of Berwyk, gent 1
5352557 2460895 2460895 defendant Lewelyn James clerk 624814 624814 Lewelyn, James, of Berwyk, clerk 0
5362564 2463939 2463939 defendant Saunder John husbandman 624814 624814 Saunder, John, of Berwyk, husbandman 1
5418451 2480444 2480444 defendant Betton William yeoman 624814 624814 Betton, William, of Berwyk, yeoman 2
5436383 2485816 2485816 defendant Betton William yeoman 624814 624814 Betton, William, of Berwyk, yeoman 2
5436389 2485817 2485817 defendant Betton William yeoman 624814 624814 Betton, William, of Berwyk, yeoman 2
5483646 2500059 2500059 defendant Craneford David husbandman 624814 624814 Craneford, David, of Berwyk, husbandman 0
5510632 2508164 2508164 defendant A Wyke John husbandman 624814 624814 A Wyke, John, of Berwyk, husbandman 0
5558499 2522433 2522433 defendant Gaylard Nicholas butcher 624814 624814 Gaylard, Nicholas, of Berwyk, butcher 2
5577346 2527973 2527973 plaintiff Wensley John   624814 624814 Wensley, John, of Berwyk 0
5577625 2528068 2528068 defendant Metford Bartram gent 624814 624814 Metford, Bartram, of Berwyk, gent 1
5577639 2528073 2528073 defendant Metford Bartram gent 624814 624814 Metford, Bartram, of Berwyk, gent 1
5584354 2530169 2530169 defendant Couper Robert husbandman 624814 624814 Couper, Robert, of Berwyk, husbandman 2
5628786 2552969 2552969 defendant Arnold William husbandman 624814 624814 Arnold, William, of Berwyk, husbandman 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);