names

48 rows where place_id = 601544

✎ 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
3645795 1909088 1909088 defendant Lamborn William roper 601544 601544 Lamborn, William, of Chelmysford, roper 0
3645796 1909088 1909088 defendant Dowe John   601544 601544 Dowe, John, of Chelmysford, pale maker 1
3645797 1909088 1909088 defendant Crowghall Hugh tailor 601544 601544 Crowghall, Hugh, of Chelmysford, tailor 2
3700441 1926376 1926376 defendant Rawlyns William innholder 601544 601544 Rawlyns, William, of Chelmysford, innholder 0
3822150 1964823 1964823 defendant Monke Robert   601544 601544 Monke, Robert, of Chelmysford, tallow chandler 1
3834444 1968721 1968721 defendant Redham Robert butcher 601544 601544 Redham, Robert, of Chelmysford, butcher 0
3834445 1968721 1968721 defendant Plesaunce John husbandman 601544 601544 Plesaunce, John, of Chelmysford, husbandman 1
3834447 1968721 1968721 defendant Maryon Agnes widow 601544 601544 (Maryon, Agnes, of Chelmysford, widow 3
3834448 1968721 1968721 defendant Maryon Richard   601544 601544 Maryon, Richard, of Chelmysford, parish clerk 4
3836883 1969434 1969434 defendant Bowdon William grocer 601544 601544 Bowdon, William, of Chelmysford, grocer 0
3838119 1969837 1969837 plaintiff Tarvett alias Parmeter Robert   601544 601544 Tarvett alias Parmeter, Robert, of Chelmysford 0
3843988 1971662 1971662 defendant Knott Thomas, junior mercer 601544 601544 Knott, Thomas, junior, of Chelmysford, mercer 2
3843993 1971663 1971663 defendant Knott Thomas, junior mercer 601544 601544 Knott, Thomas, junior, of Chelmysford, mercer 2
3870736 1980457 1980457 defendant A Borowe Robert innkeeper 601544 601544 A Borowe, Robert, of Chelmysford, innkeeper 1
3878035 1982899 1982899 defendant Dowe John baker 601544 601544 Dowe, John, of Chelmysford, baker 0
3885111 1985278 1985278 defendant Clerke Christopher yeoman 601544 601544 Clerke, Christopher, of Chelmysford, yeoman 6
3904277 1991676 1991676 defendant Sadlyngton William husbandman 601544 601544 Sadlyngton, William, of Chelmysford, husbandman 0
3911350 1994113 1994113 defendant Awnsell John butcher 601544 601544 Awnsell, John, of Chelmysford, butcher 1
4020655 2032115 2032115 plaintiff Wolrey alias Hall Thomas   601544 601544 Wolrey alias Hall, Thomas, of Chelmysford, woollen draper 0
4054238 2043902 2043902 defendant Jones John laborer 601544 601544 Jones, John, of Chelmysford, laborer 0
4233500 2107233 2107233 defendant Watson Thomas   601544 601544 Watson, Thomas, of Chelmysford, apothecary 0
4237381 2108665 2108665 defendant Easte John miller 601544 601544 Easte, John, of Chelmysford, miller 0
4748171 2279973 2279973 defendant Tuft John yeoman 601544 601544 Tuft, John, of Chelmysford, yeoman 0
4856132 2313290 2313290 defendant Lyston Robert husbandman 601544 601544 Lyston, Robert, of Chelmysford, husbandman 0
4856133 2313290 2313290 defendant Roper John roper 601544 601544 Roper, John, of Chelmysford, roper 1
4856134 2313290 2313290 defendant Hayle Thomas furbisher 601544 601544 Hayle, Thomas, of Chelmysford, furbisher 2
4856135 2313290 2313290 defendant Manger William roper 601544 601544 Manger, William, of Chelmysford, roper 3
4876483 2319610 2319610 defendant Houchon John yeoman 601544 601544 Houchon, John, of Chelmysford, yeoman 0
4955958 2343748 2343748 defendant Fayrehere William husbandman 601544 601544 Fayrehere, William, of Chelmysford, husbandman 1
4986455 2352876 2352876 defendant Mawege William   601544 601544 Mawege, William, of Chelmysford, rope maker 0
5003473 2357912 2357912 defendant Chever Thomas glover 601544 601544 Chever, Thomas, of Chelmysford, glover 0
5012598 2360524 2360524 defendant Wynter Thomas esq 601544 601544 Wynter, Thomas, of Chelmysford, esq 0
5017425 2361985 2361985 defendant Boun Margaret widow 601544 601544 Boun, Margaret, of Chelmysford, widow 0
5019892 2362696 2362696 defendant Lyston Robert husbandman 601544 601544 Lyston, Robert, of Chelmysford, husbandman 0
5019893 2362696 2362696 defendant Brewer William clerk 601544 601544 Brewer, William, of Chelmysford, clerk 1
5050000 2371621 2371621 plaintiff Styward Thomas   601544 601544 Styward, Thomas, of Chelmysford 0
5058087 2373988 2373988 defendant Bysshop William husbandman 601544 601544 Bysshop, William, of Chelmysford, husbandman 1
5083476 2381557 2381557 defendant Leche Walter   601544 601544 Leche, Walter, of Chelmysford, surgeon 0
5124265 2393544 2393544 defendant Payne Robert baker 601544 601544 Payne, Robert, of Chelmysford, baker 0
5209369 2418476 2418476 defendant Spryngolde Thomas currier 601544 601544 Spryngolde, Thomas, of Chelmysford, currier 0
5295572 2443694 2443694 defendant Roper John skinner 601544 601544 Roper, John, of Chelmysford, skinner 0
5295573 2443694 2443694 defendant Syre Thomas cooper 601544 601544 Syre, Thomas, of Chelmysford, cooper 1
5319006 2450776 2450776 defendant Bygemore John butcher 601544 601544 Bygemore, John, of Chelmysford, butcher 0
5341852 2457646 2457646 defendant Woderove or Woderoffe Thomas innholder 601544 601544 Woderove or Woderoffe, Thomas, of Chelmysford, innholder 1
5361997 2463777 2463777 defendant Gayge Thomas carpenter 601544 601544 Gayge, Thomas, of Chelmysford, carpenter 4
5373154 2467200 2467200 defendant Haslay Edward tailor 601544 601544 Haslay, Edward, of Chelmysford, tailor 0
5374246 2467545 2467545 defendant Fayrer John mercer 601544 601544 Fayrer, John, of Chelmysford, mercer 0
5585925 2530651 2530651 defendant Bruer Christine widow 601544 601544 Bruer, Christine, of Chelmysford, widow 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);