names

73 rows where place_id = 602195

✎ 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
3648903 1910045 1910045 defendant Bocher Richard chapman 602195 602195 Bocher, Richard, of Tewkesbury, Glos, chapman 0
3671322 1917005 1917005 defendant Breten William shoemaker 602195 602195 Breten, William, of Tewkesbury, Glos, shoemaker 0
3691764 1923584 1923584 defendant Perrys John chapman 602195 602195 Perrys, John, of Tewkesbury, Glos, chapman 0
3696582 1925164 1925164 defendant Pulton Richard waterman 602195 602195 Pulton, Richard, of Tewkesbury, Glos, waterman 0
3702920 1927182 1927182 defendant Byrche John trowman 602195 602195 Byrche, John, of Tewkesbury, Glos, trowman 11
3703684 1927433 1927433 defendant Fawkener Thomas yeoman 602195 602195 Fawkener, Thomas, of Tewkesbury, Glos, yeoman 1
3740424 1938865 1938865 defendant Cole Robert gent 602195 602195 Cole, Robert, of Tewkesbury, Glos, gent 0
3740446 1938870 1938870 defendant Cole Robert gent 602195 602195 Cole, Robert, of Tewkesbury, Glos, gent 0
3768102 1947659 1947659 defendant Wakman Richard yeoman 602195 602195 Wakman, Richard, of Tewkesbury, Glos, yeoman 0
3769765 1948197 1948197 defendant Cole Robert gent 602195 602195 Cole, Robert, of Tewkesbury, Glos, gent 0
3784783 1953032 1953032 defendant Cole Robert gent 602195 602195 Cole, Robert, of Tewkesbury, Glos, gent 1
3784786 1953033 1953033 defendant Cole Robert gent 602195 602195 Cole, Robert, of Tewkesbury, Glos, gent 0
3785867 1953370 1953370 defendant Wekman Richard yeoman 602195 602195 Wekman, Richard, of Tewkesbury, Glos, yeoman 0
3806433 1959924 1959924 defendant Bayly John yeoman 602195 602195 Bayly, John, of Tewkesbury, Glos, yeoman 0
3810969 1961330 1961330 defendant Dewe William yeoman 602195 602195 (Dewe, William, of Tewkesbury, Glos, yeoman 1
3825897 1965948 1965948 defendant Spycer Thomas yeoman 602195 602195 Spycer, Thomas, of Tewkesbury, Glos, yeoman 0
3826047 1965990 1965990 defendant Bawky alias Spycer Thomas yeoman 602195 602195 Bawky alias Spycer, Thomas, of Tewkesbury, Glos, yeoman 0
3829738 1967193 1967193 plaintiff Dewe William, senior   602195 602195 Dewe, William, senior, of Tewkesbury, Glos 0
3844798 1971918 1971918 plaintiff Dewye William, senior   602195 602195 Dewye, William, senior, of Tewkesbury, Glos 0
3844800 1971919 1971919 plaintiff Dewye William, senior   602195 602195 Dewye, William, senior, of Tewkesbury, Glos 0
3846034 1972319 1972319 defendant Cole Robert gent 602195 602195 Cole, Robert, of Tewkesbury, Glos, gent 1
3851414 1974042 1974042 defendant Bois Thomas chapman 602195 602195 Bois, Thomas, of Tewkesbury, Glos, chapman 0
3858200 1976220 1976220 defendant Passe Ralph mercer 602195 602195 Passe, Ralph, of Tewkesbury, Glos, mercer 1
3858203 1976221 1976221 defendant Passe Ralph mercer 602195 602195 Passe, Ralph, of Tewkesbury, Glos, mercer 1
3867019 1979209 1979209 defendant Becke Henry butcher 602195 602195 Becke, Henry, of Tewkesbury, Glos, butcher 0
3867131 1979248 1979248 defendant Cole Robert gent 602195 602195 Cole, Robert, of Tewkesbury, Glos, gent 0
3887604 1986103 1986103 plaintiff Coxe William yeoman 602195 602195 Coxe, William, of Tewkesbury, Glos, yeoman 0
3889244 1986639 1986639 defendant Draper John gent 602195 602195 Draper, John, of Tewkesbury, Glos, gent 2
3889250 1986640 1986640 defendant Draper John gent 602195 602195 Draper, John, of Tewkesbury, Glos, gent 2
3901264 1990647 1990647 defendant Beck Henry butcher 602195 602195 Beck, Henry, of Tewkesbury, Glos, butcher 0
3962690 2011535 2011535 defendant Frebank William chapman 602195 602195 Frebank, William, of Tewkesbury, Glos, chapman 0
3979274 2017335 2017335 defendant Lupton Thomas gent 602195 602195 Lupton, Thomas, of Tewkesbury, Glos, gent 0
4056705 2044785 2044785 defendant Hobbes Thomas yeoman 602195 602195 Hobbes, Thomas, of Tewkesbury, Glos, yeoman 2
4059220 2045695 2045695 defendant Coxe William mercer 602195 602195 Coxe, William, of Tewkesbury, Glos, mercer 2
4068444 2049010 2049010 defendant Coxe William mercer 602195 602195 Coxe, William, of Tewkesbury, Glos, mercer 2
4081553 2053710 2053710 defendant Cottrell Kenelm mercer 602195 602195 Cottrell, Kenelm, of Tewkesbury, Glos, mercer 1
4082625 2054096 2054096 defendant Millington John chapman 602195 602195 Millington, John, of Tewkesbury, Glos, chapman 0
4119392 2067229 2067229 defendant Arkyll Richard   602195 602195 Arkyll, Richard, of Tewkesbury, Glos, yeoman, or of London, ironmonger, residing in sanctuary of Westminster 0
4154636 2079718 2079718 defendant Butt John yeoman 602195 602195 Butt, John, of Tewkesbury, Glos, yeoman 0
4159701 2081461 2081461 defendant Dowle Henry tanner 602195 602195 Dowle, Henry, of Tewkesbury, Glos, tanner 1
4167239 2084045 2084045 defendant Arkill Richard   602195 602195 Arkill, Richard, of Tewkesbury, Glos, yeoman, or of London, ironmonger, residing in Westminster sanctuary 0
4207058 2098014 2098014 defendant Phelpes William merchant 602195 602195 Phelpes, William, of Tewkesbury, Glos, merchant 0
4207060 2098015 2098015 defendant Phelpes William merchant 602195 602195 Phelpes, William, of Tewkesbury, Glos, merchant 0
4253765 2114252 2114252 defendant Barston Edward gent 602195 602195 Barston, Edward, of Tewkesbury, Glos, gent 1
4253768 2114253 2114253 defendant Barston Edward gent 602195 602195 Barston, Edward, of Tewkesbury, Glos, ,gent 1
4332754 2141237 2141237 defendant Allen William chapman 602195 602195 Allen, William, of Tewkesbury, Glos, chapman 0
4350412 2147407 2147407 defendant Chaundler Kenelm victualer 602195 602195 Chaundler, Kenelm, of Tewkesbury, Glos, victualer 0
4361991 2151448 2151448 defendant Wiginge Thomas chapman 602195 602195 Wiginge, Thomas, of Tewkesbury, Glos, chapman 0
4377450 2157010 2157010 defendant Cocke Richard yeoman 602195 602195 Cocke, Richard, of Tewkesbury, Glos, yeoman 0
4390487 2161439 2161439 defendant Connard George gent 602195 602195 Connard, George, of Tewkesbury, Glos, or of Droitwich, Worcs, gent 0
4390489 2161440 2161440 defendant Connard John   602195 602195 Connard, John, of Tewkesbury, Glos, gent, son of George 0
4656914 2248057 2248057 defendant Stacy Robert dyer 602195 602195 Stacy, Robert, of Tewkesbury, Glos, dyer 0
4656921 2248058 2248058 defendant Stacy Robert dyer 602195 602195 Stacy, Robert, of Tewkesbury, Glos, dyer 0
4857145 2313618 2313618 plaintiff Bette John, senior chapman 602195 602195 Bette, John, senior, of Tewkesbury, Glos, chapman 0
4857147 2313619 2313619 plaintiff Bette John, senior chapman 602195 602195 Bette, John, senior, of Tewkesbury, Glos, chapman 0
5060937 2374842 2374842 defendant Atkyns John dyer 602195 602195 Atkyns, John, of Tewkesbury, Glos, dyer 4
5060941 2374843 2374843 defendant Atkyns John, junior dyer 602195 602195 Atkyns, John, junior, of Tewkesbury, Glos, dyer 2
5062706 2375403 2375403 defendant mainpernors Throgmerton John gent 602195 602195 with mainpernors Throgmerton, John, of Tewkesbury, Glos, gent 1
5094173 2384701 2384701 defendant Iprus Robert skinner 602195 602195 Iprus, Robert, of Tewkesbury, Glos, skinner 0
5117274 2391487 2391487 defendant Throkmerton John   602195 602195 Throkmerton, John, of Tewkesbury, Glos 1
5117288 2391490 2391490 defendant Thorkmerton John esq 602195 602195 Thorkmerton, John, of Tewkesbury, Glos, esq 0
5214358 2419933 2419933 defendant Tanner Lawrence yeoman 602195 602195 Tanner, Lawrence, of Tewkesbury, Glos, yeoman 4
5224068 2422722 2422722 defendant Throkmerton John (legal representative) 602195 602195 Throkmerton, John, of Tewkesbury, Glos, esq, executors of 0
5233986 2425529 2425529 defendant Burneham Lewis draper 602195 602195 Burneham, Lewis, of Tewkesbury, Glos, draper 3
5251047 2430434 2430434 plaintiff Wye John   602195 602195 Wye, John, of Tewkesbury, Glos 0
5267471 2435584 2435584 plaintiff Wye John   602195 602195 Wye, John, of Tewkesbury, Glos 0
5267473 2435585 2435585 plaintiff Wye John   602195 602195 Wye, John, of Tewkesbury, Glos 0
5336944 2456119 2456119 defendant Burgeys William chapman 602195 602195 Burgeys, William, of Tewkesbury, Glos, chapman 0
5491631 2502387 2502387 defendant London Henry gent 602195 602195 London, Henry, of Tewkesbury, Glos, gent 0
5506416 2506916 2506916 defendant London Henry esq 602195 602195 London, Henry, of Tewkesbury, Glos, esq 0
5528232 2513388 2513388 defendant Crane John chapman 602195 602195 Crane, John, of Tewkesbury, Glos, chapman 4
5540412 2517132 2517132 defendant Rogers John butcher 602195 602195 Rogers, John, of Tewkesbury, Glos, butcher 0
5543075 2517953 2517953 defendant Warton Philip gent 602195 602195 Warton, Philip, of Tewkesbury, Glos, gent 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);