names

76 rows where place_id = 600461

✎ 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
3641128 1907673 1907673 defendant Brusy Hugh clerk 600461 600461 Brusy, Hugh, of Ilsyngton, clerk 0
3669135 1916284 1916284 defendant Wherell William yeoman 600461 600461 Wherell, William, of Ilsyngton, yeoman 0
3904718 1991836 1991836 defendant More Thomas husbandman 600461 600461 More, Thomas, of Ilsyngton, husbandman 0
3921625 1997578 1997578 defendant Pomerey Hugh gent 600461 600461 Pomerey, Hugh, of Ilsyngton, gent 0
3921626 1997578 1997578 defendant Skeynys John husbandman 600461 600461 Skeynys, John, of Ilsyngton, husbandman 1
3949574 2006926 2006926 defendant Forde George esq 600461 600461 Forde, George, of Ilsyngton, esq 0
3982842 2018636 2018636 defendant Meysey Roger husbandman 600461 600461 Meysey, Roger, of Ilsyngton, husbandman 2
4035881 2037505 2037505 plaintiff Hore John   600461 600461 Hore, John, of Ilsyngton, groom 0
4038233 2038310 2038310 plaintiff Lamshed John carpenter 600461 600461 Lamshed, John, of Ilsyngton, carpenter 0
4041206 2039344 2039344 plaintiff Myller Leonard husbandman 600461 600461 Myller, Leonard, of Ilsyngton, husbandman 0
4041649 2039507 2039507 plaintiff Northaway Alexander (legal representative) 600461 600461 Northaway, Alexander, of Ilsyngton, husbandman, executrix of 0
4263140 2117339 2117339 defendant Pomery Hugh esq 600461 600461 Pomery, Hugh, of Ilsyngton, or of Engesdon, Devon, esq 0
4263146 2117340 2117340 defendant Pomerye Thomas gent 600461 600461 Pomerye, Thomas, of Ilsyngton, gent 2
4453692 2186168 2186168 defendant Blower Henry   600461 600461 Blower, Henry, of Ilsyngton 0
4584185 2226468 2226468 defendant Palemre John   600461 600461 Palemre, John, of Ilsyngton 4
4591280 2228631 2228631 defendant Kervyle Robert   600461 600461 Kervyle, Robert, of Ilsyngton, son of Edmund 0
4614742 2235623 2235623 defendant Taillour John   600461 600461 Taillour, John, of Ilsyngton, vicar & clerk 0
4648826 2245716 2245716 defendant Polot John   600461 600461 Polot, John, of Ilsyngton 0
4660338 2249063 2249063 defendant Byllyet John husbandman 600461 600461 Byllyet, John, of Ilsyngton, husbandman 1
4666821 2255349 2255349 defendant Memple Thomas husbandman 600461 600461 Memple, Thomas, of Ilsyngton, husbandman 2
4671799 2256826 2256826 defendant Willesson John husbandman 600461 600461 Willesson, John, of Ilsyngton, husbandman 1
4677028 2258432 2258432 defendant Heward Thomas husbandman 600461 600461 Heward, Thomas, of Ilsyngton, husbandman 3
4677036 2258433 2258433 defendant Howard Thomas husbandman 600461 600461 Howard, Thomas, of Ilsyngton, husbandman 3
4705051 2266951 2266951 defendant Bernewell John dyer 600461 600461 Bernewell, John, of Ilsyngton, dyer 0
4705054 2266952 2266952 defendant Bernewell John dyer 600461 600461 Bernewell, John, of Ilsyngton, dyer 0
4705064 2266955 2266955 defendant Bernewell John dyer 600461 600461 Bernewell, John, of Ilsyngton, dyer 1
4708396 2267992 2267992 defendant Taillour John, senior husbandman 600461 600461 Taillour, John, senior, of Ilsyngton, husbandman 2
4728733 2274225 2274225 plaintiff Kervyle John   600461 600461 Kervyle, John, of Ilsyngton, son of William 0
4728734 2274225 2274225 defendant Milk William husbandman 600461 600461 Milk, William, of Ilsyngton, husbandman 0
4728738 2274226 2274226 defendant Taillour William husbandman 600461 600461 Taillour, William, of Ilsyngton, husbandman 2
4728739 2274226 2274226 defendant Menpas Thomas husbandman 600461 600461 Menpas, Thomas, of Ilsyngton, husbandman 3
4736095 2276428 2276428 defendant Milk William yeoman 600461 600461 Milk, William, of Ilsyngton, yeoman 2
4752236 2281125 2281125 defendant Milk William yeoman 600461 600461 Milk, William, of Ilsyngton, yeoman 1
4752245 2281126 2281126 defendant Kervyle John yeoman & son of William 600461 600461 Kervyle, John, of Ilsyngton, yeoman & son of William 3
4767801 2285902 2285902 defendant Milk William yeoman 600461 600461 Milk, William, of Ilsyngton, yeoman 0
4770841 2286860 2286860 defendant Abbot John husbandman 600461 600461 Abbot, John, of Ilsyngton, husbandman 0
4770842 2286860 2286860 defendant Flory John husbandman 600461 600461 Flory, John, of Ilsyngton, husbandman 1
4770843 2286860 2286860 defendant Walden William laborer 600461 600461 Walden, William, of Ilsyngton, laborer 2
4770846 2286861 2286861 defendant Abbot John husbandman 600461 600461 Abbot, John, of Ilsyngton, husbandman 0
4770847 2286861 2286861 defendant Walden William laborer 600461 600461 Walden, William, of Ilsyngton, laborer 1
4814908 2300771 2300771 defendant Mylke John husbandman 600461 600461 Mylke, John, of Ilsyngton, husbandman 0
4849896 2311439 2311439 defendant Bernewell John yeoman 600461 600461 Bernewell, John, of Ilsyngton, yeoman 1
4852014 2312062 2312062 defendant Bernewell John husbandman 600461 600461 Bernewell, John, of Ilsyngton, husbandman 1
4852015 2312062 2312062 defendant Belyet Edmund yeoman 600461 600461 Belyet, Edmund, of Ilsyngton, yeoman 2
4875621 2319333 2319333 defendant Symonde Thomas yeoman 600461 600461 Symonde, Thomas, of Ilsyngton, yeoman 0
4876319 2319556 2319556 defendant Bernewell John husbandman 600461 600461 Bernewell, John, of Ilsyngton, husbandman 0
4900132 2326668 2326668 defendant Kervyle Edmund gent 600461 600461 Kervyle, Edmund, of Ilsyngton, gent 1
4904073 2327889 2327889 defendant Baggetorre Thomas laborer 600461 600461 Baggetorre, Thomas, of Ilsyngton, laborer 0
4904074 2327889 2327889 defendant Bode Geoffrey laborer 600461 600461 Bode, Geoffrey, of Ilsyngton, laborer 1
4943161 2339832 2339832 defendant Kervyll Thomas esq 600461 600461 Kervyll, Thomas, of Ilsyngton, esq 2
4963370 2345951 2345951 defendant Bernewell John husbandman 600461 600461 Bernewell, John, of Ilsyngton, husbandman 1
4972354 2348667 2348667 defendant Belyet Edmund husbandman 600461 600461 Belyet, Edmund, of Ilsyngton, husbandman 2
4972357 2348668 2348668 plaintiff Kervyle Edward (legal representative) 600461 600461 Kervyle, Edward, of Ilsyngton, executors of 0
4978093 2350412 2350412 defendant Nyghtyngale John husbandman 600461 600461 Nyghtyngale, John, of Ilsyngton, husbandman 0
4978094 2350412 2350412 defendant Spyrard John husbandman 600461 600461 Spyrard, John, of Ilsyngton, husbandman 1
5018641 2362338 2362338 defendant Dounyng Robert husbandman 600461 600461 Dounyng, Robert, of Ilsyngton, husbandman 0
5033049 2366548 2366548 defendant Underhay John husbandman 600461 600461 Underhay, John, of Ilsyngton, husbandman 1
5055641 2373260 2373260 defendant Dygon John husbandman 600461 600461 Dygon, John, of Ilsyngton, husbandman 0
5097418 2385675 2385675 defendant Myller or Melyer William mercer 600461 600461 Myller or Melyer, William, of Ilsyngton, or of Hyngstrygge, Soms, mercer 0
5099194 2386190 2386190 defendant Smyth William husbandman 600461 600461 Smyth, William, of Ilsyngton, husbandman 0
5207764 2418010 2418010 defendant Belyott Edmund husbandman 600461 600461 Belyott, Edmund, of Ilsyngton, husbandman 0
5250442 2430247 2430247 defendant Abbot John husbandman 600461 600461 Abbot, John, of Ilsyngton, husbandman 1
5340344 2457184 2457184 defendant Sutton Edmund husbandman 600461 600461 Sutton, Edmund, of Ilsyngton, husbandman 1
5389717 2472123 2472123 plaintiff Lake John   600461 600461 Lake, John, of Ilsyngton 0
5402537 2475795 2475795 plaintiff Lake John   600461 600461 Lake, John, of Ilsyngton 0
5497092 2504068 2504068 defendant Mylke Thomas husbandman 600461 600461 Mylke, Thomas, of Ilsyngton, husbandman 1
5497096 2504069 2504069 defendant Mylke Thomas husbandman 600461 600461 Mylke, Thomas, of Ilsyngton, husbandman 1
5511972 2508601 2508601 defendant Milke Thomas husbandman 600461 600461 Milke, Thomas, of Ilsyngton, husbandman 1
5523825 2512272 2512272 defendant Bagtorre John, senior husbandman 600461 600461 Bagtorre, John, senior, of Ilsyngton, husbandman 0
5579003 2528503 2528503 defendant Spaldyng Robert husbandman 600461 600461 Spaldyng, Robert, of Ilsyngton, husbandman 0
5590451 2531981 2531981 defendant Pomerey Robert gent 600461 600461 Pomerey, Robert, of Ilsyngton, gent 0
5594376 2533215 2533215 defendant Spaldyng Robert husbandman 600461 600461 Spaldyng, Robert, of Ilsyngton, husbandman 0
5598798 2534500 2534500 defendant Tayllour Alexander husbandman 600461 600461 Tayllour, Alexander, of Ilsyngton, husbandman 0
5602889 2535790 2535790 defendant Spaldyng Robert yeoman 600461 600461 Spaldyng, Robert, of Ilsyngton, yeoman 0
5602899 2535794 2535794 defendant Abbot John (legal representative) 600461 600461 Abbot, John, of Ilsyngton, husbandman, executors of 0
5604958 2536419 2536419 defendant Spaldyng Robert husbandman 600461 600461 Spaldyng, Robert, of Ilsyngton, 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);