names

44 rows where place_id = 597207

✎ 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
3627681 1903520 1903520 plaintiff Brett John   597207 597207 Brett, John, of Kedyngton 0
3812399 1961769 1961769 defendant Barnston Thomas, senior esq 597207 597207 Barnston, Thomas, senior, of Kedyngton, esq 0
3812401 1961769 1961769 defendant Brett John husbandman 597207 597207 (Brett, John, of Kedyngton, husbandman 2
3925347 1998790 1998790 defendant Bronde John husbandman 597207 597207 Bronde, John, of Kedyngton, husbandman 0
4440334 2181890 2181890 defendant Godchild Robert   597207 597207 Godchild, Robert, of Kedyngton 0
4484198 2195756 2195756 defendant Masun John   597207 597207 Masun, John, of Kedyngton 0
4499921 2200612 2200612 defendant Felyoe John   597207 597207 Felyoe, John, of Kedyngton 0
4499922 2200612 2200612 defendant Moneys John   597207 597207 Moneys, John, of Kedyngton 1
4536009 2211541 2211541 defendant Money John   597207 597207 Money, John, of Kedyngton 0
4555918 2217789 2217789 defendant Felice John   597207 597207 Felice, John, of Kedyngton 0
4568103 2221593 2221593 defendant Kedyngton Philip   597207 597207 Kedyngton, Philip, of Kedyngton 0
4578737 2224838 2224838 defendant Folf Henry   597207 597207 Folf, Henry, of Kedyngton 2
4578745 2224839 2224839 defendant Folk Henry   597207 597207 Folk, Henry, of Kedyngton 5
4605199 2232793 2232793 defendant Colyn Robert   597207 597207 Colyn, Robert, of Kedyngton 0
4639221 2242990 2242990 defendant Foke Henry   597207 597207 Foke, Henry, of Kedyngton 3
4641224 2243525 2243525 defendant Colyn Robert   597207 597207 Colyn, Robert, of Kedyngton 0
4671785 2256822 2256822 defendant Parker Thomas skinner 597207 597207 Parker, Thomas, of Kedyngton, skinner 0
4671786 2256822 2256822 defendant Smyth Thomas husbandman 597207 597207 Smyth, Thomas, of Kedyngton, husbandman 1
4696598 2264414 2264414 defendant Felice John husbandman 597207 597207 Felice, John, of Kedyngton, husbandman 0
4725037 2273126 2273126 defendant Thedilthrop John tanner 597207 597207 Thedilthrop, John, of Kedyngton, tanner 2
4735453 2276233 2276233 defendant Stevenes John yeoman 597207 597207 Stevenes, John, of Kedyngton, yeoman 1
4778052 2289122 2289122 defendant Felice John husbandman 597207 597207 Felice, John, of Kedyngton, husbandman 1
4873141 2318552 2318552 defendant Folke Henry husbandman 597207 597207 Folke, Henry, of Kedyngton, husbandman 1
4878535 2320233 2320233 defendant Folkus Henry husbandman 597207 597207 Folkus, Henry, of Kedyngton, husbandman 0
4879220 2320437 2320437 defendant Folke Henry husbandman 597207 597207 Folke, Henry, of Kedyngton, husbandman 0
4879222 2320438 2320438 defendant Whyte Thomas husbandman 597207 597207 Whyte, Thomas, of Kedyngton, husbandman 0
4904662 2328066 2328066 defendant Camvyle William mercer 597207 597207 Camvyle, William, of Kedyngton, mercer 0
4904663 2328066 2328066 defendant Sturdy John wheeler 597207 597207 Sturdy, John, of Kedyngton, wheeler 1
4975359 2349591 2349591 defendant Olyver Richard clerk 597207 597207 Olyver, Richard, of Kedyngton, clerk 0
4975360 2349591 2349591 defendant Colyn John dyer 597207 597207 Colyn, John, of Kedyngton, dyer 1
4975361 2349591 2349591 defendant Camvyle William husbandman 597207 597207 Camvyle, William, of Kedyngton, husbandman 2
4978086 2350409 2350409 defendant Colyn John dyer 597207 597207 Colyn, John, of Kedyngton, dyer 1
4985823 2352675 2352675 defendant Howys Robert husbandman 597207 597207 Howys, Robert, of Kedyngton, husbandman 1
4985825 2352675 2352675 defendant Penne Robert husbandman 597207 597207 Penne, Robert, of Kedyngton, husbandman 3
5090802 2383700 2383700 defendant Smethe Stephen husbandman 597207 597207 Smethe, Stephen, of Kedyngton, husbandman 2
5347106 2459255 2459255 defendant Rise Walter husbandman 597207 597207 Rise, Walter, of Kedyngton, husbandman 0
5355288 2461726 2461726 defendant Lyson John husbandman 597207 597207 Lyson, John, of Kedyngton, husbandman 0
5358825 2462822 2462822 defendant Master John laborer 597207 597207 Master, John, of Kedyngton, laborer 0
5362623 2463959 2463959 defendant Cotysford John yeoman 597207 597207 Cotysford, John, of Kedyngton, yeoman 0
5362626 2463959 2463959 defendant Camvyle Thomas husbandman 597207 597207 Camvyle, Thomas, of Kedyngton, husbandman 3
5486970 2500999 2500999 defendant Broun Robert laborer 597207 597207 Broun, Robert, of Kedyngton, laborer 0
5551796 2520570 2520570 defendant Churche Thomas laborer 597207 597207 Churche, Thomas, of Kedyngton, laborer 5
5577030 2527861 2527861 defendant Scherwode Robert   597207 597207 Scherwode, Robert, of Kedyngton, bark maker 0
5607137 2537122 2537122 defendant Wright Walter husbandman 597207 597207 Wright, Walter, of Kedyngton, 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);