names

60 rows where place_id = 593815

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3613430 1871847 1871847 defendant Taillour William tailor 593815 593815 Taillour, William, of Bradwey, tailor 0
3613432 1871848 1871848 defendant Taillour William tailor 593815 593815 Taillour, William, of Bradwey, tailor 0
3613434 1871849 1871849 defendant Tayllour William tailor 593815 593815 Tayllour, William, of Bradwey, tailor 0
3625609 1875542 1875542 defendant Philippis geoffrey husbandman 593815 593815 Philippis, geoffrey, of Bradwey, husbandman 1
3696583 1925164 1925164 defendant Bayly Thomas draper 593815 593815 Bayly, Thomas, of Bradwey, draper 1
3709756 1929365 1929365 defendant Wodelowe alias Sclatter Thomas husbandman 593815 593815 Wodelowe alias Sclatter, Thomas, of Bradwey, husbandman 0
3709757 1929365 1929365 defendant Philippys John husbandman 593815 593815 Philippys, John, of Bradwey, husbandman 1
3709758 1929365 1929365 defendant Lovet Roger weaver 593815 593815 Lovet, Roger, of Bradwey, weaver 2
3724968 1934097 1934097 defendant Gune Robert husbandman 593815 593815 Gune, Robert, of Bradwey, husbandman 0
3762400 1945881 1945881 defendant Best Thomas husbandman 593815 593815 Best, Thomas, of Bradwey, husbandman 1
3771240 1948692 1948692 defendant Hogges William yeoman 593815 593815 Hogges, William, of Bradwey, yeoman 2
3809892 1960978 1960978 defendant Syche Richard husbandman 593815 593815 Syche, Richard, of Bradwey, husbandman 1
3842367 1971146 1971146 defendant Long Thomas dyer 593815 593815 Long, Thomas, of Bradwey, dyer 1
3908955 1993288 1993288 defendant Sharpeney Henry yeoman 593815 593815 Sharpeney, Henry, of Bradwey, yeoman 2
3908959 1993289 1993289 defendant Sharpeney Henry yeoman 593815 593815 Sharpeney, Henry, of Bradwey, yeoman 2
3909239 1993385 1993385 defendant Whyte Thomas yeoman 593815 593815 Whyte, Thomas, of Bradwey, yeoman 0
3942657 2004552 2004552 defendant Dawes John husbandman 593815 593815 Dawes, John, of Bradwey, husbandman 1
3985230 2019474 2019474 defendant Ockley Thomas yeoman 593815 593815 Ockley, Thomas, of Bradwey, yeoman 1
3985232 2019475 2019475 defendant Ocley Thomas yeoman 593815 593815 Ocley, Thomas, of Bradwey, yeoman 0
4077014 2052062 2052062 defendant Blaby John gent 593815 593815 Blaby, John, of Bradwey, gent 0
4387568 2160481 2160481 defendant Stevenson John husbandman 593815 593815 Stevenson, John, of Bradwey, or of Brampton, husbandman 1
4697352 2264656 2264656 defendant Litiljon John dyer 593815 593815 Litiljon, John, of Bradwey, dyer 0
4705535 2267096 2267096 defendant Theccher John husbandman 593815 593815 Theccher, John, of Bradwey, husbandman 0
4774427 2287984 2287984 defendant Schepard John husbandman 593815 593815 Schepard, John, of Bradwey, Worcester, husbandman 0
4774940 2288158 2288158 defendant Shepherd John husbandman 593815 593815 Shepherd, John, of Bradwey, husbandman 0
4809480 2299138 2299138 defendant Skanyngton Nicholas laborer 593815 593815 Skanyngton, Nicholas, of Bradwey, laborer 1
4820935 2302634 2302634 defendant Waker Richard tanner 593815 593815 Waker, Richard, of Bradwey, tanner 3
5010347 2359895 2359895 defendant Hewes William weaver 593815 593815 Hewes, William, of Bradwey, weaver 0
5140183 2398228 2398228 defendant Reynell Hugh tanner 593815 593815 Reynell, Hugh, of Bradwey, tanner 0
5354165 2461367 2461367 defendant George Thomas husbandman 593815 593815 George, Thomas, of Bradwey, husbandman 0
5354166 2461367 2461367 defendant george Agnes widow 593815 593815 george, Agnes, of Bradwey, widow 1
5363484 2464229 2464229 defendant George Thomas husbandman 593815 593815 George, Thomas, of Bradwey, husbandman 0
5531118 2514251 2514251 defendant More William husbandman 593815 593815 More, William, of Bradwey, husbandman 0
5531119 2514251 2514251 defendant Sondyford John husbandman 593815 593815 Sondyford, John, of Bradwey, husbandman 1
5531120 2514251 2514251 defendant Harreson George husbandman 593815 593815 Harreson, George, of Bradwey, husbandman 2
5531121 2514251 2514251 defendant More Henry laborer 593815 593815 More, Henry, of Bradwey, laborer 3
5531122 2514251 2514251 defendant Heynes William laborer 593815 593815 Heynes, William, of Bradwey, laborer 4
5531123 2514251 2514251 defendant Firkyns Robert laborer 593815 593815 Firkyns, Robert, of Bradwey, laborer 5
5531124 2514251 2514251 defendant Sambage John yeoman 593815 593815 Sambage, John, of Bradwey, yeoman 6
5531126 2514252 2514252 defendant Sambage John yeoman 593815 593815 Sambage, John, of Bradwey, yeoman 0
5531127 2514252 2514252 defendant More William husbandman 593815 593815 More, William, of Bradwey, husbandman 1
5531128 2514252 2514252 defendant Sondeford John husbandman 593815 593815 Sondeford, John, of Bradwey, husbandman 2
5531129 2514252 2514252 defendant Harreson George husbandman 593815 593815 Harreson, George, of Bradwey, husbandman 3
5531130 2514252 2514252 defendant More Henry laborer 593815 593815 More, Henry, of Bradwey, laborer 4
5531131 2514252 2514252 defendant Firkyns Robert laborer 593815 593815 Firkyns, Robert, of Bradwey, laborer 5
5532286 2514638 2514638 defendant Blancombe Robert husbandman 593815 593815 Blancombe, Robert, of Bradwey, husbandman 1
5551224 2520389 2520389 defendant Strayne Richard yeoman 593815 593815 Strayne, Richard, of Bradwey, yeoman 0
5551226 2520390 2520390 defendant Hyggyns Richard husbandman 593815 593815 Hyggyns, Richard, of Bradwey, husbandman 0
5555850 2521703 2521703 defendant Strayne Richard yeoman 593815 593815 Strayne, Richard, of Bradwey, yeoman 0
5560734 2523105 2523105 defendant Sedyngton Thomas butcher 593815 593815 Sedyngton, Thomas, of Bradwey, butcher 0
5560735 2523105 2523105 defendant Hogges Thomas husbandman 593815 593815 Hogges, Thomas, of Bradwey, husbandman 1
5560736 2523105 2523105 defendant Busshill William husbandman 593815 593815 Busshill, William, of Bradwey, husbandman 2
5572690 2526556 2526556 defendant Strayn Richard husbandman 593815 593815 Strayn, Richard, of Bradwey, husbandman 0
5580070 2528847 2528847 defendant Strayne Richard husbandman 593815 593815 Strayne, Richard, of Bradwey, husbandman 0
5584305 2530159 2530159 defendant Hoggys Thomas husbandman 593815 593815 Hoggys, Thomas, of Bradwey, husbandman 1
5588936 2531551 2531551 defendant Strayne Richard husbandman 593815 593815 Strayne, Richard, of Bradwey, husbandman 1
5589680 2531770 2531770 defendant Strayne Richard husbandman 593815 593815 Strayne, Richard, of Bradwey, husbandman 1
5596290 2533753 2533753 defendant Strane or Strave Richard husbandman 593815 593815 Strane or Strave, Richard, of Bradwey, husbandman 0
5598192 2534326 2534326 defendant Hoggys Thomas husbandman 593815 593815 Hoggys, Thomas, of Bradwey, husbandman 2
5598199 2534327 2534327 defendant Hoggys Thomas husbandman 593815 593815 Hoggys, Thomas, of Bradwey, husbandman 2

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);