names

53 rows where place_id = 594853

✎ 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
3617849 1873206 1873206 defendant Bere William clothman 594853 594853 Bere, William, of Dursley, Glos, clothman 3
3703405 1927342 1927342 plaintiff Davys John, junior clothman 594853 594853 Davys, John, junior, of Dursley, Glos, clothman 0
3731340 1936024 1936024 defendant Stynchecombe Robert   594853 594853 Stynchecombe, Robert, of Dursley, Glos, champlain 0
3760950 1945431 1945431 defendant Heskyns John clothier 594853 594853 Heskyns, John, of Dursley, Glos, clothier 1
3806973 1960083 1960083 defendant Samford William clothier 594853 594853 Samford, William, of Dursley, Glos, clothier 2
3833572 1968434 1968434 defendant Palmer Henry clothier 594853 594853 Palmer, Henry, of Dursley, Glos, clothier 0
3912834 1994623 1994623 defendant Hoskyns John clothier 594853 594853 Hoskyns, John, of Dursley, Glos, clothier 0
3961563 2011142 2011142 defendant Plante Richard clothoer 594853 594853 Plante, Richard, of Dursley, Glos, clothoer 4
3961568 2011143 2011143 defendant Hyck Thomas weaver 594853 594853 Hyck, Thomas, of Dursley, Glos, weaver 3
3985290 2019497 2019497 defendant Allen Henry tucker 594853 594853 Allen, Henry, of Dursley, Glos, tucker 2
3985292 2019498 2019498 defendant Tayler John dyer 594853 594853 Tayler, John, of Dursley, Glos, dyer 0
4051648 2043011 2043011 plaintiff Wolworthe alias Webbe Edmund clothier 594853 594853 Wolworthe alias Webbe, Edmund, of Dursley, Glos, clothier 0
4065874 2048089 2048089 defendant Webbe William clothier 594853 594853 Webbe, William, of Dursley, Glos, clothier 3
4087701 2055894 2055894 defendant Smalewood John clothier 594853 594853 Smalewood, John, of Dursley, Glos, clothier 0
4113383 2065056 2065056 defendant Thackam Richard yeoman 594853 594853 Thackam, Richard, of Dursley, Glos, yeoman 0
4140373 2074801 2074801 defendant Woolworth alias Webbe William clothier 594853 594853 Woolworth alias Webbe, William, of Dursley, Glos, clothier 0
4163299 2082690 2082690 defendant Woodd Thomas clothier 594853 594853 Woodd, Thomas, of Dursley, Glos, clothier 3
4345705 2145766 2145766 defendant Davys William chapman 594853 594853 Davys, William, of Dursley, Glos, chapman 0
4781400 2290191 2290191 defendant Clerk Walter   594853 594853 Clerk, Walter, of Dursley, Glos, bailiff 0
5035464 2367232 2367232 defendant Wykes Thomas esq 594853 594853 Wykes, Thomas, of Dursley, Glos, esq 0
5035470 2367233 2367233 defendant Wykes Thomas esq 594853 594853 Wykes, Thomas, of Dursley, Glos, esq 0
5061400 2374996 2374996 defendant Wylmot John baker 594853 594853 Wylmot, John, of Dursley, Glos, baker 0
5079016 2380208 2380208 defendant James John tucker 594853 594853 James, John, of Dursley, Glos, tucker 0
5083881 2381680 2381680 defendant James John tucker 594853 594853 James, John, of Dursley, Glos, tucker 0
5087943 2382853 2382853 defendant James John tucker 594853 594853 James, John, of Dursley, Glos, tucker 0
5111838 2389852 2389852 defendant Tanner Robert gent 594853 594853 Tanner, Robert, of Dursley, Glos, gent 3
5112741 2390117 2390117 defendant Jamys John draper 594853 594853 Jamys, John, of Dursley, Glos, draper 0
5112746 2390118 2390118 defendant Jamys John draper 594853 594853 Jamys, John, of Dursley, Glos, draper 0
5215342 2420216 2420216 defendant Badham John clothman 594853 594853 Badham, John, of Dursley, Glos, clothman 3
5218895 2421251 2421251 defendant Wylmote Joan widow 594853 594853 Wylmote, Joan, of Dursley, Glos, widow 1
5218899 2421252 2421252 defendant Wilmote Joan widow 594853 594853 Wilmote, Joan, of Dursley, Glos, widow 1
5242997 2428154 2428154 defendant Tanner Robert gent 594853 594853 Tanner, Robert, of Dursley, Glos, gent 1
5243000 2428155 2428155 defendant Tanner Robert gent 594853 594853 Tanner, Robert, of Dursley, Glos, gent 1
5243003 2428156 2428156 defendant Tanner Robert gent 594853 594853 Tanner, Robert, of Dursley, Glos, gent 1
5261383 2433668 2433668 defendant Tanner Robert yeoman 594853 594853 Tanner, Robert, of Dursley, Glos, yeoman 7
5277449 2438483 2438483 defendant Renold John husbandman 594853 594853 Renold, John, of Dursley, Glos, husbandman 2
5283629 2440260 2440260 defendant Davyes Swilliam merchant 594853 594853 Davyes, Swilliam, of Dursley, Glos, merchant 0
5350020 2460132 2460132 defendant Bowyer William yeoman 594853 594853 Bowyer, William, of Dursley, Glos, yeoman 1
5352758 2460950 2460950 defendant Wykes John esq 594853 594853 Wykes, John, of Dursley, Glos, esq 0
5352760 2460951 2460951 defendant Wykes John esq 594853 594853 Wykes, John, of Dursley, Glos, esq 0
5352764 2460952 2460952 defendant Wykes John esq 594853 594853 Wykes, John, of Dursley, Glos, esq 1
5352768 2460953 2460953 defendant Wykes John esq 594853 594853 Wykes, John, of Dursley, Glos, esq 1
5498449 2504491 2504491 defendant Phelpus William clothmaker 594853 594853 Phelpus, William, of Dursley, Glos, clothmaker 1
5498455 2504492 2504492 defendant Plymmyswode John clothmaker 594853 594853 Plymmyswode, John, of Dursley, Glos, clothmaker 0
5498466 2504493 2504493 defendant Bery William dyer 594853 594853 Bery, William, of Dursley, Glos, dyer 4
5542566 2517801 2517801 defendant Wy- Edmund gent 594853 594853 Wy-, Edmund, of Dursley, Glos, gent 0
5553169 2520967 2520967 defendant Sprotte John weaver 594853 594853 Sprotte, John, of Dursley, Glos, weaver 1
5584503 2530219 2530219 defendant Fynnymour Thomas clothman 594853 594853 Fynnymour, Thomas, of Dursley, Glos, clothman 0
5584505 2530220 2530220 defendant Fynnymour Thomas clothman 594853 594853 Fynnymour, Thomas, of Dursley, Glos, clothman 0
5588218 2531318 2531318 defendant Fenymore Thomas clothman 594853 594853 Fenymore, Thomas, of Dursley, Glos, clothman 3
5593180 2532851 2532851 defendant Fynnymore Thomas clothman 594853 594853 Fynnymore, Thomas, of Dursley, Glos, clothman 0
5593212 2532858 2532858 defendant Fennymore Thomas clothman 594853 594853 Fennymore, Thomas, of Dursley, Glos, clothman 0
5606894 2537044 2537044 defendant Wykys Edmund esq 594853 594853 Wykys, Edmund, of Dursley, Glos, esq 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);