names

76 rows where place_id = 599321

✎ 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
3636263 1906132 1906132 defendant Bowdok William gent 599321 599321 Bowdok, William, of Bromysgrove, gent 1
3672309 1917341 1917341 defendant Smyth Thomas yeoman 599321 599321 Smyth, Thomas, of Bromysgrove, yeoman 0
3741713 1939271 1939271 defendant Pachet Richard husbandman 599321 599321 Pachet, Richard, of Bromysgrove, husbandman 8
3742089 1939394 1939394 defendant Chaunce John yeoman 599321 599321 Chaunce, John, of Bromysgrove, yeoman 1
3742090 1939394 1939394 defendant Chaunce Nicholas yeoman 599321 599321 Chaunce, Nicholas, of Bromysgrove, yeoman 2
3742091 1939394 1939394 defendant Chaunce Kenelm yeoman 599321 599321 Chaunce, Kenelm, of Bromysgrove, yeoman 3
3742092 1939394 1939394 defendant Bradeley John draper 599321 599321 Bradeley, John, of Bromysgrove, draper 4
3751051 1942261 1942261 defendant Rychard John smith 599321 599321 Rychard, John, of Bromysgrove, smith 1
3777136 1950600 1950600 defendant Bradeley Richard husbandman 599321 599321 Bradeley, Richard, of Bromysgrove, husbandman 0
3781276 1951885 1951885 defendant Hyll Richard capper 599321 599321 Hyll, Richard, of Bromysgrove, capper 1
3781279 1951886 1951886 defendant Hyll Richard capper 599321 599321 Hyll, Richard, of Bromysgrove, capper 1
3792447 1955500 1955500 defendant Barnesley Nicholas gent 599321 599321 Barnesley, Nicholas, of Bromysgrove, gent 1
3797986 1957269 1957269 defendant Blankett Thomas miller 599321 599321 Blankett, Thomas, of Bromysgrove, miller 1
3798945 1957583 1957583 defendant Chekett Humphrey laborer 599321 599321 Chekett, Humphrey, of Bromysgrove, laborer 1
3798948 1957583 1957583 defendant Hogys Roger husbandman 599321 599321 Hogys, Roger, of Bromysgrove, husbandman 4
3801697 1958426 1958426 defendant Hoggys John tanner 599321 599321 Hoggys, John, of Bromysgrove, tanner 3
3804752 1959433 1959433 defendant Chanunce John husbandman 599321 599321 Chanunce, John, of Bromysgrove, husbandman 0
3804753 1959433 1959433 defendant Fulke Walter husbandman 599321 599321 Fulke, Walter, of Bromysgrove, husbandman 1
3804757 1959434 1959434 defendant Chaunce John husbandman 599321 599321 Chaunce, John, of Bromysgrove, husbandman 0
3808899 1960662 1960662 defendant Roby William baker 599321 599321 Roby, William, of Bromysgrove, baker 1
3811632 1961536 1961536 defendant Parkys Richard nailer 599321 599321 Parkys, Richard, of Bromysgrove, nailer 1
3811633 1961536 1961536 defendant Faukes Henry husbandman 599321 599321 Faukes, Henry, of Bromysgrove, husbandman 2
3811634 1961536 1961536 defendant Estmare Thomas husbandman 599321 599321 Estmare, Thomas, of Bromysgrove, husbandman 3
3816430 1963050 1963050 defendant Grove Thomas barker 599321 599321 Grove, Thomas, of Bromysgrove, barker 0
3816431 1963050 1963050 defendant Bradeley John draper 599321 599321 Bradeley, John, of Bromysgrove, draper 1
3817035 1963239 1963239 defendant Blyk Thomas cooper 599321 599321 Blyk, Thomas, of Bromysgrove, cooper 0
3825596 1965856 1965856 defendant Blanket Thomas husbandman 599321 599321 Blanket, Thomas, of Bromysgrove, husbandman 1
3831114 1967617 1967617 defendant Bradley Richard yeoman 599321 599321 Bradley, Richard, of Bromysgrove, yeoman 0
3831818 1967849 1967849 defendant Carpenter Richard husbandman 599321 599321 Carpenter, Richard, of Bromysgrove, husbandman 4
3834352 1968687 1968687 defendant Barnesley Nicholas gent 599321 599321 Barnesley, Nicholas, of Bromysgrove, gent 1
3834992 1968884 1968884 defendant Bradley John draper 599321 599321 Bradley, John, of Bromysgrove, draper 0
3834994 1968884 1968884 defendant Blankett Thomas miller 599321 599321 Blankett, Thomas, of Bromysgrove, miller 2
3835488 1969039 1969039 defendant Bocher David butcher 599321 599321 Bocher, David, of Bromysgrove, butcher 0
3847365 1972738 1972738 defendant Hancok Richard tanner 599321 599321 Hancok, Richard, of Bromysgrove, tanner 0
3847366 1972738 1972738 defendant Butler John yeoman 599321 599321 Butler, John, of Bromysgrove, yeoman 1
3863666 1978032 1978032 defendant Fletcher Thomas tailor 599321 599321 Fletcher, Thomas, of Bromysgrove, tailor 2
3863667 1978032 1978032 defendant Harpecote Richard tanner 599321 599321 Harpecote, Richard, of Bromysgrove, tanner 3
3864388 1978287 1978287 defendant Lee William yeoman 599321 599321 Lee, William, of Bromysgrove, yeoman 0
3864389 1978287 1978287 defendant Vaughan John laborer 599321 599321 Vaughan, John, of Bromysgrove, laborer 1
3876699 1982450 1982450 defendant Hyll Richard yeoman 599321 599321 Hyll, Richard, of Bromysgrove, yeoman 0
3876700 1982450 1982450 defendant Chaunce Richard husbandman 599321 599321 Chaunce, Richard, of Bromysgrove, husbandman 1
3887590 1986099 1986099 defendant Underhyll Thomas butcher 599321 599321 Underhyll, Thomas, of Bromysgrove, butcher 2
3888350 1986366 1986366 defendant Persall William butcher 599321 599321 Persall, William, of Bromysgrove, butcher 0
3889641 1986767 1986767 defendant Blycke Thomas cooper 599321 599321 Blycke, Thomas, of Bromysgrove, cooper 0
3889643 1986768 1986768 defendant Bradeley John draper 599321 599321 Bradeley, John, of Bromysgrove, draper 0
3903257 1991314 1991314 defendant Bradley John yeoman 599321 599321 Bradley, John, of Bromysgrove, yeoman 0
3903259 1991314 1991314 defendant Freman Robert weaver 599321 599321 Freman, Robert, of Bromysgrove, weaver 2
3905019 1991943 1991943 plaintiff Ince Margaret widow 599321 599321 Ince, Margaret, of Bromysgrove, widow 0
3911660 1994221 1994221 defendant Bradeley Nicholas   599321 599321 Bradeley, Nicholas, of Bromysgrove, "corser" 2
3916794 1995983 1995983 defendant Brace John husbandman 599321 599321 Brace, John, of Bromysgrove, husbandman 0
3916795 1995983 1995983 defendant Carpenter Richard husbandman 599321 599321 Carpenter, Richard, of Bromysgrove, husbandman 1
3916796 1995983 1995983 defendant Hykys John cooper 599321 599321 Hykys, John, of Bromysgrove, cooper 2
3927488 1999538 1999538 defendant Asteley Richard tanner 599321 599321 Asteley, Richard, of Bromysgrove, tanner 0
3933775 2001590 2001590 defendant Hyll Henry husbandman 599321 599321 Hyll, Henry, of Bromysgrove, husbandman 3
3956414 2009304 2009304 defendant Sturmy Roger   599321 599321 Sturmy, Roger, of Bromysgrove, or of Chadsley Corbett, scythe smith 0
3956416 2009305 2009305 defendant Sturmy Roger   599321 599321 Sturmy, Roger, of Bromysgrove, scythe smith 0
3969190 2013833 2013833 defendant Burley William weaver 599321 599321 Burley, William, of Bromysgrove, weaver 0
4786271 2291749 2291749 defendant Herton John butcher 599321 599321 Herton, John, of Bromysgrove, butcher 1
4976175 2349828 2349828 defendant Clyve Thomas husbandman 599321 599321 Clyve, Thomas, of Bromysgrove, husbandman 4
5009161 2359565 2359565 defendant Cawode Reginald yeoman 599321 599321 Cawode, Reginald, of Bromysgrove, yeoman 0
5115334 2390913 2390913 defendant Dypull John husbandman 599321 599321 Dypull, John, of Bromysgrove, husbandman 0
5124013 2393478 2393478 defendant Chaunse Henry husbandman 599321 599321 Chaunse, Henry, of Bromysgrove, husbandman 0
5124014 2393478 2393478 defendant Chaunse John   599321 599321 Chaunse, John, of Bromysgrove, servant 1
5242894 2428124 2428124 defendant Decon William husbandman 599321 599321 Decon, William, of Bromysgrove, husbandman 0
5242895 2428124 2428124 defendant Fewore John husbandman 599321 599321 Fewore, John, of Bromysgrove, husbandman 1
5242896 2428124 2428124 defendant Botiller Margaret widow 599321 599321 Botiller, Margaret, of Bromysgrove, widow 2
5307402 2447221 2447221 defendant Leycetur William gent 599321 599321 Leycetur, William, of Bromysgrove, gent 0
5311253 2448392 2448392 defendant W_ William laborer 599321 599321 W_, William, of Bromysgrove, laborer 0
5338652 2456659 2456659 defendant Bodoke William husbandman 599321 599321 Bodoke, William, of Bromysgrove, husbandman 0
5338653 2456659 2456659 defendant Hyhyns Roger butcher 599321 599321 Hyhyns, Roger, of Bromysgrove, butcher 1
5347983 2459510 2459510 defendant Bondokke John yeoman 599321 599321 Bondokke, John, of Bromysgrove, yeoman 0
5394704 2473545 2473545 defendant Bowcer Humphrey tanner 599321 599321 Bowcer, Humphrey, of Bromysgrove, tanner 0
5394714 2473548 2473548 defendant Grene John butcher 599321 599321 Grene, John, of Bromysgrove, butcher 0
5394725 2473553 2473553 defendant Lynehale Thomas   599321 599321 Lynehale, Thomas, of Bromysgrove, millward 0
5403661 2476114 2476114 defendant Bowcer or Bowter Humphrey tanner 599321 599321 Bowcer or Bowter, Humphrey, of Bromysgrove, tanner 0
5593325 2532890 2532890 defendant Bamford James husbandman 599321 599321 Bamford, James, of Bromysgrove, 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);