names

77 rows where place_id = 587499

✎ 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
3591580 1864992 1864992 defendant Lenthale Richard husbandman 587499 587499 Lenthale, Richard, of Hardwyk, husbandman 0
3591581 1864992 1864992 defendant ap Jenkyn John husbandman 587499 587499 ap Jenkyn, John, of Hardwyk, husbandman 1
3595263 1866153 1866153 defendant Bothe John   587499 587499 Bothe, John, of Hardwyk, knight 0
3638349 1906812 1906812 defendant Dyxson Robert husbandman 587499 587499 Dyxson, Robert, of Hardwyk, husbandman 2
3683811 1921072 1921072 defendant Hartland Richard husbandman 587499 587499 Hartland, Richard, of Hardwyk, husbandman 0
3683812 1921072 1921072 defendant Soundes John husbandman 587499 587499 Soundes, John,of Hardwyk, husbandman 1
3688976 1922711 1922711 defendant Broun Archibald yeoman 587499 587499 Broun, Archibald, of Hardwyk, yeoman 0
3720903 1932833 1932833 plaintiff Jubbe Robert   587499 587499 Jubbe, Robert, of Hardwyk 0
3736702 1937732 1937732 plaintiff Jubbe Robert   587499 587499 Jubbe, Robert, of Hardwyk 0
3737827 1938051 1938051 defendant Cauntwell Thomas clerk 587499 587499 Cauntwell, Thomas, of Hardwyk, clerk 0
3755520 1943682 1943682 defendant Hervy George husbandman 587499 587499 Hervy, George, of Hardwyk, husbandman 0
3755521 1943682 1943682 defendant Hervy John husbandman 587499 587499 Hervy, John, of Hardwyk, husbandman 1
3764771 1946647 1946647 defendant Boyer Richard husbandman 587499 587499 Boyer, Richard, of Hardwyk, husbandman 0
3776587 1950425 1950425 defendant Hunt Thomas pardoner 587499 587499 Hunt, Thomas, of Hardwyk, pardoner 0
3776589 1950425 1950425 defendant Hunt Anne spinster 587499 587499 Hunt, Anne, of Hardwyk, spinster 2
3776590 1950425 1950425 defendant Hunt Joan spinster 587499 587499 Hunt, Joan, of Hardwyk, spinster 3
3798130 1957311 1957311 plaintiff Hamyldon William gent 587499 587499 Hamyldon, William, of Hardwyk, gent 0
3800004 1957924 1957924 defendant Clemens Thomas husbandman 587499 587499 Clemens, Thomas, of Hardwyk, husbandman 2
3801827 1958465 1958465 defendant Knape Thomas butcher 587499 587499 Knape, Thomas, of Hardwyk, butcher 1
3801828 1958465 1958465 defendant Kendale William butcher 587499 587499 Kendale, William, of Hardwyk, butcher 2
3891538 1987434 1987434 defendant Malett Thomas husbandman 587499 587499 Malett, Thomas, of Hardwyk, husbandman 0
3922094 1997716 1997716 defendant Howell Henry husbandman 587499 587499 Howell, Henry, of Hardwyk, husbandman 3
3937136 2002754 2002754 defendant Mast William husbandman 587499 587499 Mast, William, of Hardwyk, husbandman 2
4051241 2042883 2042883 defendant Whytney James   587499 587499 Whytney, James, of Hardwyk, gent, son of Richard 0
4477603 2193662 2193662 defendant Bakere John   587499 587499 Bakere, John, of Hardwyk 0
4673502 2257346 2257346 defendant Asptlon John husbandman 587499 587499 Asptlon, John, of Hardwyk, husbandman 0
4789812 2292881 2292881 defendant Mathewson Robert yeoman 587499 587499 Mathewson, Robert, of Hardwyk, yeoman 0
4797929 2295534 2295534 defendant Haliday John husbandman 587499 587499 Haliday, John, of Hardwyk, husbandman 2
4849647 2311368 2311368 defendant Jakson Robert husbandman 587499 587499 Jakson, Robert, of Hardwyk, husbandman 0
4849648 2311368 2311368 defendant Jakson John, sen   587499 587499 Jakson, John, sen, of Hardwyk, servant 1
4872833 2318454 2318454 defendant Austyn John husbandman 587499 587499 Austyn, John, of Hardwyk, husbandman 1
4883985 2321899 2321899 defendant Capper Richard husbandman 587499 587499 Capper, Richard, of Hardwyk, husbandman 0
4968633 2347586 2347586 defendant Pappe Nicholas laborer 587499 587499 Pappe, Nicholas, of Hardwyk, laborer 0
4968635 2347587 2347587 defendant Pappe Nicholas laborer 587499 587499 Pappe, Nicholas, of Hardwyk, laborer 0
5007174 2358988 2358988 defendant Halle John laborer 587499 587499 Halle, John, of Hardwyk, laborer 3
5046237 2370504 2370504 defendant Wortley William gent 587499 587499 Wortley, William, of Hardwyk, gent 0
5052219 2372268 2372268 defendant Wortley William gent 587499 587499 Wortley, William, of Hardwyk, gent 0
5096505 2385410 2385410 defendant Pelly John gent 587499 587499 Pelly, John, of Hardwyk, gent 0
5108771 2389001 2389001 defendant Sutton William husbandman 587499 587499 Sutton, William, of Hardwyk, husbandman 0
5132001 2395847 2395847 defendant Pyerpoint Roger esq 587499 587499 Pyerpoint, Roger, of Hardwyk, esq 0
5153500 2402177 2402177 defendant Theystell Roger husbandman 587499 587499 Theystell, Roger, of Hardwyk, husbandman 1
5188926 2412496 2412496 defendant Turnour John husbandman 587499 587499 Turnour, John, of Hardwyk, husbandman 0
5188927 2412496 2412496 defendant Thystell Roger husbandman 587499 587499 Thystell, Roger, of Hardwyk, husbandman 1
5204037 2416932 2416932 defendant Jakeman William yeoman 587499 587499 Jakeman, William, of Hardwyk, yeoman 1
5204038 2416932 2416932 defendant Jakeman John yeoman 587499 587499 Jakeman, John, of Hardwyk, yeoman 2
5218822 2421230 2421230 defendant Pelley John esq 587499 587499 Pelley, John, of Hardwyk, esq 1
5220020 2421566 2421566 defendant Halyday William husbandman 587499 587499 Halyday, William, of Hardwyk, husbandman 6
5250847 2430376 2430376 defendant Wortley William gent 587499 587499 Wortley, William, of Hardwyk, gent 0
5331746 2454579 2454579 defendant Pye Richard   587499 587499 Pye, Richard, of Hardwyk, wright 3
5342489 2457848 2457848 defendant Laneman John husbandman 587499 587499 Laneman, John, of Hardwyk, husbandman 3
5366120 2465066 2465066 defendant West William husbandman 587499 587499 West, William, of Hardwyk, husbandman 0
5366482 2465172 2465172 defendant Fendyk William husbandman 587499 587499 Fendyk, William, of Hardwyk, husbandman 0
5366484 2465173 2465173 defendant Fendyk William husbandman 587499 587499 Fendyk, William, of Hardwyk, husbandman 0
5381161 2469669 2469669 defendant Halyday John yeoman 587499 587499 Halyday, John, of Hardwyk, yeoman 3
5394497 2473487 2473487 defendant Jakson George husbandman 587499 587499 Jakson, George, of Hardwyk, husbandman 0
5408418 2477489 2477489 defendant Ombersley Richard yeoman 587499 587499 Ombersley, Richard, of Hardwyk, yeoman 1
5411369 2478359 2478359 defendant Corbrond John yeoman 587499 587499 Corbrond, John, of Hardwyk, yeoman 0
5413403 2478937 2478937 defendant Myot Robert yeoman 587499 587499 Myot, Robert, of Hardwyk, yeoman 1
5413404 2478937 2478937 defendant Godfrey Henry laborer 587499 587499 Godfrey, Henry, of Hardwyk, laborer 2
5413405 2478937 2478937 defendant Halyday John yeoman 587499 587499 Halyday, John, of Hardwyk, yeoman 3
5458633 2492474 2492474 defendant Myot Robert yeoman 587499 587499 Myot, Robert, of Hardwyk, yeoman 1
5458634 2492474 2492474 defendant Godfrey Henry laborer 587499 587499 Godfrey, Henry, of Hardwyk, laborer 2
5458635 2492474 2492474 defendant Halyday John yeoman 587499 587499 Halyday, John, of Hardwyk, yeoman 3
5458640 2492475 2492475 defendant Myot Robert yeoman 587499 587499 Myot, Robert, of Hardwyk, yeoman 1
5458641 2492475 2492475 defendant Godfrey Henry laborer 587499 587499 Godfrey, Henry, of Hardwyk, laborer 2
5458642 2492475 2492475 defendant Halyday John yeoman 587499 587499 Halyday, John, of Hardwyk, yeoman 3
5470270 2496027 2496027 defendant Myot Robert yeoman 587499 587499 Myot, Robert, of Hardwyk, yeoman 1
5470271 2496027 2496027 defendant Godfrey Henry laborer 587499 587499 Godfrey, Henry, of Hardwyk, laborer 2
5470272 2496027 2496027 defendant Halyday John yeoman 587499 587499 Halyday, John, of Hardwyk, yeoman 3
5475084 2497534 2497534 defendant Warner William husbandman 587499 587499 Warner, William, of Hardwyk, husbandman 0
5522149 2511742 2511742 plaintiff Curteys Thomas yeoman 587499 587499 Curteys, Thomas, of Hardwyk, yeoman 0
5535041 2515491 2515491 defendant Shotysward Thomas husbandman 587499 587499 Shotysward, Thomas, of Hardwyk, husbandman 2
5539548 2516846 2516846 defendant Hall William husbandman 587499 587499 Hall, William, of Hardwyk, husbandman 0
5548566 2519621 2519621 defendant Pye Robert husbandman 587499 587499 Pye, Robert, of Hardwyk, husbandman 0
5580358 2528939 2528939 plaintiff Bynnyng Robert clerk 587499 587499 Bynnyng, Robert, of Hardwyk, clerk 0
5587456 2531092 2531092 defendant Mathew Thomas tailor 587499 587499 Mathew, Thomas, of Hardwyk, tailor 2
5590720 2532072 2532072 defendant Graunt William gent 587499 587499 Graunt, William, of Hardwyk, 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);