names

34 rows where place_id = 607277

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3668471 1916091 1916091 defendant Swayne Thomas gent 607277 607277 Swayne, Thomas, of Marlebrough, gent 0
3984377 2019168 2019168 defendant Hall Robert yeoman 607277 607277 Hall, Robert, of Marlebrough, yeoman 0
4021916 2032564 2032564 plaintiff Allen John mercer 607277 607277 Allen, John, of Marlebrough, mercer 0
4027166 2034362 2034362 defendant Lawney Richard (legal representative) 607277 607277 Lawney, Richard, of Marlebrough, chandler, administrator of 0
4030337 2035504 2035504 plaintiff Dyston Anthony chandler 607277 607277 Dyston, Anthony, of Marlebrough, chandler 0
4047490 2041555 2041555 plaintiff Stevens alias Hawkes Anthony shoemaker 607277 607277 Stevens alias Hawkes, Anthony, of Marlebrough, shoemaker 0
4047492 2041556 2041556 plaintiff Stevens alias Hawkes Anthony shoemaker 607277 607277 Stevens alias Hawkes, Anthony, of Marlebrough, shoemaker 0
4112910 2064883 2064883 defendant Tuggey William innholder 607277 607277 Tuggey, William, of Marlebrough, innholder 0
4177425 2087578 2087578 defendant Thomas Morgan gent 607277 607277 Thomas, Morgan, of Marlebrough, or of Skeynsfreth, Monmouth, gent 0
4182660 2089416 2089416 defendant Cordrey Richard gent 607277 607277 Cordrey, Richard, of Marlebrough, or of Worlle, Soms, gent 0
4186674 2090826 2090826 defendant Colman Richard shoemaker 607277 607277 Colman, Richard, of Marlebrough, shoemaker 0
4236643 2108390 2108390 defendant Cooke Robert gent 607277 607277 Cooke, Robert, of Marlebrough, or of Kempton, Hants, gent 0
4236644 2108390 2108390 defendant Prater Edward yeoman 607277 607277 Prater, Edward, of Marlebrough, or of Kimbridge, Hants, yeoman 1
4239783 2109546 2109546 defendant Jefferey Richard clerk 607277 607277 Jefferey, Richard, of Marlebrough, or of Salisbury College, clerk 0
4239785 2109547 2109547 defendant Payne Richard husbandman 607277 607277 Payne, Richard, of Marlebrough, or of Lamborne Woodland, Lamborne, Berks, husbandman 0
4239787 2109547 2109547 defendant Geale John husbandman 607277 607277 Geale, John, of Marlebrough, or of Sutton Benger, husbandman 2
4239788 2109547 2109547 defendant Coller Thomas husbandman 607277 607277 Coller, Thomas, of Marlebrough, husbandman 3
4274129 2120893 2120893 defendant Evans Mathew currier 607277 607277 Evans, Mathew, of Marlebrough, currier 0
4274130 2120893 2120893 defendant Mason Edmund   607277 607277 Mason, Edmund, of Marlebrough, or of Echenswell, Hants, felt maker 1
4274131 2120893 2120893 defendant Dawson Hugh haberdasher 607277 607277 Dawson, Hugh, of Marlebrough, or of Winchester, haberdasher 2
4309440 2133464 2133464 defendant Heynod Thomas mariner 607277 607277 Heynod, Thomas, of Marlebrough, or of Portsmouth, Hants, mariner 0
4314372 2135138 2135138 defendant Francklyn Richard sawyer 607277 607277 Francklyn, Richard, of Marlebrough, sawyer 0
4315718 2135607 2135607 defendant Bonde William yeoman 607277 607277 Bonde, William, of Marlebrough, or of Cleevancey, yeoman 0
4315719 2135607 2135607 defendant Hyxe John yeoman 607277 607277 Hyxe, John, of Marlebrough, yeoman 1
4315746 2135617 2135617 defendant Gate William yeoman 607277 607277 Gate, William, of Marlebrough, or of Lyncumme, Wytwin, yeoman 2
4315748 2135618 2135618 defendant Coke Thomas clerk 607277 607277 Coke, Thomas, of Marlebrough, or of Fitchington , Soms, clerk 0
4315750 2135619 2135619 defendant Deane William yeoman 607277 607277 Deane, William, of Marlebrough, yeoman 0
4316035 2135721 2135721 defendant Deverell Henry yeoman 607277 607277 Deverell, Henry, of Marlebrough, or of Bunger , Melsham, yeoman 0
4316036 2135721 2135721 defendant Curtys John yeoman 607277 607277 Curtys, John, of Marlebrough, or of Bunger, Mylsham, yeoman 1
4318776 2136680 2136680 defendant Spicer Edward yeoman 607277 607277 Spicer, Edward, of Marlebrough, or of Ufcott, Brodhynton, yeoman 0
4318777 2136680 2136680 defendant Spenser William yeoman 607277 607277 Spenser, William, of Marlebrough, or of Lurgishall, yeoman 1
4319291 2136856 2136856 defendant Baldyn or Bawldwyn Giles tailor 607277 607277 Baldyn or Bawldwyn, Giles, of Marlebrough, or of Chryston, Hants, tailor 0
4319855 2137051 2137051 defendant Seward John yeoman 607277 607277 Seward, John, of Marlebrough, or of North Tudworth, yeoman 0
4376736 2156747 2156747 defendant Marshall Thomas gent 607277 607277 Marshall, Thomas, of Marlebrough, or of Marsedowne, Rantecome, 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);